[Kamailio-Users] db_mysql errors doing presence activity
Daniel-Constantin Mierla
miconda at gmail.com
Tue Jun 9 17:27:38 CEST 2009
I mistakenly returned error code even all was ok, in the previous
commit. Should be fixed on svn.
Thanks,
Daniel
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:
> 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 at gmail.com <mailto:miconda at 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 at gmail.com <mailto:pascal.maugeri at gmail.com>
> <mailto:pascal.maugeri at gmail.com
> <mailto:pascal.maugeri at 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>
> <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>
> <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>
> <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>
> <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>
> <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 at gmail.com <mailto:pascal.maugeri at gmail.com>
> <mailto:pascal.maugeri at gmail.com
> <mailto:pascal.maugeri at 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 at gmail.com
> <mailto:pascal.maugeri at gmail.com>
> <mailto:pascal.maugeri at gmail.com
> <mailto:pascal.maugeri at 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 at gmail.com <mailto:miconda at gmail.com>
> <mailto:miconda at gmail.com <mailto: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>
> <mailto:miconda at gmail.com
> <mailto:miconda at gmail.com>>
> <mailto:miconda at gmail.com
> <mailto:miconda at gmail.com>
>
> <mailto: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
> <mailto:Users at lists.kamailio.org>
> <mailto:Users at lists.kamailio.org
> <mailto: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/
>
>
>
>
>
>
> --
> 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/
More information about the sr-users
mailing list