<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]: INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16398]: INFO:db_mysql:reset_all_statements: 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]: INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16400]: INFO:db_mysql:reset_all_statements: reseting all statements on connection: (0x7f17b530f1a0) 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16398]: INFO:db_mysql:connect_with_retry: re-connected successful for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16400]: INFO:db_mysql:connect_with_retry: re-connected successful for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16398]: INFO:db_mysql:db_mysql_do_prepared_query: reconnected to mysql server -> re-init the statement<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16400]: INFO:db_mysql:db_mysql_do_prepared_query: 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]: INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16395]: INFO:db_mysql:reset_all_statements: reseting all statements on connection: (0x7f17b530f1a0) 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16395]: INFO:db_mysql:connect_with_retry: re-connected successful for 0x7f17b530f338<br>Jan 25 21:00:05 66-226-76-150 ./opensips[16395]: INFO:db_mysql:db_mysql_do_prepared_query: 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">
<tr>
<td style="width:105px;padding-top:15px">
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img 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 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>
</table><a href="#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>