[mythtv-users] MythTV likes to forget about upcomming recordings

[Ed Martin]

i don't know why, but it seems that every time something is successfully 
recorded mythtv will just forget about all the recordings that are 
scheduled, it seems to happen just after one of the recordings that was 
scheduled is recorded

for example i lets say that i schedule 20 things to get recorded, after 
scheduling these i can go to "view upcoming recordings", and i can see 
all 20 scheduled recordings, then the next day i check my recordings and 
find out that only one thing was recorded, and on top of that "view 
upcoming recordings" shows absolutely nothing, saying that i haven't 
scheduled anything. so i go to watch tv, and look for them, nothing 
shows, so then i select something and set it to record, but the 
interface will not respond to me trying to set, its like i'm hitting a 
key that is not mapped to something, when i am actually hitting `r` 
which i use all the time to make something record, trying to do it from 
a menu yields the same results

then after restarting the back end i check everything again and all my 
recordings that weren't there and now suddenly all there, this is 
getting very frustrating and only started happening after upgrading to 
0.19, i think i was at 0.18.1 before that

any clues as to what is happening? here is the output of mythbackend 
around the time it last happened, are those errors bad, or does it retry 
after it loses the MySQL connection? is there any way to fix this?

(BTW, the movie was on channel 73 (or around there), not 1073, not sure 
if that matters)

2006-03-06 09:12:00.558 TVRec(1): Changing from RecordingOnly to None
2006-03-06 09:12:00.602 Finished recording The Lord of the Rings: The 
Return of the King: channel 1073
2006-03-06 09:12:00.622 Reschedule requested for id 0.
2006-03-06 09:12:00.623 DB Error (CheckTooMany):
Query was:
SELECT recordid,title,maxepisodes,maxnewest FROM record;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2006-03-06 09:12:00.623 DB Error (AddNotListed):
Query was:
SELECT record.recordid, record.type, record.chanid, record.starttime, 
record.startdate, record.endtime, record.enddate, record.startoffset, 
record.endoffset, record.title, record.subtitle, record.description, 
channel.channum, channel.callsign, channel.name FROM record  INNER JOIN 
channel ON (channel.chanid = record.chanid)  LEFT JOIN recordmatch on 
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 7) AND 
recordmatch.chanid IS NULL
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2006-03-06 09:12:00.623 Scheduled 0 items in 0.0 = 0.00 match + 0.00 place
2006-03-06 09:12:00.809 Finished recording The Lord of the Rings: The 
Return of the King: channel 1073