[mythtv-users] Mythbackend losing connection to MySQL

[Andrew Ingram]

Hi guys.

I've done a search on this and turned up:
http://www.gossamer-threads.com/lists/mythtv/users/164194#164194
and:
http://www.mythtv.org/pipermail/mythtv-users/2006-February/125242.html

So it's all be discussed. However, the consensus from those threads is that
it was fixed in 0.19 onwards. I'm running 0.19 source tarballs from the
MythTV website under Debian Sid with MySQL 5.0.22 and it's definitely still
happening:

SELECT record.recordid, record.type, record.chanid, record.starttime,
record.startdate, record.endtime, record.enddate, record.sta
rtoffset, record.endoffset, record.title, record.subtitle,
record.description, channel.channum, channel.callsign, channel.name FRO
M 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

And

2006-07-01 12:34:17.053 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

So there is definitely still a problem there. Has anyone found a solution?
Was Isaac meaning it's fixed in 0.19-fixes rather than 0.19? It's happening
about once a day at the moment, but at differing times which makes it a real
nightmare. Any help would be appreciated.

Regards,
Andrew