at least it starts :-) let's see if I get these db errors ... -pascal On Tue, Jun 9, 2009 at 5:28 PM, Pascal Maugeri <[email protected]>wrote:
> ok I try it again > -pascal > > > On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla < > [email protected]> wrote: > >> 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 < >>> [email protected] <mailto:[email protected]>> 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 >>> <[email protected] <mailto:[email protected]> >>> <mailto:[email protected] >>> <mailto:[email protected]>>> 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 >>> <[email protected] <mailto:[email protected]> >>> <mailto:[email protected] >>> <mailto:[email protected]>>> 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 >>> <[email protected] >>> <mailto:[email protected]> >>> <mailto:[email protected] >>> <mailto:[email protected]>>> >>> >>> 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 >>> <[email protected] <mailto:[email protected]> >>> <mailto:[email protected] <mailto:[email protected]>>> 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 >>> <[email protected] <mailto:[email protected]> >>> <mailto:[email protected] >>> <mailto:[email protected]>> >>> <mailto:[email protected] >>> <mailto:[email protected]> >>> >>> <mailto:[email protected] >>> <mailto:[email protected]>>>> 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 >>> [email protected] >>> <mailto:[email protected]> >>> <mailto:[email protected] >>> <mailto:[email protected]>> >>> >>> >>> 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 >>> [email protected] >>> 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 [email protected] http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
