[OpenSIPS-Devel] [ opensips-Bugs-2817434 ] "mysql_stmt_execute() failed" after restart MySQL

[SourceForge.net]

Bugs item #2817434, was opened at 2009-07-06 15:06
Message generated for change (Tracker Item Submitted) made by ibc_sf
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2817434&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.5.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Iñaki Baz Castillo (ibc_sf)
Assigned to: Nobody/Anonymous (nobody)
Summary: "mysql_stmt_execute() failed" after restart MySQL

Initial Comment:
Using OpenSIPS trunk rev 5738 as presence server.

After restarting MySQL server I get the following errors in the log:

--------------------
Jul  6 12:43:08 myserver /usr/sbin/opensips[30437]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jul  6 12:43:08 myserver /usr/sbin/opensips[30436]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jul  6 12:43:08 myserver /usr/sbin/opensips[30434]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jul  6 12:43:08 myserver /usr/sbin/opensips[30438]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jul  6 12:43:17 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (1210) Incorrect arguments to mysql_stmt_execute
Jul  6 12:43:40 myserver /usr/sbin/opensips[30436]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (1210) Incorrect arguments to mysql_stmt_execute
Jul  6 12:43:40 myserver /usr/sbin/opensips[30437]: ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Jul  6 12:43:40 myserver /usr/sbin/opensips[30437]: ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement!
Jul  6 12:43:40 myserver /usr/sbin/opensips[30437]: ERROR:presence:insert_subs_db: unsuccessful sql insert
Jul  6 12:43:40 myserver /usr/sbin/opensips[30433]: ERROR:db_mysql:re_init_statement: failed while mysql_stmt_prepare: (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Jul  6 12:43:40 myserver /usr/sbin/opensips[30433]: ERROR:db_mysql:db_mysql_do_prepared_query: failed to re-init statement!
Jul  6 12:44:15 myserver /usr/sbin/opensips[30438]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
Jul  6 12:44:15 myserver /usr/sbin/opensips[30438]: ERROR:presence:insert_subs_db: unsuccessful sql insert
Jul  6 12:44:58 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
Jul  6 12:46:38 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
Jul  6 12:48:18 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
Jul  6 12:49:58 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
Jul  6 12:51:38 myserver /usr/sbin/opensips[30440]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed(2): (126) Incorrect key file for table './opensips/active_watchers.MYI'; try to repair it
[...]
-----------------------------

Note that I restarted MySQL at 12:43.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2817434&group_id=232389