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

[MÉSZÁROS Mihály]

Hello,

After reverting back to original this commit, the problem is still 
occurring. :(
So not this commit is causing the problem. :(

Misi



2011-08-28 09:25 keltezéssel, Daniel-Constantin Mierla írta:
> 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
>