[sr-dev] git:master:d72ac166: srdb1/schema: removed unique constraint from connection_idx

[Ovidiu Sas]

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 <jh at tutpro.com> wrote:
> Module: kamailio
> Branch: master
> Commit: d72ac166b152ca6906248d67e2605d5b283fa01e
> URL: https://github.com/kamailio/kamailio/commit/d72ac166b152ca6906248d67e2605d5b283fa01e
>
> Author: Juha Heinanen <jh at tutpro.com>
> Committer: Juha Heinanen <jh at tutpro.com>
> 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
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com