[Kamailio-Users] db_mysql errors doing presence activity

[Daniel-Constantin Mierla]

On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:
>
>
> On 06/04/2009 03:14 PM, Pascal Maugeri wrote:
>> ok, I've applied your patch changed my kamailio.cfg to have debug=5 
>> and restarted the test.
>> I will send you send feedback ASAP
> ok, thanks. If it is too annoying, you can change the LM_DBG to LM_ERR 
> or something else (like in attached patch).
... patch attached now.
>
> Cheers,
> Daniel
>
>>  
>> -pascal
>>
>> On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla 
>> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>>
>>     Hello,
>>
>>
>>     On 06/04/2009 11:49 AM, Pascal Maugeri wrote:
>>
>>         Hello
>>
>>         I'm getting these errors using Kamailio 1.5.1:
>>
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:db_mysql:db_mysql_submit_query: driver error on query:
>>         Commands out of sync; you can't run this command now
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:core:db_do_update: error while submitting query
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:presence:update_db_subs: updating in database
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:db_mysql:db_mysql_submit_query: driver error on query:
>>         Commands out of sync; you can't run this command now
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:core:db_do_query: error while submitting query
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:presence:msg_watchers_clean: querying database for
>>         expired messages
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:db_mysql:db_mysql_submit_query: driver error on query:
>>         Commands out of sync; you can't run this command now
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:core:db_do_query: error while submitting query
>>         Jun  4 12:25:10 sandbox /usr/sbin/kamailio[5060]:
>>         ERROR:presence:msg_presentity_clean: querying database for
>>         expired messages
>>
>>         I haven't seen anything similar in the issue tracker ? Is it a
>>         new bug ? How can I track it down ?
>>
>>     there seems to be a case when the result from db is not freed
>>     before making a new query. To sort it out, please apply the patch
>>     attached and send me the last two queries you get for the same
>>     process - the one that gives the error and the one before.
>>
>>
>> Should
>>  
>>
>>     Thanks,
>>     Daniel
>>
>>
>>     --     Daniel-Constantin Mierla
>>     http://www.asipto.com/
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Kamailio (OpenSER) - Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>

-- 
Daniel-Constantin Mierla
http://www.asipto.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: query-dbg.patch
Type: text/x-patch
Size: 495 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090605/c08b1cb2/attachment.bin>