<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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>
    <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 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 class="moz-txt-link-freetext" href="http://www.faq.unisi.it">http://www.faq.unisi.it</a> </pre>
  </body>
</html>