[OpenSIPS-Users] OpenSIPs dies when connection to MySQL is lost.

[Bogdan-Andrei Iancu]

Hi Chris,

following other reports, I made a fix on the SVN (trunk) - I did not 
commited yet on branch as there is still under testing. I would really 
appreciate your help in confirming the correctness of this fix, by 
simply testing it - apply the attached patch to your 1.5 sources and 
give it a try.

Thanks and regards,
Bogdan

Chris Maciejewski wrote:
> Hi,
>
> I just noticed OpenSIPs dies with the following output in the log,
> when MySQL goes down:
>
> ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare:
> (1243) Unknown prepared statement handler (4) given to
> mysql_stmt_close
> ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement!
> ERROR:usrloc:db_timer_udomain: failed to delete from table location
> ERROR:usrloc:timer: synchronizing cache failed
> ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare:
> (2013) Lost connection to MySQL server during query
> ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement!
> ERROR:presence:update_db_subs: deleting expired information from database
> INFO:core:handle_sigs: child process 8655 exited by a signal 11
> INFO:core:handle_sigs: core was generated
> INFO:core:handle_sigs: terminating due to SIGCHLD
>
> Would it be possible to change this behaviour, so for example:
>
> 1. Both OpenSIPs and MySQL is running.
> 2. MySQL goes down.
> 3. OpenSIPs sends "500 Server error" but the process stays up and running.
> 4. MySQL is back online.
> 5. OpenSIPs resumes normal operation.
>
> Best regards,
> Chris
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql.patch
Type: text/x-diff
Size: 2567 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20090623/da400d12/attachment.patch