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

[Isaac Richards]

On Tuesday 14 February 2006 16:31, Sasha Z wrote:
> On 2/14/06, Isaac Richards <ijr at case.edu> 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.
>
> That changeset seems to be doing the trick for me... though it was
> quite broken in 0.19 itself. It may be a little early to pass
> judgement, but all indicators are looking good right now.

That changeset is part of 0.19.

Isaac