On Sat, Nov 23, 2013 at 08:35:06AM -0800, Jay Christopherson wrote:
Interestingly, adjusting the wait_timeout to the default (8 hours) worked
great - for 8 hours. After that 8 hours, RT once again lost all
connectivity to the database. Running a show processlist on MySQL showed
that RT had
Hey Ken-
Yep, I get that. I don't believe you can disable the wait_timeout entirely
- by default, it's set to 8 hours, which is what I currently have. RT
works great - for 8 hours. Just to be sane, I replaced my.cnf with the
default my.cnf that gets built with a vanilla install of MySQL. Same
Interestingly, adjusting the wait_timeout to the default (8 hours) worked
great - for 8 hours. After that 8 hours, RT once again lost all
connectivity to the database. Running a show processlist on MySQL showed
that RT had no connections to the DB, even though RT was still running. A
restart
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
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
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
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 ale...@bestpractical.comwrote:
On Thu, 2013-11-21 at 15:20 -0800, Jay Christopherson wrote:
I
On Thu, 2013-11-21 at 18:05 -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.
That's odd. Can you show your my.cnf, webserver configuration, and