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>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> 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>> 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 >>>> 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