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

Michael T. Dean mtdean at thirdcontact.com
Tue Feb 14 07:42:28 UTC 2006


On 02/14/2006 12:18 AM, Dag Nygren wrote:
>> I'm fairly certain the problem is somewhere in mythtv since it only
>> occurs with mythtv and restarting mysql doesn't fix anything.
>>
>> Where did you see a possible fix regarding timeouts?
>>
>> Using myth 0.19 didn't clear anything up.
>>> So was there a fix for this that I just can't find? I've just upgraded
>>> to mysql 5, and the random disconnections from the db are pretty
>>> annoying. I've seen some references to working around it with timeouts
>>> in mysql, but no decent details. So what's the situation with this
>>> problem? Does it go away with myth > 0.18.1? Where does the actual
>>> problem lie (myth or mysql)? Can anyone sum this issue up? Thanks,
> 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.
>   

So you're saying that explicitly closing and opening the connection 
isn't working?  http://svn.mythtv.org/trac/changeset/8856

> And to Sasha Z. Pleas don't top-post to a list. It screws up the logical flow
> of the discussion.
>   
And to Dag, as long as we're providing suggestions for better 
netiquette, please leave the appropriate attributions at the top of the 
message.

Mike


More information about the mythtv-users mailing list