[Kamailio-Users] db_mysql errors doing presence activity

[Pascal Maugeri]

Sorry I misunderstood what you want me to do: please just forget my previous
email.

Now I'm going to generate some load to reproduce the failure and I'll send
you the feedback you expect.

-pascal

On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri <pascal.maugeri at gmail.com>wrote:

> Hi
>
> I just applied your patch and I get - with no traffic yet - continusouly
> this log:
>
> Jun  5 16:07:24 sandbox /usr/sbin/kamailio[14713]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from
> active_watchers where expires<1244210834
> Jun  5 16:07:24 sandbox /usr/sbin/kamailio[14713]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): select id from
> watchers where inserted_time<1244124444 AND status=2
> Jun  5 16:07:24 sandbox /usr/sbin/kamailio[14713]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): select
> username,domain,etag,event from presentity where expires<1244210844 order by
> username
>
> and it never stops.
>
> I noticed that this occurs when presence server cleans or updates database.
> So I change these configuration parameters:
>
> modparam("presence", "db_update_period", 10)
> modparam("presence", "clean_period", 10)
>
> It changes the frequency of the log but the log always appear periodically
> (for clean/update actions).
>
> Regards,
> Pascal
>
>
> On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla <
> miconda at gmail.com> wrote:
>
>>
>>
>> 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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090605/fc2a58c8/attachment.htm>