OK now I can provide you more feedback regarding this issue and using your
patch:
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]:
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
from presentity where domain='intra.genaker.net' AND username='sipp1' AND
event='presence' AND etag='a.1244218834.15152.106.1'
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]:
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
from presentity where domain='intra.genaker.net' AND username='sipp1' AND
event='presence' AND etag='a.1244218834.15151.101.0'
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]:
ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete from presentity
where domain='intra.genaker.net' AND username='sipp1' AND event='presence'
AND etag='a.1244218834.15152.106.1'
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]:
ERROR:db_mysql:db_mysql_submit_query: submit_query(): update presentity set
etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml
version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where domain='
intra.genaker.net' AND username='sipp1' AND event='presence' AND
etag='a.1244218834.15151.101.0'
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]:
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select body,sender
from presentity where domain='intra.genaker.net' AND username='sipp1' AND
event='presence' AND etag='a.1244218834.15152.107.1'
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of
sync; you can't run this command now
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]: ERROR:core:db_do_query:
error while submitting query
So you can see the previous SQL commands sent.
Do you need anything else ?
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maug...@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.maug...@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 <
>> mico...@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 <
>>>>> mico...@gmail.com <mailto:mico...@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
>>>>>
>>>>
>>>>
>>> --
>>> 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
