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

[Jeff Coffler]

Hi folks,

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

2006-05-11 11:00:00.394 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 Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

2006-05-11 11:00:00.394 Scheduled 0 items in 0.1 2006-05-11 11:00:00.397 Finished recording Barney & Friends "Red, Yellow and Blue!": channel 1009
0: start_time: 0.036 duration: 161.712
1: start_time: 0.030 duration: 161.672
stream: start_time: 0.334 duration: 1796.862 bitrateQ96 kb/s
2006-05-11 11:00:00.478 AFD: Opened codec 0x8511260, id(MPEG2VIDEO) type(Video)
2006-05-11 11:00:00.478 AFD: Opened codec 0x84fbf50, id(MP2) type(Audio)
2006-05-11 11:00:30.483 Running HouseKeeping

The mysqld server is up (this is on Fedora Core 5):

[root at miffy jeff]# /etc/init.d/mysqld status
mysqld (pid 4737) is running...
[root at miffy jeff]# 

To prove that it's really up:

[jeff at miffy ~]$ mysql -umythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 450 to server version: 5.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
[jeff at miffy ~]$

If I check the database with 'mysqlcheck -r -u mythtv -p mythconverg', all looks good.

It's almost like the MythTV backend, for whatever reason when idle for a while, drops it's connection to the backend (and doesn't attempt to reconnect).  If I restart the backend, all is fine - for a while, until this happens again.

My my.cnf file, if relevant, is:

[jeff at miffy ~]$ cat Backup/sysMods/mythtv/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

key_buffer table_cache sort_buffer_size myisam_sort_buffer_size query_cache_size 
skip-innodb
set-variable=thread_stack%6k

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[jeff at miffy ~]$

Any ideas or suggestions of how to proceed?  Again, if I restart the server, all looks fine (without touching mysqld) ...

Thanks in advance for any help,

    -- Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060511/792a81f9/attachment.htm