Re: [rt-users] RT loses MySQL connection
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
Re: [rt-users] RT loses MySQL connection
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 issue. Clearly though, I have something going on that is not-normal because if this were a real bug, lots of people would be reporting it and it's never been an issue for me before. I'm going to start over with a clean build and try again. - Jay On Mon, Nov 25, 2013 at 5:53 AM, k...@rice.edu k...@rice.edu wrote: 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
Re: [rt-users] RT loses MySQL connection
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? On Fri, Nov 22, 2013 at 8:32 AM, Jay Christopherson jc.listm...@gmail.comwrote: 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, k...@rice.edu k...@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 ale...@bestpractical.comwrote: 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
Re: [rt-users] RT loses MySQL connection
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 ale...@bestpractical.comwrote: 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
Re: [rt-users] RT loses MySQL connection
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, k...@rice.edu k...@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 ale...@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
Re: [rt-users] RT loses MySQL connection
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
Re: [rt-users] RT loses MySQL connection
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 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
Re: [rt-users] RT loses MySQL connection
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 RT_SiteConfig.pm ? Is this under SELinux, or anything else that might muck about with sockets? - Alex