[OpenSER-Devel] db_mysql commands out of sync

Juha Heinanen jh at tutpro.com
Fri Mar 28 14:14:29 CET 2008


i'm getting these also in usrloc db_mode = 1:

Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: LOG: Handling PUBLISH to <sip:jh at tutpro.com> 
Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now 
Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: ERROR:core:db_do_query: error while submitting query 
Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: ERROR:presence:update_presentity: unsuccessful sql query 
Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: ERROR:presence:handle_publish: when updating presentity 
Mar 28 14:50:24 tutpro /usr/sbin/openser[11688]: ERROR: PUBLISH to <sip:jh at tutpro.com> failed 

i would really appreciate if db experts could help in solving this
problem.  what does Commands out of sync sync mean?  when does it
happen? 

although in the above the errors resulted from publish, i have
seen the same happening also without any request processing as i have
reported earlier.  i have not changed anything in the way my openser is
running.  these errors just started to appear at some point this year
when i upgraded to a newer trunk.

if the cause for the errors cannot be found, perhaps it would would then
be better to go back to the working db implementation that existed at
the end of last year.

-- juha



More information about the Devel mailing list