[sr-dev] duplicate ruid_idx entry

[Daniel-Constantin Mierla]

It should not happen, is the same device or two different phones using 
same AoR?

Cheers,
Daniel

On 4/13/13 9:56 AM, Juha Heinanen wrote:
> 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
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
  - http://conference.kamailio.com -