ok I try it again -pascal On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla <mico...@gmail.com>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 < >> mico...@gmail.com <mailto:mico...@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.maug...@gmail.com <mailto:pascal.maug...@gmail.com> >> <mailto:pascal.maug...@gmail.com >> <mailto:pascal.maug...@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.maug...@gmail.com <mailto:pascal.maug...@gmail.com> >> <mailto:pascal.maug...@gmail.com >> <mailto:pascal.maug...@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.maug...@gmail.com >> <mailto:pascal.maug...@gmail.com> >> <mailto:pascal.maug...@gmail.com >> <mailto:pascal.maug...@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 >> <mico...@gmail.com <mailto:mico...@gmail.com> >> <mailto:mico...@gmail.com <mailto:mico...@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 >> <mico...@gmail.com <mailto:mico...@gmail.com> >> <mailto:mico...@gmail.com >> <mailto:mico...@gmail.com>> >> <mailto:mico...@gmail.com >> <mailto:mico...@gmail.com> >> >> <mailto:mico...@gmail.com >> <mailto:mico...@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> >> <mailto: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/ >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> 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/ > >
_______________________________________________ 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
