[Kamailio-Users] db_mysql errors doing presence activity

[Daniel-Constantin Mierla]

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.

Thanks,
Daniel


-- 
Daniel-Constantin Mierla
http://www.asipto.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: query-dbg.patch
Type: text/x-patch
Size: 495 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090604/dc5b1a4b/attachment.bin>