[rt-users] RT loses MySQL connection

[ktm at rice.edu]

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 no connections to the DB, even though RT was still running.  A
> restart fixed it - for now.
> 
> I am not sure how RT does connection handling, but it seems like it should
> attempt to reconnect?
> 

Hi Jay,

Again, a properly managed system does not require and certainly does not expect
to have a connection ripped out from under it. Turn off your timeout and you
will be fine. RT will connect just fine, as you have seen. It should not need
to "reconnect" to a properly configured DB once it has a valid connection.

Regards,
Ken