<div dir="ltr">Somebody met such problem? <div><br><div>add:</div><div><div>version: opensips 1.10.4-tls (x86_64/linux)</div><div>flags: STATS: On, USE_IPV6, USE_TCP, USE_TLS, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT</div><div>ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535</div><div>poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.</div><div>@(#) $Id$</div><div>main.c compiled on 00:06:21 Apr 3 2015 with gcc 4.4.7</div><div><br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr">____________<div><div style="color:rgb(0,0,0);font-size:12.8000001907349px">Best regards,</div><div style="color:rgb(0,0,0);font-size:12.8000001907349px">Igor Pavlov</div></div></div></div></div>
<br><div class="gmail_quote">2015-07-21 23:28 GMT+04:00 Игорь Павлов <span dir="ltr"><<a href="mailto:i.p@ringcloud.ru" target="_blank">i.p@ringcloud.ru</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi all. We have a problem with USRLOC, we are using write-back scheme with 90 seconds timer_interval. In location table presents expired contacts like this:<div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="1123" style="border-collapse:collapse;width:842pt">
<colgroup><col width="77" style="width:58pt">
<col width="217" style="width:163pt">
<col width="107" style="width:80pt">
<col width="64" style="width:48pt">
<col width="371" style="width:278pt">
<col width="143" style="width:107pt">
<col width="144" style="width:108pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" width="77" style="height:15pt;width:58pt">username</td>
<td width="217" style="width:163pt">contact</td>
<td width="107" style="width:80pt">expires</td>
<td width="64" style="width:48pt">q</td>
<td width="371" style="width:278pt">callid</td>
<td width="143" style="width:107pt">user_agent</td>
<td width="144" style="width:108pt">socket</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" align="right" style="height:15pt">10271225 </td>
<td> <a href="http://sip:10271225@192.168.0.100:5060" target="_blank">sip:10271225@192.168.0.100:5060</a></td>
<td align="right">17.07.2015 17:44</td>
<td>-1.00</td>
<td><a href="mailto:000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194" target="_blank">000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194</a></td>
<td>SIPPER for PhonerLite</td>
<td>udp:<a href="http://192.168.0.5:5060" target="_blank">192.168.0.5:5060</a></td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" align="right" style="height:15pt">10271225 </td>
<td><a href="http://sip:10271225@192.168.0.100:5060" target="_blank">sip:10271225@192.168.0.100:5060</a></td>
<td align="right">16.07.2015 15:39</td>
<td>-1.00</td>
<td><a href="mailto:0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194" target="_blank">0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194</a></td>
<td>SIPPER for PhonerLite</td>
<td>udp:<a href="http://192.168.0.5:5060" target="_blank">192.168.0.5:5060</a></td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" align="right" style="height:15pt">10271225 </td>
<td><a href="http://sip:10271225@192.168.0.100:5060" target="_blank">sip:10271225@192.168.0.100:5060</a></td>
<td align="right">18.07.2015 16:01</td>
<td>-1.00</td>
<td><a href="mailto:805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194" target="_blank">805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194</a></td>
<td>SIPPER for PhonerLite</td>
<td>udp:<a href="http://192.168.0.5:5060" target="_blank">192.168.0.5:5060</a></td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" align="right" style="height:15pt">10271225 </td>
<td><a href="http://sip:10271225@192.168.0.100:5060" target="_blank">sip:10271225@192.168.0.100:5060</a></td>
<td align="right">21.07.2015 10:00</td>
<td>-1.00</td>
<td><a href="mailto:80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194" target="_blank">80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194</a></td>
<td>SIPPER for PhonerLite</td>
<td>udp:<a href="http://192.168.0.5:5060" target="_blank">192.168.0.5:5060</a></td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" align="right" style="height:15pt">10271225 </td>
<td><a href="http://sip:10271225@192.168.0.100:5060" target="_blank">sip:10271225@192.168.0.100:5060</a></td>
<td align="right">17.07.2015 9:55</td>
<td>-1.00</td>
<td><a href="mailto:807832C3-8E28-E511-AFE6-E49E9283A1CD@79.120.58.194" target="_blank">807832C3-8E28-E511-AFE6-E49E9283A1CD@79.120.58.194</a></td>
<td>SIPPER for PhonerLite</td>
<td>udp:<a href="http://192.168.0.5:5060" target="_blank">192.168.0.5:5060</a></td>
</tr></tbody></table><div><br></div><div>At same time, in syslog, I can see this:</div><div><br></div><div><div><div>Jul 21 18:59:36 [37186]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062): Duplicate entry '10271225-domain-sip:1027</div><div>1225@192.168.0.100:5060-00705664-8' for key 'account_contact_idx'</div><div>Jul 21 18:59:36 [37186]: ERROR:usrloc:db_update_ucontact: updating database failed</div><div>Jul 21 18:59:36 [37186]: ERROR:usrloc:wb_timer: updating contact in db failed</div><div>Jul 21 19:01:07 [37186]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062): Duplicate entry '10271225-domain-sip:1027</div><div>1225@192.168.0.100:5060-00705664-8' for key 'account_contact_idx'</div><div>Jul 21 19:01:07 [37186]: ERROR:usrloc:db_update_ucontact: updating database failed</div><div>Jul 21 19:01:07 [37186]: ERROR:usrloc:wb_timer: updating contact in db failed</div></div><div><br></div><div><br></div><div><div><div dir="ltr">____________<div>Best regards,</div><div>Igor Pavlov</div></div></div></div>
</div></div></div>
</blockquote></div><br></div></div></div></div>