<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">Do you need anything else ?<br>
</div></blockquote>
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.<br>
</blockquote><div><br><br>:-( no sorry I haven't keep the entire log. I'm sorry this is my fault as I remember you asked me to send this info as well.<br>I'm restarting the test ...<br>-pascal<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Thanks,<br>
Daniel<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
-pascal<div class="im"><br>
<br>
<br>
<br>
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri <<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a> <mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>>> wrote:<br>
<br>
Sorry I misunderstood what you want me to do: please just forget<br>
my previous email.<br>
<br>
Now I'm going to generate some load to reproduce the failure and<br>
I'll send you the feedback you expect.<br>
<br>
-pascal<br>
<br>
<br>
On Fri, Jun 5, 2009 at 2:15 PM, Pascal Maugeri<br></div><div class="im">
<<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a> <mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>>> wrote:<br>
<br>
Hi<br>
<br>
I just applied your patch and I get - with no traffic yet -<br>
continusouly this log:<br>
<br>
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): delete<br>
from active_watchers where expires<1244210834<br>
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select<br>
id from watchers where inserted_time<1244124444 AND status=2<br>
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select<br>
username,domain,etag,event from presentity where<br>
expires<1244210844 order by username<br>
<br>
and it never stops.<br>
<br>
I noticed that this occurs when presence server cleans or<br>
updates database. So I change these configuration parameters:<br>
<br>
modparam("presence", "db_update_period", 10)<br>
modparam("presence", "clean_period", 10)<br>
<br>
It changes the frequency of the log but the log always appear<br>
periodically (for clean/update actions).<br>
<br>
Regards,<br>
Pascal<br>
<br>
<br>
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin Mierla<br></div><div class="im">
<<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a> <mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>> wrote:<br>
<br>
<br>
<br>
On 06/05/2009 10:55 AM, Daniel-Constantin Mierla wrote:<br>
<br>
<br>
<br>
On 06/04/2009 03:14 PM, Pascal Maugeri wrote:<br>
<br>
ok, I've applied your patch changed my<br>
kamailio.cfg to have debug=5 and restarted the test.<br>
I will send you send feedback ASAP<br>
<br>
ok, thanks. If it is too annoying, you can change the<br>
LM_DBG to LM_ERR or something else (like in attached<br>
patch).<br>
<br>
... patch attached now.<br>
<br>
<br>
Cheers,<br>
Daniel<br>
<br>
-pascal<br>
<br>
On Thu, Jun 4, 2009 at 12:09 PM, Daniel-Constantin<br>
Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a><br>
<mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>><br></div>
<mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a><div><div></div><div class="h5"><br>
<mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>>> wrote:<br>
<br>
Hello,<br>
<br>
<br>
On 06/04/2009 11:49 AM, Pascal Maugeri wrote:<br>
<br>
Hello<br>
<br>
I'm getting these errors using Kamailio 1.5.1:<br>
<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:db_mysql:db_mysql_submit_query:<br>
driver error on query:<br>
Commands out of sync; you can't run this<br>
command now<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:core:db_do_update: error while<br>
submitting query<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:presence:update_db_subs: updating in<br>
database<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:db_mysql:db_mysql_submit_query:<br>
driver error on query:<br>
Commands out of sync; you can't run this<br>
command now<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:core:db_do_query: error while<br>
submitting query<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:presence:msg_watchers_clean: querying<br>
database for<br>
expired messages<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:db_mysql:db_mysql_submit_query:<br>
driver error on query:<br>
Commands out of sync; you can't run this<br>
command now<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:core:db_do_query: error while<br>
submitting query<br>
Jun 4 12:25:10 sandbox<br>
/usr/sbin/kamailio[5060]:<br>
ERROR:presence:msg_presentity_clean:<br>
querying database for<br>
expired messages<br>
<br>
I haven't seen anything similar in the<br>
issue tracker ? Is it a<br>
new bug ? How can I track it down ?<br>
<br>
there seems to be a case when the result from<br>
db is not freed<br>
before making a new query. To sort it out,<br>
please apply the patch<br>
attached and send me the last two queries you<br>
get for the same<br>
process - the one that gives the error and the<br>
one before.<br>
<br>
<br>
Should<br>
Thanks,<br>
Daniel<br>
<br>
<br>
-- Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a><br>
<br>
<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Kamailio (OpenSER) - Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br></div></div>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>><div class="im"><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<a href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
<br>
-- Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a><br>
<br>
<br>
<br>
<br>
</div></blockquote><div><div></div><div class="h5">
<br>
-- <br>
Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a><br>
<br>
</div></div></blockquote></div><br>