[mythtv] DB Error (blank frame list insert) and ERROR:file I/O problem in 'safe read'

[Chris]

Looks like this is an uncommon problem.  If the problem is unique to my
database, maybe I can delete it and create a new one.  However i want to
know how i can transfer my recorded programs to the new database.  I
tried copying the recorded* files from the old mythconverg to the new
mythconverg.  While I can access most files in the Watch a Recording
menu, some files are indicated as missing.  Also the mythbackend
complains that it couldn't find the backed for : <program name> but it
can still play it.  What other files must I transfer from
/var/lib/mysql/mythconvergold to /var/lib/mysql/mythconverg? There are
only a few missing programs which I can live without.  I just want to be
able to fix the error messages from mythbackend.
 

 Thanks.



On Tue, 2003-03-25 at 18:33, Chris wrote:
> My mythbackend has been having this trouble :
> ( I retyped it from the console output. Cant seem to be able to pipe it
> to a file)
> 
> 
> DB error (WriteRecordedToDB):
> Query was:
> INSERT INTO recorded
> (chanid,starttime,endtime,title,subtitle,description,hostname)
> VALUES(53, "20030325140000","2000303251430000","TechLive","",Interior of
> a keyboard.","localhost.localdomain");
> Driver error was:
> Duplicate entry '53-20030325140000' for key 1
> DB Error (doneRecording);
> Query was:
> INSERT INTO oldrecorded (chanid,
> starttime,endtime,title,subtitle,description)
> VALUES(53,"2003-03-25T14:00:00","2003-03-25T14:30:00","TechLive","","Interior of a keyboard.");
> QMYSQL#: Unable to execute query
> Database error was:
> Duplicate entry '53-20030325140000' for key 1
> audio volume set to '32768'
> DB Error (blank frame list insert):
> Query was:
> INSERT recordedmarkup (chanid, starttime, mark, type) values ('53',
> '20030325140000', 15317, 3):
> Driver error was:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '53-20030325140000-15317-3' for key 1
> DB Error (blank frame list insert):
> Query was:
> Duplicate entry '53-20030325140000-15695-3' for key 1
> 
> 
> 
> 
> The show above gets recorded and I can view it but when I try to fast
> forward or rewind, mythfrontend crashes with the following error
> message:
> 
> Error: file I/O problem in 'safe_read()'
> :Bad addresss
> Error: file I/O problem in 'safe_read()'
> :Bad addresss
> Error: file I/O problem in 'safe_read()'
> :Bad addresss
> Changing from WatchingPreRecorded to None
> Segmentation fault
> 
> Anybody have any ideas as to what is causing this and how to fix it? 
> This is my only major problem with mythtv .8. Otherwise it would be a
> stable replacement for mythtv .7 for me.   I did not have this problem
> in Myth .7.  I thought initially that it was an audio issue (it might
> be, i dont know)  but even after a switch to btaudio for my tv wonder
> pci and an upgrade to bttv and up2date all current redhat rpms,i still
> get this problem.
> 
>  Also how can I make mythtv forget about the old recordings.  It
> suppresses some recordings because they have been recorded before.  It
> would be nice If i can turn this off on a per recording basis. If not I
> would rather just turn it off altogether.  
> 
> Thanks
-- 
Chris <cisip at sprintmail.com>