[OpenSIPS-Devel] Location table structure - account_contact_idx

Liviu Chircu liviu at opensips.org
Thu Oct 17 05:09:36 EDT 2019

Hi Donat,

In 2.4, we drew a more clear separation between the "restart 
persistence" and "hot backup"
concepts.  Thus, we no longer recommend (nor did we test 2.4 with) a 
shared DB between
the active and backup servers: each box should have its local DB 
server.  If you want a
"hot backup" behavior, make sure to also cluster them together, so their 
usrloc caches stay in
sync via runtime data replication.

The "duplicate primary key" errors are expected with your setup.  Once 
you fix the location
tables architecture, they should go away.


Liviu Chircu
OpenSIPS Developer

On 17.10.2019 10:26, Donat Zenichev wrote:
> 2.1. At this point we still have a location record in the (shared) 
> mysql database for subscriber A ;

More information about the Devel mailing list