[OpenSER-Devel] db problems after restart

[Juha Heinanen]

after the crash described in previous message, i restarted openser.
after that it happily processed a few registers and invites, but then on
its own (i.e. syslog does not show any incoming requests) it printed to
syslog:

Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:core:db_do_delete: error while submitting query 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:pua:db_update: while deleting from db table pua 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:core:db_do_raw_query: error while submitting query 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:usrloc:get_all_db_ucontacts: raw_query failed 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:mediaproxy:pingClients: failed to fetch contacts 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:core:db_do_delete: error while submitting query 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:usrloc:db_timer_udomain: failed to delete from table location 
Mar 25 21:04:46 test /usr/sbin/openser[17266]: ERROR:usrloc:timer: synchronizing cache failed 

it looks to me like mysql driver gets somehow confused.  this is
something new that didn't happen a couple of months ago.  if i remember
correctly, i have seen the same also when i run usrloc in db_mode 1.

what does "Commands out of sync" mean?  i start to get frustrated and
help from db gurus would be highly appreciated.  any ideas how i could
debug this further?

-- juha