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

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

2015-08-04 Thread Bogdan-Andrei Iancu


Hi Igor,

What contact matching algorithm do you use ?
http://www.opensips.org/html/docs/modules/1.10.x/usrloc.html#matching-mode

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 21.07.2015 22:28, Игорь Павлов wrote:
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:


usernamecontact expires q   callid  user_agent  
socket
10271225 	sip:10271225@192.168.0.100:5060 
 	17.07.2015 17:44 	-1.00 
000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194 
 	SIPPER 
for PhonerLite 	udp:192.168.0.5:5060 
10271225 	sip:10271225@192.168.0.100:5060 
 	16.07.2015 15:39 	-1.00 
0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194 
 	SIPPER 
for PhonerLite 	udp:192.168.0.5:5060 
10271225 	sip:10271225@192.168.0.100:5060 
 	18.07.2015 16:01 	-1.00 
805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194 
 	SIPPER 
for PhonerLite 	udp:192.168.0.5:5060 
10271225 	sip:10271225@192.168.0.100:5060 
 	21.07.2015 10:00 	-1.00 
80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194 
 	SIPPER 
for PhonerLite 	udp:192.168.0.5:5060 
10271225 	sip:10271225@192.168.0.100:5060 
 	17.07.2015 9:55 	-1.00 
807832C3-8E28-E511-AFE6-E49E9283A1CD@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@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@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


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-07-27 Thread Игорь Павлов

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 Игорь Павлов :

> 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@192.168.0.100:5060 17.07.2015 17:44 -1.00
> 000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194 SIPPER for PhonerLite
> udp:192.168.0.5:5060  10271225  sip:10271225@192.168.0.100:5060 16.07.2015
> 15:39 -1.00 0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225@192.168.0.100:5060 
> 18.07.2015
> 16:01 -1.00 805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225@192.168.0.100:5060 
> 21.07.2015
> 10:00 -1.00 80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194 SIPPER for
> PhonerLite udp:192.168.0.5:5060  10271225  sip:10271225@192.168.0.100:5060 
> 17.07.2015
> 9:55 -1.00 807832C3-8E28-E511-AFE6-E49E9283A1CD@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@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@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
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-07-21 Thread Игорь Павлов

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@192.168.0.100:5060 17.07.2015 17:44 -1.00
000AD87F-8E28-E511-95FA-ED5AA7718DC4@79.120.58.194 SIPPER for PhonerLite
udp:192.168.0.5:5060  10271225  sip:10271225@192.168.0.100:5060 16.07.2015
15:39 -1.00 0018FF86-8E28-E511-B071-73FCC3C39125@79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225@192.168.0.100:5060 18.07.2015
16:01 -1.00 805B93D6-8E2B-E511-B232-C3E27EBE0AEC@79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225@192.168.0.100:5060 21.07.2015
10:00 -1.00 80612236-8A2C-E511-B771-23AC57084C2D@79.120.58.194 SIPPER for
PhonerLite udp:192.168.0.5:5060  10271225
sip:10271225@192.168.0.100:5060 17.07.2015
9:55 -1.00 807832C3-8E28-E511-AFE6-E49E9283A1CD@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@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@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
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

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

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

3 matches

Site Navigation

Mail list logo

Footer information