<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Michele,<br>
<br>
I don;t think that the failed reconnect events are related to the
OOM issue - to get some disconnection is normal if you have DB
cons which are idle for longer period of time (hours). OpenSIPS
will automatically attempt to re-connect / connect . Do you get
these reconnect errors on daily bases ?<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>
OpenSIPS Summit May 2017 Amsterdam
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html">http://www.opensips.org/events/Summit-2017Amsterdam.html</a>
</pre>
<div class="moz-cite-prefix">On 03/16/2017 04:00 PM, Michele Pinassi
wrote:<br>
</div>
<blockquote cite="mid:32264ab7-b0f1-5622-af76-0681fb6ea184@unisi.it"
type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<p>More on this issue:<br>
</p>
<p>/usr/sbin/opensips[1050]:
313438393637323537333232383031-kto38ogzez62 - Failure route 0
<null> <null><br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c8ec) 0xb7292054<br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1049]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1049.47170.35]<br>
/usr/sbin/opensips[1047]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1047.47360.76]<br>
/usr/sbin/opensips[1048]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1047.47329.35]<br>
/usr/sbin/opensips[1050]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1047.47330.35]<br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c8ec) 0xb7292054<br>
/usr/sbin/opensips[1052]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1052]:
CRITICAL:db_mysql:db_mysql_submit_query: too many mysql server
reconnection failures<br>
/usr/sbin/opensips[1052]: ERROR:core:db_do_query: error while
submitting query - [select username,domain,etag,event from
presentity where expires<1489672563 order by username]<br>
/usr/sbin/opensips[1052]: ERROR:presence:msg_presentity_clean:
querying database for expired messages<br>
/usr/sbin/opensips[1052]: CRITICAL:core:timer_ticker: timer
handler <presence-pclean> lasted (3940000 us) for more
than timer tick (1000000 us) -> potential timer shifting<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1047]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1047]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c8ec) 0xb7292054<br>
/usr/sbin/opensips[1048]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1048]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1047]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1048]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1049]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1049]:
CRITICAL:db_mysql:db_mysql_submit_query: too many mysql server
reconnection failures<br>
/usr/sbin/opensips[1049]: ERROR:core:db_do_update: error while
submitting query<br>
/usr/sbin/opensips[1049]: ERROR:presence:update_presentity:
updating published info in database<br>
/usr/sbin/opensips[1049]: ERROR:presence:handle_publish: when
updating presentity<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1050]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>:
re-connected successful for 0xb7292054<br>
/usr/sbin/opensips[1050]:
CRITICAL:db_mysql:db_mysql_submit_query: too many mysql server
reconnection failures<br>
/usr/sbin/opensips[1050]: ERROR:core:db_do_update: error while
submitting query<br>
/usr/sbin/opensips[1050]: ERROR:presence:update_presentity:
updating published info in database<br>
/usr/sbin/opensips[1050]: ERROR:presence:handle_publish: when
updating presentity<br>
/usr/sbin/opensips[1047]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1047]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c8ec) 0xb7292054<br>
/usr/sbin/opensips[1048]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>:
disconnect event for 0xb7292054<br>
/usr/sbin/opensips[1048]: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>:
reseting all statements on connection: (0xb728c7e0) 0xb7292054<br>
/usr/sbin/opensips[1049]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1047.47331.25]<br>
/usr/sbin/opensips[1048]: ERROR:presence:update_presentity: No
E_Tag match [a.1489656643.1050.47435.20]<br>
</p>
....<br>
<br>
Michele<br>
<br>
<div class="moz-cite-prefix">On 16/03/2017 09:05, Michele Pinassi
wrote:<br>
</div>
<blockquote
cite="mid:299a339b-1c14-23bc-d732-f5e6ad64c5ed@unisi.it"
type="cite">
<pre wrap="">Opensips 1.11.9-notls on a Debian 8.7 x64, with more that 700 phones
registered.
Sometimes, almost twice a week, i got a lot of:
/usr/sbin/opensips[1585]: ERROR:presence:update_presentity: No E_Tag
match [a.1489409482.1585.24993.147]
/usr/sbin/opensips[1586]: ERROR:presence:update_presentity: No E_Tag
match [a.1489409482.1584.24871.146]
/usr/sbin/opensips[1584]: ERROR:presence:update_presentity: No E_Tag
match [a.1489409482.1586.24799.146]
that, after few hours, results in a:
/usr/sbin/opensips[1585]: ERROR:tm:new_t: out of mem
/usr/sbin/opensips[1584]: WARNING:core:fm_malloc: Not enough free
memory, will attempt defragmentation
/usr/sbin/opensips[1585]: ERROR:tm:t_newtran: new_t failed
/usr/sbin/opensips[1584]: ERROR:tm:new_t: out of mem
of course, users were not happy :-) so i need suggestions how to solve
the problem or how to avoid that error cause opensips to eat all the
memory available...
Thanks, Michele
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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>
<pre class="moz-signature" cols="72">--
Michele Pinassi
Responsabile Telefonia di Ateneo
Servizio Reti, Sistemi e Sicurezza Informatica - Università degli Studi di Siena
tel: 0577.(23)5000 - <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:centralino@unisi.it">centralino@unisi.it</a>
Per trovare una soluzione rapida ai tuoi problemi tecnici consulta le FAQ di Ateneo, <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.faq.unisi.it">http://www.faq.unisi.it</a> </pre>
<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>