[Spce-user] error when adding peering server

[gerry kernan]

Hi 
 
I found this error in the logs 
 
Mar  7 11:41:59 sipwise /usr/share/ngcp-panel/ngcp_panel_fastcgi.pl: Failed to create peering server. (DBIx::Class::ResultSet::create(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry '45' for key 'PRIMARY' [for Statement "INSERT INTO `provisioning`.`voip_peer_hosts` ( `group_id`, `host`, `ip`, `name`, `port`, `transport`, `via_route`, `weight`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0='3', 1=undef, 
2="host", 3="AsteriskDC", 4="5060", 5="1", 6=undef, 7="1"] at /usr/share/perl5/NGCP/Panel/Controller/Peering.pm line 221#012)
 
 
mysql> select * from voip_peer_hosts;
+----+----------+------------------+---------------+------+------+-----------+--------+-----------+--------+
| id | group_id | name             | ip            | host | port | transport | weight | via_route | via_lb |
+----+----------+------------------+---------------+------+------+-----------+--------+-----------+--------+
|  3 |        2 | Digiweb-Infinity | X.X.X.X | NULL | 5060 |         1 |      1 | NULL      |      0 |
+----+----------+------------------+---------------+------+------+-----------+--------+-----------+--------+
1 row in set (0.00 sec)
 
Looks like it is trying to add the new peer host with the same ID value 
 
From: Barry Flanagan [mailto:barry at flanagan.ie] 
Sent: 07 March 2014 11:56
To: gerry kernan
Cc: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] error when adding peering server
 
On 7 March 2014 11:43, gerry kernan <gerry.kernan at infinityit.ie> 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')
 
Hi Gerry,
 
You would need to check the /var/log/ngcp/oss.log  - it should tell you in which table the constraint violation is. 
 
-Barry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140307/676cffb0/attachment-0001.html>