Hi Bogdan I am testing the 1.6.4 update, but in the meantime I have set up a virtual db connection which has two connections in failover to the same database. This is currently preventing the crashes on my live system
Regards Chris Sent via my BlackBerry from Vodacom - let your email find you! -----Original Message----- From: Bogdan-Andrei Iancu <[email protected]> Sender: [email protected] Date: Wed, 22 Dec 2010 16:00:08 To: OpenSIPS users mailling list<[email protected]> Reply-To: OpenSIPS users mailling list <[email protected]> Subject: Re: [OpenSIPS-Users] opensips segfault on mysql errors 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 _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
