<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Aqs,<br>
<br>
It looks like you have some sql connectivity problems. Are you
sure your opensips can reach the mysql server ? all your errors
(about long query time and about the failure to reconnect) do
point to a connectivity problem to mysql server.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 26.01.2016 00:27, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVUr-_yEEOL4MLLThQ+DTNJKQsA00d=0v8uPZ=Em70fefw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi. <br>
<br>
</div>
<div>I am load testing my opensips(2.1.2) with sipp on. As soon
as I send calls with 50 cps i see this in logs. <br>
<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>: disconnect event
for 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>: reseting all statements on
connection: (0x7f17b530f1a0) 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep
stmt took too long - 1999302 us.Source : delete from dialo<br>
g where dlg_id=?<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>: disconnect event
for 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>: reseting all statements on
connection: (0x7f17b530f1a0) 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>: re-connected successful for
0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>: re-connected successful for
0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:db_mysql_do_prepared_query">INFO:db_mysql:db_mysql_do_prepared_query</a>: reconnected to mysql
server -> re-init the statement<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:db_mysql_do_prepared_query">INFO:db_mysql:db_mysql_do_prepared_query</a>: reconnected to mysql
server -> re-init the statement<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
CRITICAL:db_mysql:db_mysql_do_prepared_query: too many mysql
server reconnection failures<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
ERROR:dialog:update_dialog_dbinfo: could not update database
info<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
CRITICAL:db_mysql:db_mysql_do_prepared_query: too many mysql
server reconnection failures<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
ERROR:dialog:update_dialog_dbinfo: could not add another
dialog to db<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
WARNING:core:handle_timer_job: timer job <dlg-timer> has
a 2310000 us delay in execution<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16398]:
WARNING:core:handle_timer_job: timer job <blcore-expire>
has a 2310000 us delay in execution<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16396]:
WARNING:core:handle_timer_job: utimer job <tm-utimer>
has a 80000 us delay in execution<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16400]:
WARNING:core:handle_timer_job: utimer job <tm-utimer>
has a 80000 us delay in execution<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16390]:
WARNING:core:utimer_ticker: utimer task <tm-utimer>
already schedualed for 1436630 ms (now 1436730 ms), it may
overlap.<br>
.<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16390]:
WARNING:core:utimer_ticker: utimer task <tm-utimer>
already schedualed for 1436730 ms (now 1436830 ms), it may
overlap.<br>
.<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
WARNING:db_mysql:log_expiry: threshold exceeded : mysql prep
stmt took too long - 1999067 us.Source : delete from dialo<br>
g where dlg_id=?<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>: disconnect event
for 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>: reseting all statements on
connection: (0x7f17b530f1a0) 0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>: re-connected successful for
0x7f17b530f338<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
<a class="moz-txt-link-freetext" href="INFO:db_mysql:db_mysql_do_prepared_query">INFO:db_mysql:db_mysql_do_prepared_query</a>: reconnected to mysql
server -> re-init the statement<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
CRITICAL:db_mysql:db_mysql_do_prepared_query: too many mysql
server reconnection failures<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
ERROR:dialog:update_dialog_dbinfo: could not add another
dialog to db<br>
Jan 25 21:00:05 66-226-76-150 ./opensips[16395]:
WARNING:core:handle_timer_job: utimer job <tm-utimer>
has a 50000 us delay in execution<br>
<br>
</div>
<div>mysql server is on localhost and server is of good specs.<br>
<br>
</div>
<div>Could someone help me how i resolve or why there are so
many these lines.<br>
<br>
</div>
<div>Thanks. <br>
</div>
</div>
<div id="DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<table style="border-top:1px solid #aaabb6;margin-top:30px">
<tbody>
<tr>
<td style="width:105px;padding-top:15px"> <a
moz-do-not-send="true"
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"
target="_blank"><img moz-do-not-send="true"
src="https://ipmcdn.avast.com/images/logo-avast-v1.png"
style="width: 90px; height:33px;"></a> </td>
<td
style="width:470px;padding-top:20px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">This
email has been sent from a virus-free computer protected
by Avast. <br>
<a moz-do-not-send="true"
href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"
target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>