[sr-dev] duplicate ruid_idx entry

Juha Heinanen jh at tutpro.com
Sat Apr 13 09:56:28 CEST 2013


i have in usrloc memory a single AOR that has two contacts with the same
ruid:

sip-proxy_ctl mi ul_dump | grep -E -i -w 'AOR|Ruid'
AOR:: jh at test.fi
Ruid:: uloc-516852e9-1a18-1
Ruid:: ulcx-516852e9-1a16-1
Ruid:: ulcx-516852e9-1a16-1

in location table is it not possible because of this:

    <index>
        <name>ruid_idx</name>
        <colref linkend="ruid"/>
        <unique/>
    </index>

as result, i'm getting these kind of errors to syslog:

Apr 13 10:48:40 siika /usr/sbin/sip-proxy[6704]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry 'ulcx-516852e9-1a16-1' for key 'ruid_idx'
Apr 13 10:48:40 siika /usr/sbin/sip-proxy[6704]: ERROR: <core> [db_query.c:235]: error while submitting query
Apr 13 10:48:40 siika /usr/sbin/sip-proxy[6704]: ERROR: usrloc [ucontact.c:615]: inserting contact in db failed
Apr 13 10:48:40 siika /usr/sbin/sip-proxy[6704]: ERROR: usrloc [urecord.c:352]: inserting contact into database failed

this happened while i was doing tests with master, but may be this bug
already exists in 4.0.

how is it possible that memory usrloc has two contacts with same ruid?

-- juha



More information about the sr-dev mailing list