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

[Thomas Gelf]

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