[OpenSIPS-Users] Usrloc Write-Back scheme doesn't delete expired contacts from location. 1.10

[Игорь Павлов]

Somebody met such problem?

add:
version: opensips 1.10.4-tls (x86_64/linux)
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
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
@(#) $Id$
main.c compiled on 00:06:21 Apr  3 2015 with gcc 4.4.7


____________
Best regards,
Igor Pavlov

2015-07-21 23:28 GMT+04:00 Игорь Павлов <i.p at ringcloud.ru>:

> 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:
>
>     username contact expires q callid user_agent socket  10271225
> sip:10271225 at 192.168.0.100:5060 17.07.2015 17:44 -1.00
> 000AD87F-8E28-E511-95FA-ED5AA7718DC4 at 79.120.58.194 SIPPER for PhonerLite
> udp:192.168.0.5:5060  10271225  sip:10271225 at 192.168.0.100:5060 16.07.2015
> 15:39 -1.00 0018FF86-8E28-E511-B071-73FCC3C39125 at 79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225 at 192.168.0.100:5060 18.07.2015
> 16:01 -1.00 805B93D6-8E2B-E511-B232-C3E27EBE0AEC at 79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225 at 192.168.0.100:5060 21.07.2015
> 10:00 -1.00 80612236-8A2C-E511-B771-23AC57084C2D at 79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225 at 192.168.0.100:5060 17.07.2015
> 9:55 -1.00 807832C3-8E28-E511-AFE6-E49E9283A1CD at 79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060
>
> At same time, in syslog, I can see this:
>
> Jul 21 18:59:36 [37186]:
> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062):
> Duplicate entry '10271225-domain-sip:1027
> 1225 at 192.168.0.100:5060-00705664-8' for key 'account_contact_idx'
> Jul 21 18:59:36 [37186]: ERROR:usrloc:db_update_ucontact: updating
> database failed
> Jul 21 18:59:36 [37186]: ERROR:usrloc:wb_timer: updating contact in db
> failed
> Jul 21 19:01:07 [37186]:
> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062):
> Duplicate entry '10271225-domain-sip:1027
> 1225 at 192.168.0.100:5060-00705664-8' for key 'account_contact_idx'
> Jul 21 19:01:07 [37186]: ERROR:usrloc:db_update_ucontact: updating
> database failed
> Jul 21 19:01:07 [37186]: ERROR:usrloc:wb_timer: updating contact in db
> failed
>
>
> ____________
> Best regards,
> Igor Pavlov
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150727/927223a2/attachment.htm>