Some more information, it can't access the scheduled recordings list, but it has no problems getting the recorded programs table. This is seriously strange, and I have no possible explanation.
Someone... anyone... help? On 11/28/05, Sasha Z <[EMAIL PROTECTED]> wrote: > I seem to be losing the database connection before some recordings, > but not all. Mysql is *not* dying, and I am able to open and > manipulate the database via the mysql console without trouble. > Mythbackend itself isn't crashing either, it's just no longer able to > communicate with the database. > > Mysql logs show no errors on that end, and I don't have to restart > mysqld to make things work. I _only_ have to restart mythbackend. I'm > running SVN from today. mysql is version 5.0.16. It happens rather > suspiciously on the first recording after a listings update... this is > common. > > Here's a snippet of the log when it dies: > > 2005-11-28 13:15:26.270 New DB connection, total: 5 > Data for source cleared... > Main temp tables populated. Updating myth channels... > Updating icons for sourceid: 1 > Channels updated.. Updating programs... > Adjusting program database end times... > 0 replacements made. > Marking generic episodes... found 794 > Marking repeats... found 2100 > Unmarking new episode rebroadcast repeats... found 11 > > Attempting to contact the master backend for rescheduling. > If the master is not running, rescheduling will happen when > the master backend is restarted. > 2005-11-28 13:15:30.079 Connecting to backend server: 192.168.1.8:6543 > (try 1 of 5) > 2005-11-28 13:15:30.097 Using protocol version 22 > 2005-11-28 13:15:30.108 adding: mythbe01 as a client (events: 0) > 2005-11-28 13:15:30.150 Unknown socket closing > 2005-11-28 14:29:41.783 TVRec(2): Changing from None to RecordingOnly > 2005-11-28 14:29:41.784 Global TVFormat Setting 'NTSC' > 2005-11-28 14:29:41.785 Channel(/dev/v4l/video1): SetFormat(Default) > fmt(NTSC) input(4) > 2005-11-28 14:29:41.787 Channel(/dev/v4l/video1): SetFormat(Default) > fmt(NTSC) input(4) > 2005-11-28 14:29:41.967 DB Error (KickDatabase): > Query was: > SELECT NULL; > Driver error was [2/2006]: > QMYSQL3: Unable to execute query > Database error was: > MySQL server has gone away > _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users