[mythtv-users] None

Mark Covington markcov at alumni.rice.edu
Mon Apr 28 11:46:49 EDT 2003


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 at 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 at localhost mythconverg]# pwd
/var/lib/mysql/mythconverg

[root at 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 at alumni.rice.edu

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


More information about the mythtv-users mailing list