[mythtv-users] Mythbackend losing sql connection on the start of some recordings

[Nathan Howell]

Isaac Richards wrote:
> On Tuesday 14 February 2006 16:02, Nathan Howell wrote:
>> Dag Nygren wrote:
>>> The reason for this is that mysql did an automatic reconnect in pre
>>> 5.0.xx versions.
>>> In versions newer than 5.0.15 there is a connection parameter you should
>>> set to get this behaviour.
>>> The Qt interface to MySQL doesn't give you a way to set it though and so
>>> MythTV has a difficult time using this feature without bypassing QtSQL.
>>>
>>> The timeout changes are really just bandaid for the problem.
>> Finally, a description of the problem :-). Thank you. So, has anyone
>> filed a bug with or talked to the qt mysql driver folks about it? (I
>> know, it's obvious, but it's a frustrating problem, so I've got to ask...)
> 
> It should work fine in 0.19.  I ran for a while with the mysql server idle 
> timeouts set to 5 seconds, so it was timing out and reconnecting all the 
> time.  Didn't have any issues.

Well, after upgrading to 0.19 I had no problems for a few days, and I 
was about to send a message about it... but then I checked the log one 
more time and there was the dreaded message:

2006-02-20 18:17:40.798 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

There were a few errors for different queries. They're much less 
frequent, at least. With 0.18.1 it was happening 2-3 times per day.

Nathan