Mailing List Archive

Can't open file: 'recordedmarkup.MYD'
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
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

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 =

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

[root@localhost mythconverg]# rpm -q mysql

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

This mail sent through IMP: