I just tried your fix but now the server does not start any more and gives the following error:

Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener
Jun  9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener

-pascal


On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:
I did a fix for what Inaki reported for xcap_client, you can get latest svn version for 1.5 and try again, maybe that was the issue.

Thanks,
Daniel


On 06/08/2009 04:54 PM, Pascal Maugeri wrote:
Daniel, do you want me to do other test ?
-pascal

On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri <pascal.maugeri@gmail.com <mailto:pascal.maugeri@gmail.com>> wrote:

   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
   <http://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
   <http://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
   <http://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 <http://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
   <http://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.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/