OK good news, with the lastest of 1.5 branch I could not reproduced the bug I reported.<br><br>I've sent something like 3x1000 SIP PUBLISH requests and couldn't get the error (with 1.5.1. after 40-50 req, the bug was reproduced easily).<br>
<br>Thanks a lot to both for your help!<br>-pascal<br><br><div class="gmail_quote">On Tue, Jun 9, 2009 at 5:32 PM, Pascal Maugeri <span dir="ltr"><<a href="mailto:pascal.maugeri@gmail.com">pascal.maugeri@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">at least it starts :-)<br>let's see if I get these db errors ...<br><font color="#888888">-pascal</font><div>
<div></div><div class="h5"><br><br><div class="gmail_quote">On Tue, Jun 9, 2009 at 5:28 PM, Pascal Maugeri <span dir="ltr"><<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">ok I try it again<br><font color="#888888">-pascal</font><div><div></div><div><br>
<br><div class="gmail_quote">On Tue, Jun 9, 2009 at 5:27 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I mistakenly returned error code even all was ok, in the previous commit. Should be fixed on svn.<br>
<br>
Thanks,<br><font color="#888888">
Daniel</font><div><br>
<br>
On 06/09/2009 06:22 PM, Pascal Maugeri wrote:<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
I just tried your fix but now the server does not start any more and gives the following error:<br>
<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module xcap_client<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:init_mod: initializing module pua<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:pua:db_restore: the query returned no result<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15982]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 1<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15989]: ERROR:core:main_loop: init_child failed for UDP listener<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 2<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15990]: ERROR:core:main_loop: init_child failed for UDP listener<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 3<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:init_mod_child: failed to initializing module xcap_client, rank 4<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15993]: ERROR:core:main_loop: init_child failed for UDP listener<br>
Jun 9 19:19:20 sandbox /usr/sbin/kamailio[15992]: ERROR:core:main_loop: init_child failed for UDP listener<br>
<br>
-pascal<br>
<br>
<br></div><div><div></div><div>
On Tue, Jun 9, 2009 at 1:57 PM, Daniel-Constantin Mierla <<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>
I did a fix for what Inaki reported for xcap_client, you can get<br>
latest svn version for 1.5 and try again, maybe that was the issue.<br>
<br>
Thanks,<br>
Daniel<br>
<br>
<br>
On 06/08/2009 04:54 PM, Pascal Maugeri wrote:<br>
<br>
Daniel, do you want me to do other test ?<br>
-pascal<br>
<br>
On Fri, Jun 5, 2009 at 4:26 PM, Pascal Maugeri<br>
<<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>><br>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a><br>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>>>> wrote:<br>
<br>
OK now I can provide you more feedback regarding this issue and<br>
using your patch:<br>
<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select<br>
body,sender from presentity where domain='<a href="http://intra.genaker.net" target="_blank">intra.genaker.net</a><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>>' AND username='sipp1' AND<br>
<br>
event='presence' AND etag='a.1244218834.15152.106.1'<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select<br>
body,sender from presentity where domain='<a href="http://intra.genaker.net" target="_blank">intra.genaker.net</a><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>>' AND username='sipp1' AND<br>
<br>
event='presence' AND etag='a.1244218834.15151.101.0'<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15152]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query():<br>
delete from<br>
presentity where domain='<a href="http://intra.genaker.net" target="_blank">intra.genaker.net</a><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>>' AND username='sipp1' AND<br>
<br>
event='presence' AND etag='a.1244218834.15152.106.1'<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15150]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): update<br>
presentity set<br>
etag='a.1244218834.15150.110.1',expires=1244218977,received_time=1244218877,body='<?xml<br>
version=\"1.0\" encoding=\"UTF-8\"?> [HIDDEN]' where<br>
domain='<a href="http://intra.genaker.net" target="_blank">intra.genaker.net</a> <<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>>' AND<br>
<br>
username='sipp1' AND event='presence' AND<br>
etag='a.1244218834.15151.101.0'<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query(): select<br>
body,sender from presentity where domain='<a href="http://intra.genaker.net" target="_blank">intra.genaker.net</a><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>><br>
<<a href="http://intra.genaker.net" target="_blank">http://intra.genaker.net</a>>' AND username='sipp1' AND<br>
<br>
event='presence' AND etag='a.1244218834.15152.107.1'<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]:<br>
ERROR:db_mysql:db_mysql_submit_query: driver error on query:<br>
Commands out of sync; you can't run this command now<br>
Jun 5 18:21:17 sandbox /usr/sbin/kamailio[15153]:<br>
ERROR:core:db_do_query: error while submitting query<br>
<br>
So you can see the previous SQL commands sent.<br>
<br>
Do you need anything else ?<br>
<br>
-pascal<br>
<br>
<br>
<br>
<br>
On Fri, Jun 5, 2009 at 2:53 PM, Pascal Maugeri<br>
<<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>><br>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a><br></div></div><div>
<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<br>
forget my previous email.<br>
<br>
Now I'm going to generate some load to reproduce the<br>
failure<br>
and 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>
<<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a><br>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>><br></div><div>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a><br></div><div><div></div><div>
<mailto:<a href="mailto:pascal.maugeri@gmail.com" target="_blank">pascal.maugeri@gmail.com</a>>>><br>
<br>
wrote:<br>
<br>
Hi<br>
<br>
I just applied your patch and I get - with no<br>
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():<br>
delete 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():<br>
select id from watchers where<br>
inserted_time<1244124444 AND<br>
status=2<br>
Jun 5 16:07:24 sandbox /usr/sbin/kamailio[14713]:<br>
ERROR:db_mysql:db_mysql_submit_query: submit_query():<br>
select 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<br>
cleans or<br>
updates database. So I change these configuration<br>
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<br>
appear periodically (for clean/update actions).<br>
<br>
Regards,<br>
Pascal<br>
<br>
<br>
On Fri, Jun 5, 2009 at 10:04 AM, Daniel-Constantin<br>
Mierla<br>
<<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>><br></div></div><div><div></div><div>
<mailto:<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<br>
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<br>
restarted the<br>
test.<br>
I will send you send feedback ASAP<br>
<br>
ok, thanks. If it is too annoying, you can<br>
change<br>
the LM_DBG to LM_ERR or something else (like in<br>
attached 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,<br>
Daniel-Constantin Mierla<br>
<<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>><br>
<mailto:<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>
<mailto:<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>
<br>
<mailto:<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>>>>> wrote:<br>
<br>
Hello,<br>
<br>
<br>
On 06/04/2009 11:49 AM, Pascal<br>
Maugeri wrote:<br>
<br>
Hello<br>
<br>
I'm getting these errors using<br>
Kamailio<br>
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<br>
this 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:<br>
updating<br>
in 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<br>
this 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:<br>
querying 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<br>
this 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<br>
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<br>
from db is not freed<br>
before making a new query. To sort<br>
it out,<br>
please apply the patch<br>
attached and send me the last two<br>
queries<br>
you get for the same<br>
process - the one that gives the<br>
error and<br>
the 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>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>><br>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>>><br>
<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>
<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><div><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>
</div></blockquote><div><div></div><div>
<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>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>