[Kamailio-Users] db_mysql errors doing presence activity

[Daniel-Constantin Mierla]

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).

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/