[sr-dev] [tracker] Task opened: duplicate entry for key ruid_idx

sip-router bugtracker at sip-router.org
Sat Apr 13 10:31:16 CEST 2013


THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Juha Heinanen (jh) 

Attached to Project - sip-router
Summary - duplicate entry for key ruid_idx
Task Type - Bug Report
Category - Module
Status - New
Assigned To - 
Operating System - All
Severity - High
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - start kamailio in usrloc db_mode=1 with empty location table.  give the two ul_add commands below and the second will result into duplicate entry for key ruid_idx error.

this test was done with master, but the bug may also exist in 4.0.

Apr 13 11:26:04 siika /usr/sbin/sip-proxy[12270]: INFO: Handling XMLRPC POST from <127.0.0.1> with body <<?xml version="1.0" ?><methodCall><methodName>mi</methodName><params><param><value><string>ul_add</string></value></param><param><value><string>location</string></value></param><param><value><string>jh at test.fi</string></value></param><param><value><string>sip:jh at as.test.fi</string></value></param><param><value><int>0</int></value></param><param><value><string>0.10</string></value></param><param><value><int>0</int></value></param><param><value><int>0</int></value></param><param><value><int>16</int></value></param><param><value><int>15</int></value></param></params></methodCall>>


Apr 13 11:26:10 siika /usr/sbin/sip-proxy[12276]: INFO: Handling XMLRPC POST from <127.0.0.1> with body <<?xml version="1.0" ?><methodCall><methodName>mi</methodName><params><param><value><string>ul_add</string></value></param><param><value><string>location</string></value></param><param><value><string>jh at test.fi</string></value></param><param><value><string>sip:jh at vm.test.fi</string></value></param><param><value><int>0</int></value></param><param><value><string>0.50</string></value></param><param><value><int>0</int></value></param><param><value><int>0</int></value></param><param><value><int>16</int></value></param><param><value><int>15</int></value></param></params></methodCall>>
Apr 13 11:26:10 siika /usr/sbin/sip-proxy[12276]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry 'ulcx-51691678-2fc1-1' for key 'ruid_idx'
Apr 13 11:26:10 siika /usr/sbin/sip-proxy[12276]: ERROR: <core> [db_query.c:235]: error while submitting query
Apr 13 11:26:10 siika /usr/sbin/sip-proxy[12276]: ERROR: usrloc [ucontact.c:615]: inserting contact in db failed
Apr 13 11:26:10 siika /usr/sbin/sip-proxy[12276]: ERROR: usrloc [urecord.c:480]: failed to insert in database



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

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.



More information about the sr-dev mailing list