[SR-Users] db_mysql "Commands out of sync; you can't run this command now "

MÉSZÁROS Mihály misi at niif.hu
Sat Aug 27 22:14:35 CEST 2011


Hi,

I am using the git version of kamailio, and i am experiencing problem
This message is repeated in log with all kind of mysql query 
(insert/delete/select)

Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: db_mysql 
[km_dbase.c:124]: driver error on query: Commands out of sync; you can't 
run this command now
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: <core> 
[db_query.c:103]: error while submitting query
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: usrloc 
[udomain.c:570]: db_query failed
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: db_mysql 
[km_dbase.c:124]: driver error on query: Commands out of sync; you can't 
run this command now
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: <core> 
[db_query.c:186]: error while submitting query
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: usrloc 
[ucontact.c:513]: inserting contact in db failed
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: usrloc 
[urecord.c:474]: failed to insert in database
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: registrar 
[save.c:430]: failed to insert contact
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: db_mysql 
[km_dbase.c:124]: driver error on query: Commands out of sync; you can't 
run this command now
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: <core> 
[db_query.c:242]: error while submitting query
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: usrloc 
[urecord.c:426]: failed to delete from database
Aug 27 22:04:05 hal /usr/sbin/kamailio[25681]: ERROR: usrloc 
[udomain.c:896]: DB delete failed

I am using stable debian so db_mysql.so linked with libmysqlclient.so.16

I read mysql doc and it is saying about this error the following:
"Commands out of sync; you can't run this command now"

http://dev.mysql.com/doc/refman/5.0/en/commands-out-of-sync.html

So this problem cause it that not freed the last result.

Only one assumption:
Could it related to this change:
http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=dfc2834223b7c6b2e799da5a0876b8096cfdae5e

Any help appreciated.

Regards,
Misi



More information about the sr-users mailing list