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
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? Thanks, Bye, Marcello
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
____________ Virus checked by G DATA AntiVirusKit Version: AVK 16.5138 from 28.01.2006 Virus news: www.antiviruslab.com
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
Virus checked by G DATA AntiVirusKit Version: AVK 16.5138 from 28.01.2006 Virus news: www.antiviruslab.com
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
I'm using OpenSER from this tar.gz: http://openser.org/pub/openser/1.0.0/src/openser-1.0.0-tls_src.tar.gz
Is there a difference between this package and CVS rel_1_0_0 sip-server?
Regards Bastian
Bogdan-Andrei Iancu schrieb:
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
____________ Virus checked by G DATA AntiVirusKit Version: AVK 16.5138 from 28.01.2006 Virus news: www.antiviruslab.com
Hi,
yes, on CVS there are couple of bug fixes applied. Please try using either the CVS or the latest 1.0.0 snapshot.
regards, bogdan
Bastian Schern wrote:
I'm using OpenSER from this tar.gz: http://openser.org/pub/openser/1.0.0/src/openser-1.0.0-tls_src.tar.gz
Is there a difference between this package and CVS rel_1_0_0 sip-server?
Regards Bastian
Bogdan-Andrei Iancu schrieb:
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
Virus checked by G DATA AntiVirusKit Version: AVK 16.5138 from 28.01.2006 Virus news: www.antiviruslab.com
-
Bastian Schern -
Bogdan-Andrei Iancu -
Marcello Lupo