[OpenSIPS-Users] opensips segfault on mysql errors

[Chris Picton]

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 <bogdan at voice-system.ro>
Sender: users-bounces at lists.opensips.org
Date: Wed, 22 Dec 2010 16:00:08 
To: OpenSIPS users mailling list<users at lists.opensips.org>
Reply-To: OpenSIPS users mailling list <users at lists.opensips.org>
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
> Users at lists.opensips.org
> 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
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users