[Kamailio-Users] db_mysql errors doing presence activity
Pascal Maugeri
pascal.maugeri at gmail.com
Fri Jun 5 14:15:42 CEST 2009
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.sip-router.org/pipermail/sr-users/attachments/20090605/c9f6ec93/attachment.htm>
More information about the sr-users
mailing list