Hi Chris,
prior to 1.6.4 there were some issues with the reconnect events in the
prepare statements implementation...They were fixed with the new 1.6.4
release .
I strongly suggest to update (migration docs are available under
http://www.opensips.org/Resources/DocsMigration).
Regards,
Bogdan
Chris Picton wrote:
Hi all
I am running opensips 1.6.2 against a mysql cluster
On occasion, my sql nodes return temporary errors to opensips, which are
of the form 'please restart transaction'
An example of this would be:
ERROR:db_mysql:db_mysql_submit_query: driver error: Lock wait timeout
exceeded; try restarting transaction
This is generally followed by:
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22213]:
INFO:core:handle_sigs: child process 22272 exited by a signal 11
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22213]:
INFO:core:handle_sigs: core was generated
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22213]:
INFO:core:handle_sigs: terminating due to SIGCHLD
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22318]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22310]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22271]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22251]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22237]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22224]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22270]:
INFO:core:sig_usr: signal 15 received
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22248]:
INFO:core:sig_usr: signal 15 received
...
Dec 22 14:43:18 sbc-tpna1-01 /usr/sbin/opensips[22213]:
NOTICE:db_virtual:destroy: destroy module bla bla...
What should I be looking at to prevent this failure of sips when it sees
a database error?
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
Bogdan-Andrei Iancu
OpenSIPS Event - expo, conf, social, bootcamp
2 - 4 February 2011, ITExpo, Miami, USA
www.voice-system.ro
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
