[OpenSIPS-Devel] Location table structure - account_contact_idx

[Liviu Chircu]

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.

Regards,

Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com

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 ;