This seems to create issues for users re-registering over udp. For udp connections, the server_id is 0 and the connection_id is -1. If a user crashes and re-registers the location table cannot be updated: ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Duplicate entry '0--1' for key 'connection_idx' (1062)
On Wed, Mar 23, 2016 at 10:33 AM, Juha Heinanen <[email protected]> wrote: > Module: kamailio > Branch: master > Commit: d72ac166b152ca6906248d67e2605d5b283fa01e > URL: > https://github.com/kamailio/kamailio/commit/d72ac166b152ca6906248d67e2605d5b283fa01e > > Author: Juha Heinanen <[email protected]> > Committer: Juha Heinanen <[email protected]> > Date: 2016-03-23T16:32:06+02:00 > > srdb1/schema: removed unique constraint from connection_idx > > --- > > Modified: lib/srdb1/schema/location.xml > > --- > > Diff: > https://github.com/kamailio/kamailio/commit/d72ac166b152ca6906248d67e2605d5b283fa01e.diff > Patch: > https://github.com/kamailio/kamailio/commit/d72ac166b152ca6906248d67e2605d5b283fa01e.patch > > --- > > diff --git a/lib/srdb1/schema/location.xml b/lib/srdb1/schema/location.xml > index 07c8d58..c22fcaf 100644 > --- a/lib/srdb1/schema/location.xml > +++ b/lib/srdb1/schema/location.xml > @@ -232,7 +232,6 @@ > <name>connection_idx</name> > <colref linkend="server_id"/> > <colref linkend="connection_id"/> > - <unique/> > </index> > > > > > _______________________________________________ > sr-dev mailing list > [email protected] > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
