I hope you still have entire log as I need to see previous sql command sent by process with pid 15153 (the one that threw the error). Please grep it and send it to me.Do you need anything else ?
Thanks,
Daniel
-pascal
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <pascal.maugeri@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<pascal.maugeri@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<miconda@gmail.com <mailto:miconda@gmail.com>> wrote:<mailto:miconda@gmail.com
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@gmail.com
<mailto:miconda@gmail.com><mailto:Users@lists.kamailio.org>
<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@lists.kamailio.org