[Kamailio-Users] db_mysql errors doing presence activity

[Pascal Maugeri]

Daniel, do you want me to do other test ?
-pascal

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

> OK now I can provide you more feedback regarding this issue and using your
> patch:
>
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15152]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
> from presentity where domain='intra.genaker.net' AND username='sipp1' AND
> event='presence' AND etag='a.1244218834.15152.106.1'
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15150]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
> from presentity where domain='intra.genaker.net' AND username='sipp1' AND
> event='presence' AND etag='a.1244218834.15151.101.0'
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15152]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity
> where domain='intra.genaker.net' AND username='sipp1' AND event='presence'
> AND etag='a.1244218834.15152.106.1'
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15150]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set
> etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml
> version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='
> intra.genaker.net' AND username='sipp1' AND event='presence' AND
> etag='a.1244218834.15151.101.0'
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15153]:
> ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
> from presentity where domain='intra.genaker.net' AND username='sipp1' AND
> event='presence' AND etag='a.1244218834.15152.107.1'
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15153]:
> ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of
> sync; you can't run this command now
> Jun  5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query:
> error while submitting query
>
> So you can see the previous SQL commands sent.
>
> Do you need anything else ?
>
> -pascal
>
>
>
>
> On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri at gmail.com>wrote:
>
>> 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.kamailio.org/pipermail/users/attachments/20090608/1698e52a/attachment-0001.htm>