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

[Bruce Markey]

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)

Do you have multiple backends or or at least two tuners?
If so this is a scheduler bug where the same show get
recorded by two tuners as the same time. The inserts
fail for the one of the recordings after the other beats
it to the punch. The 'blank frame list insert' entries are
interesting because both recorders are finding the same
blank frame.

If you have backends on two different machines, check to
see if you have a file 53_5320030325140000_2000303251430000.nuv
on each machine. However, I see your hostname is localhost
so if both tuners are on the same machine, the file would
be badly damaged (but I haven't seen the duplicate recording
on the same dual tuner machine thus far).

When a show gets handed off to an encoder to be recorded, it
is removed from the list of things to record. However, every
once in a while, the scheduler immediately puts it back in the
list and assigns it to another encoder. I haven't found the
cause of why this happens.

--  bjm


> 
> 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