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; }