Re: [Kamailio-Users] db_mysql errors doing presence activity

Daniel, do you want me to do other test ? -pascal On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri &lt;pascal.maugeri(a)gmail.com&lt;mailtomailto: pascal.maugeri(a)gmail.com&gt;&gt; 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 &lt;pascal.maugeri(a)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 &lt;pascal.maugeri(a)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 &lt;miconda(a)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 &lt;miconda(a)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(a)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/