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

Chris Maciejewski chris at wima.co.uk
Sun Jun 21 18:19:26 CEST 2009


Sorry, should have mentioned this in my first post. I am running
opensips-1.5.1-notls

Best regards,
Chris


2009/6/21 Thomas Gelf <thomas at gelf.net>
>
> What OpenSIPS version are you running? Some related issues habe been
> fixed with 1.5.1...
>
> Best regards,
> Thomas Gelf
>
>
> Chris Maciejewski schrieb:
> > 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



More information about the Users mailing list