<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi folks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>006-05-11 10:55:30.478 Running
HouseKeeping<BR>2006-05-11 11:00:00.267 TVRec(1): Changing from RecordingOnly to
None<BR>2006-05-11 11:00:00.275 Finished recording Barney & Friends "Red,
Yellow and Blue!": channel 1009<BR>2006-05-11 11:00:00.285 Reschedule requested
for id 0.<BR>2006-05-11 11:00:00.394 DB Error (CheckTooMany):<BR>Query
was:<BR>SELECT recordid,title,maxepisodes,maxnewest FROM record;<BR>Driver error
was [2/2006]:<BR>QMYSQL3: Unable to execute query<BR>Database error
was:<BR>MySQL server has gone away</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2006-05-11 11:00:00.394 DB Error
(AddNotListed):<BR>Query was:<BR>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<BR>Driver error was [2/2006]:<BR>QMYSQL3: Unable to execute
query<BR>Database error was:<BR>MySQL server has gone away</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2006-05-11 11:00:00.394 Scheduled 0 items in 0.1 =
0.00 match + 0.11 place<BR>2006-05-11 11:00:00.397 Finished recording Barney
& Friends "Red, Yellow and Blue!": channel 1009<BR>0: start_time: 0.036
duration: 161.712<BR>1: start_time: 0.030 duration: 161.672<BR>stream:
start_time: 0.334 duration: 1796.862 bitrate=5196 kb/s<BR>2006-05-11
11:00:00.478 AFD: Opened codec 0x8511260, id(MPEG2VIDEO)
type(Video)<BR>2006-05-11 11:00:00.478 AFD: Opened codec 0x84fbf50, id(MP2)
type(Audio)<BR>2006-05-11 11:00:30.483 Running HouseKeeping<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>The mysqld server is up (this is on Fedora Core
5):</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[root@miffy jeff]# /etc/init.d/mysqld
status<BR>mysqld (pid 4737) is running...<BR>[root@miffy
jeff]# </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>To prove that it's really up:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[jeff@miffy ~]$ mysql -umythtv -p
mythconverg<BR>Enter password:<BR>Reading table information for completion of
table and column names<BR>You can turn off this feature to get a quicker startup
with -A</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Welcome to the MySQL monitor. Commands end
with ; or \g.<BR>Your MySQL connection id is 450 to server version:
5.0.18</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Type 'help;' or '\h' for help. Type '\c' to clear
the buffer.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> quit<BR>Bye<BR>[jeff@miffy
~]$</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>If I check the database with 'mysqlcheck -r
-u mythtv -p mythconverg', all looks good.</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>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.</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>My my.cnf file, if relevant,
is:</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>[jeff@miffy ~]$ cat
Backup/sysMods/mythtv/my.cnf<BR>[mysqld]<BR>datadir=/var/lib/mysql<BR>socket=/var/lib/mysql/mysql.sock<BR>#
Default to using old password format for compatibility with mysql 3.x<BR>#
clients (those using the mysqlclient10 compatibility
package).<BR>old_passwords=1</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>key_buffer = 16M<BR>table_cache =
128<BR>sort_buffer_size = 2M<BR>myisam_sort_buffer_size = 8M<BR>query_cache_size
= 16M</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT
size=2>skip-innodb<BR>set-variable=thread_stack=256k</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT
size=2>[mysql.server]<BR>user=mysql<BR>basedir=/var/lib</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT
size=2>[mysqld_safe]<BR>log-error=/var/log/mysqld.log<BR>pid-file=/var/run/mysqld/mysqld.pid<BR>[jeff@miffy
~]$</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>Any ideas or suggestions of how to
proceed? Again, if I restart the server, all looks fine (without touching
mysqld) ...</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance for any help,</FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2> --
Jeff</FONT></DIV></FONT></BODY></HTML>