[Kamailio-Users] db_mysql errors doing presence activity

[Pascal Maugeri]

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

-pascal

On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin Mierla <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/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090604/65b3e705/attachment.htm>