[mythtv-users] Scheduling problems (SQL errors) on new MythTV installation ...

[Michael T. Dean]

On 05/11/2006 05:09 PM, Jeff Coffler wrote:
> I just installed MythTV v0.19 from the .tar file and build it.  I 
> haven't installed from SVN to get the latest/greatest patches; I'll do 
> that if that's what you folks suggest.
>  
> After the server has been up for a while, and after some shows record 
> (or after I sometimes schedule shows), I get some SQL errors.  The 
> /var/log/mysqld.log has no errors at all.  Please don't comment on the 
> content - it's for my kids!  Anyway, here's what I see in the logs for 
> mythtv:
>  
> 006-05-11 10:55:30.478 Running HouseKeeping
> 2006-05-11 11:00:00.267 TVRec(1): Changing from RecordingOnly to None
> 2006-05-11 11:00:00.275 Finished recording Barney & Friends "Red, 
> Yellow and Blue!": channel 1009
> 2006-05-11 11:00:00.285 Reschedule requested for id 0.
> 2006-05-11 11:00:00.394 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

Use 0.19-fixes or convince your packager to do so...

Mike