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

Dag Nygren dag at newtech.fi
Tue Feb 14 05:18:34 UTC 2006


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

And to Sasha Z. Pleas don't top-post to a list. It screws up the logical flow
of the discussion.

Dag





More information about the mythtv-users mailing list