Do you need anything else ?
I hope you still have entire log as I need to see previous sql command sent by process with pid 15153 (the one that threw the error). Please grep it and send it to me.


:-( no sorry I haven't keep the entire log. I'm sorry this is my fault as I remember you asked me to send this info as well.
I'm restarting the test ...
-pascal
 

Thanks,
Daniel


-pascal




On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@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.maugeri@gmail.com <mailto:pascal.maugeri@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
       <miconda@gmail.com <mailto: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>
                   <mailto: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
                   <mailto: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/





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