[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.
> 
> Isaac

That's good to hear, thanks. I guess I'll have to upgrade right away then.

Nathan