Running CVS as of 26-APR-03
I've been getting this error message for a couple days now, (multiple CVS
updates). I ran the cvs.sql update script too each time (when it was
updated).
Now it appear to be operating fine...but mythbackend is throwing lots of
database errors.
The errors started happening around my upgrade to RH9 (from a fully
functional, errorless RH8 setup).
The first error (through Can't open file) happens when a scheduled program
starts recording.
The second error happens when I delete an existing program from the
database.
-------
Changing from RecordingOnly to None
DB Error (blank frame list clear):
Query was:
DELETE FROM recordedmarkup WHERE chanid = '1004' AND starttime =
'20030423220000' AND type = 3;
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'recordedmarkup.MYD'. (errno: 145)
DB Error: recorded program deletion failed, SQL query was:
DELETE FROM recordedmarkup WHERE chanid = 1004 AND starttime =
20030423220000;
---------
The table definitely exists and is set to the same file
permissions/ownership as the other tables in the directory.
[root@localhost mythconverg]# ll recordedmarkup.*
-rw-rw---- 1 mysql mysql 8640 Mar 13 20:53 recordedmarkup.frm
-rw-rw---- 1 mysql mysql 417792 Apr 18 04:06 recordedmarkup.MYD
-rw-rw---- 1 mysql mysql 537600 Apr 18 12:44 recordedmarkup.MYI
[root@localhost mythconverg]# pwd
/var/lib/mysql/mythconverg
[root@localhost mythconverg]# rpm -q mysql
mysql-3.23.54a-11
I didn't see anyone else posting this to the dev or users list so I
figured it was some setup/config I missed as opposed to a bug.
--
Mark Covington
markcov@alumni.rice.edu
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
I've been getting this error message for a couple days now, (multiple CVS
updates). I ran the cvs.sql update script too each time (when it was
updated).
Now it appear to be operating fine...but mythbackend is throwing lots of
database errors.
The errors started happening around my upgrade to RH9 (from a fully
functional, errorless RH8 setup).
The first error (through Can't open file) happens when a scheduled program
starts recording.
The second error happens when I delete an existing program from the
database.
-------
Changing from RecordingOnly to None
DB Error (blank frame list clear):
Query was:
DELETE FROM recordedmarkup WHERE chanid = '1004' AND starttime =
'20030423220000' AND type = 3;
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'recordedmarkup.MYD'. (errno: 145)
DB Error: recorded program deletion failed, SQL query was:
DELETE FROM recordedmarkup WHERE chanid = 1004 AND starttime =
20030423220000;
---------
The table definitely exists and is set to the same file
permissions/ownership as the other tables in the directory.
[root@localhost mythconverg]# ll recordedmarkup.*
-rw-rw---- 1 mysql mysql 8640 Mar 13 20:53 recordedmarkup.frm
-rw-rw---- 1 mysql mysql 417792 Apr 18 04:06 recordedmarkup.MYD
-rw-rw---- 1 mysql mysql 537600 Apr 18 12:44 recordedmarkup.MYI
[root@localhost mythconverg]# pwd
/var/lib/mysql/mythconverg
[root@localhost mythconverg]# rpm -q mysql
mysql-3.23.54a-11
I didn't see anyone else posting this to the dev or users list so I
figured it was some setup/config I missed as opposed to a bug.
--
Mark Covington
markcov@alumni.rice.edu
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/