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=dfc...
Any help appreciated.
Regards, Misi