[tracker] Comment added: usrloc driver error on query: Duplicate entry 'XXXXXXXXXXXX' for key 'ruid_idx' - sr-dev

11 Jul 2014

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

The following task has a new comment added:

FS#448 - usrloc driver error on query: Duplicate entry 'XXXXXXXXXXXX' for key
'ruid_idx'
User who did this - Savolainen Dmitri (sdi)

----------
i have tested of course.

before reboot user 1111(a)sip.erinaco.ru exists
<code>
mysql>select * from location where username='1111' and
domain='sip.erinaco.ru' \G
*************************** 1. row ***************************
           id: 112154
         ruid: ulcx-53b65903-dec-1
     username: 1111
       domain: sip.erinaco.ru
      contact: sip:1111@192.168.10.100
     received: NULL
         path: NULL
      expires: 1970-01-01 03:00:00
            q: 1.00
       callid: dfjrewr12386fd6-343(a)kamailio.mi
         cseq: 1
last_modified: 1970-01-01 03:00:00
        flags: 0
       cflags: 0
   user_agent: SIP Router MI Server
       socket: NULL
      methods: NULL
     instance: NULL
       reg_id: 0
1 row in set (0.00 sec)
</code>

[snen@sw4]# ./kamctl restart

[snen@sw4]# ./kamctl ul add &#39;1111(a)sip.erinaco.ru&#39;
'sip:1111@192.168.10.100'

let's have a look at kamailio log:
Jul 11 11:55:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'ulcx-53b65903-dec-1' for key 'ruid_idx'
Jul 11 11:57:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'ulcx-53b65903-dec-1' for key 'ruid_idx'
Jul 11 11:59:58 sw4 ./kamailio[28446]: ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'ulcx-53b65903-dec-1' for key 'ruid_idx'

let's have a look at mysql query log:
<code>
1453 Query	update location set expires='1970-01-01 03:00:00',q=1.00     
,cseq=1,flags=0,cflags=0,user_agent='SIP Router MI
Server',received=NULL,path=NULL,socket=NULL,methods=NULL,last_modified='1970-01-01
03:00:00',callid='dfjrewr12386fd6-343@kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111@192.168.10.100'
where ruid='ulcx-53b65903-dec-1'
1453 Query	insert into location
(username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,ruid,instance,reg_id,domain
) values ('1111','sip:1111@192.168.10.100','1970-01-01
03:00:00',1.00      ,&#39;dfjrewr12386fd6-343(a)kamailio.mi&#39;,1,0,0,&#39;SIP Router
MI Server',NULL,NULL,NULL,NULL,'1970-01-01
03:00:00','ulcx-53b65903-dec-1',NULL,0,'sip.erinaco.ru')
</code>
now, let's update again (second update after reboot):
[snen@sw4]# ./kamctl ul add &#39;1111(a)sip.erinaco.ru&#39;
'sip:1111@192.168.10.100'

and look at query log 
<code>
140711 12:13:58	 1453 Query	update location set expires='1970-01-01
03:00:00',q=1.00      ,cseq=2,flags=0,cflags=0,user_agent='SIP Router MI
Server',received=NULL,path=NULL,socket=NULL,methods=NULL,last_modified='1970-01-01
03:00:00',callid='dfjrewr12386fd6-343@kamailio.mi',instance=NULL,reg_id=0,contact='sip:1111@192.168.10.100'
where ruid='ulcx-53b65903-dec-1'
</code>

so cseq incremented after second update only, and the callid is the same

----------

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=448#comment1…

You are receiving this message because you have requested it from the Flyspray bugtracking
system.  If you did not expect this message or don't want to receive mails in future,
you can change your notification settings at the URL shown above.