[rt-users] RT loses MySQL connection

[Jay Christopherson]

Ken, thanks for the suggestion/reminder - I cribbed a my.cnf file from
another database I setup.  I had forgotten that I set a short wait_timeout
(300), for just the reason you suggested.  I reset it to be a little more
sane about an hour ago and so far, things look ok.


On Fri, Nov 22, 2013 at 5:37 AM, ktm at rice.edu <ktm at rice.edu> wrote:

> On Thu, Nov 21, 2013 at 06:05:23PM -0800, Jay Christopherson wrote:
> > No, no entries beyond the startup messages.  I thought maybe there would
> be
> > some connection errors (a flush-hosts situation or something), but
> nothing.
> >
> >
> > On Thu, Nov 21, 2013 at 6:02 PM, Alex Vandiver <alexmv at bestpractical.com
> >wrote:
> >
> > > On Thu, 2013-11-21 at 15:20 -0800, Jay Christopherson wrote:
> > > > I just installed a new instance of RT (4.2.1).  I've been using RT
> for
> > > > quite a long time now, through a lot of different versions, but this
> > > > is a new issue for me.
> > >
> > > Is there anything of note in the mysql logs?
> > >  - Alex
> > >
>
> Hi Jay,
>
> It might be a long shot, but do you have a connection timeout set for your
> MySQL DB? Try disabling that. I was bit by that once and was astounded to
> find out that the DB just dropped a valid connection like that. It seems
> more useful in a broken web app type of way to keep from leaking
> connections
> but normal apps do not expect to lose a good connection. :)
>
> Regards,
> Ken
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131122/3a190b6a/attachment.htm>