[OpenSIPS-Devel] [ opensips-Bugs-3612192 ] db_mysql: Commands out of sync

[SourceForge.net]

Bugs item #3612192, was opened at 2013-04-29 06:52
Message generated for change (Tracker Item Submitted) made by osas
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3612192&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.9.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ovidiu Sas (osas)
Assigned to: Nobody/Anonymous (nobody)
Summary: db_mysql: Commands out of sync

Initial Comment:
Opensips started to throw out this errors:
ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_store_result() failed: Commands out of sync; you can't run this command now (2014)
ERROR:usrloc:db_update_ucontact: updating database failed
ERROR:usrloc:update_ucontact: failed to update database

It is only one single process that is constantly throwing out this error.  All other process are able to use the db.

There was another process that had a similar issue, but it cleared out.  That process had a different error:
ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_store_result() failed: Commands out of sync; you can't run this command now (2014)
ERROR:auth_db:get_ha1: failed to query database

It seems that on a query, the system is able to recover, but on an insert, the system fails to recover,

This is on latest 1.9 svn: svnrevision: 2:9980M


Regards,
Ovidiu Sas

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

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