[Spce-user] Duplicate key error while inserting peering rule

[Henk]

Hi all,

Solved it! The same peering server was defined in two peering groups.
As the system doesn't check this (until it's too late), can someone 
please explain what the exact restrictions are?

About my second question, to get the tables in sync again disable all 
rules and servers. After that make sure lcr_gw and lcr_rule are empty (I 
had 2 records in lcr_gw).
Then just re-enable everything and the lcr tables are fully restored.

Regards,

Henk Plessius
VoipDigit

On 30-11-2017 17:05, Henk wrote:
> Hi all,
>
> I get this message when I want to create an extra peering rule:
>
> MSG="Failed to create peering rule Duplicate entry '19-3' for key 
> 'rule_id_gw_id_idx' [for Statement "INSERT INTO 
> `provisioning`.`voip_peer_rules` ....
>
> I traced it back to one of the triggers that updates the kamailio 
> table, so it seems the kamailio and provision tables are out of sync. 
> Is there a way to fix this other then removing all gateways and start 
> over?
>
> Regards,
>
> Henk Plessius
>
> VoipDigit
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user