[OpenSIPS-Devel] Duplicate entry in "location" table

[Iñaki Baz Castillo]

Hi, I've got two exact rows (*al* the fields) in "location" table,
this shouldn't occur since a REGISTER from the same user with same
"Contact" should replace/update the existing entry.
Well, I'm restarting OpenSIPS, maybe there is the problem.

Anyway, I wonder if it makes sense an UNIQUE key in "location" table
containing the following fields:
- username
- domain
- contact
- received
- patch (not sure)

"received" should be included in the match since the same AoR can be
registered by two devices with same private IP but in different LAN's
(so different "received" value).

This match should be done, theorically, by the registar without help
from the database, but it's not the first time I see two exact rows in
location table.

PD: I use modparam("usrloc", "db_mode", 3).

Regards.

-- 
Iñaki Baz Castillo
<ibc at aliax.net>