<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">sip:10271225@192.168.0.100:5060</a></td>
<td class="" 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">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">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">sip:10271225@192.168.0.100:5060</a></td>
<td class="" 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">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">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">sip:10271225@192.168.0.100:5060</a></td>
<td class="" 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">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">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">sip:10271225@192.168.0.100:5060</a></td>
<td class="" 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">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">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">sip:10271225@192.168.0.100:5060</a></td>
<td class="" 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">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">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 class="gmail_signature"><div dir="ltr">____________<div>Best regards,</div><div>Igor Pavlov</div></div></div></div>
</div></div></div>