Re: [Users] Mysql connection timeout issue

Hi guys, are you using the latest version from CVS (from 1.0.0 or head) - there was a recent fix about mysql re-connection. regards, bogdan Bastian Schern wrote: > Marcello Lupo schrieb: > >> Hi to all, >> i'm experiencing strange behavior and want to ask a clue. >> After some time of inactivity (around 15 hour more or less) or few >> activity on my Openser i start getting message in my logs: >> >> submit_query: MySQL server has gone away >> db_query: Error while submitting query >> is_local(): Error while querying database >> > > I really have the same error. But I feel that the error will occur > after a random time. But I'm not sure. > > >> and obviously openser is no more working. I have to restart openser >> to have reopened the connection. >> I'm using mysql 5.0.15-max and was thinking on the wait_timeout or >> interactive_timeout variables in mysql that by default are at 28800 >> (8 hour). >> I raised both variables to 1000000 but still getting the problem. >> Did you have any ideas? > > > I'm also using MySQL 5 (mysql 5.0.18-max). Could this be the reason? > > > Regards > Bastian