[SR-Users] db_mysql "Commands out of sync; you can't run this command now "
Daniel-Constantin Mierla
miconda at gmail.com
Sun Aug 28 09:25:05 CEST 2011
Hello,
thanks for investigation - this is only on current devel version. For
quick try, can you revert the patch and try? Practically, you have to
replace:
while( mysql_more_results(CON_CONNECTION(_h)) &&
mysql_next_result(CON_CONNECTION(_h)) > 0 ) {
with:
while( mysql_next_result( CON_CONNECTION(_h) ) > 0 ) {
two times in modules/db_mysql/km_dbase.c.
At this moment I do not have a good internet connection to be able to
investigate more and search into documentation of mysql for
mysql_more_results(). It looks like the result was not freed indeed.
Another case for such error is when a mysql connection is shared between
many processes and the access to it is not synchronized -- there were no
changes afaik that could introduce such situation.
Thanks,
Daniel
On 8/27/11 10:14 PM, MÉSZÁROS Mihály wrote:
> 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
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda
More information about the sr-users
mailing list