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@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@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


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