[Kamailio-Users] db_mysql errors doing presence activity

Pascal Maugeri pascal.maugeri at gmail.com
Tue Jun 9 16:27:59 CEST 2009


> Do you need anything else ?
>>
> I hope you still have entire log as I need to see previous sql command sent
> by process with pid 15153 (the one that threw the error). Please grep it and
> send it to me.
>


:-( no sorry I haven't keep the entire log. I'm sorry this is my fault as I
remember you asked me to send this info as well.
I'm restarting the test ...
-pascal


>
> Thanks,
> Daniel
>
>
>> -pascal
>>
>>
>>
>> On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri at gmail.com<mailto:
>> 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 <mailto: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 <mailto: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>
>>                    <mailto: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
>>                    <mailto: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/
>>
>>
>>
>>
>>
> --
> Daniel-Constantin Mierla
> http://www.asipto.com/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20090609/1a0f0db7/attachment.htm>


More information about the Users mailing list