Klaus Darilion wrote:
Federico Giannici wrote:
Your suspect was correct: I was able to reproduce
exactly the same
errors simply by stopping a restarting the MySQL server (thus
breaking old connections).
Shouldn't the mysql module reconnect?
yes, it should.. the option is turned on by default...
http://openser.org/docs/modules/1.1.x/mysql.html#AEN68
Federico please apply the attached patch and send me the output.
regards,
bogdan
? modules/mysql/.dbase.c.swp
Index: modules/mysql/dbase.c
===================================================================
RCS file: /cvsroot/openser/sip-server/modules/mysql/dbase.c,v
retrieving revision 1.5
diff -u -r1.5 dbase.c
--- modules/mysql/dbase.c 14 Jul 2006 14:12:59 -0000 1.5
+++ modules/mysql/dbase.c 22 Aug 2006 13:44:38 -0000
@@ -87,6 +87,7 @@
return 0;
}
code = mysql_errno(CON_CONNECTION(_h));
+ LOG(L_ERR, "submit_query: errno code is %d\n", code);
if (code != CR_SERVER_GONE_ERROR && code != CR_SERVER_LOST) {
break;
}