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

[Chris Maciejewski]

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