Re: [Kamailio-Users] db_mysql errors doing presence activity

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@gmail.com mailto:miconda@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users