[Spce-user] error when adding peering server

[Andrew Pogrebennyk]

Hi,
my apologies - this is an old issue where mysql triggers do not work for
cascaded delete. We fixed the trigger itself back in December in
ngcp-db-schema 3.1.5, but forgot to clean up the stale records from
kamailio DB. Will fix it today.
In the meantime, you can fix your DB by running:
mysql -e "use kamailio; select * from peer_preferences where uuid not in
(select flags from lcr_gw);"

Thanks for the report!
Andrew

On 03/07/2014 12:43 PM, gerry kernan wrote:
> Hi
> 
> Woulld anyone know that this error means and know do u clear it. It is
> coming up when I try to add a peering server to a peering group.
> 
> Failed to create peering server. (Duplicate entry '45')
>