[Spce-user] Error when upgrading
john.murray at skyracktelecom.com
Wed Aug 29 20:36:54 EDT 2012
Your efforts are much appreciated.
From: spce-user-bounces at lists.sipwise.com
[mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Daniel Tiefnig
Sent: 30 August 2012 01:28
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Error when upgrading
On 08/30/2012 01:36 AM, John Murray wrote:
> Great. That worked on the first box with little config.
Ok, we'll fix that for the future.
> On another box I now get similar to Matthew Ogden:
> Applying revision script
> /usr/share/ngcp-db-schema/db_scripts/diff/9868.up: ERROR 1062 (23000)
> at line 10: Duplicate entry '1--' for key 'lcr_id_prefix_from_uri_idx'
> failed. :(
> and tried:
> mysql < /usr/share/ngcp-db-schema/db_scripts/diff/9868.down ERROR
> 1091 (42000) at line 7: Can't DROP 'lcr_id_prefix_from_uri_idx'; check
> that column/key exists
Yes, the problem here is that the upgrade script tries to create a unique
key which fails due to a duplicate. The downgrade script tries to remove
that key, which of course does not exist. Need to look into that revision
more deeply, please expect a fix by tomorrow. The error is caused by
identical peering rules, in your case it are the empty rules.
Spce-user mailing list
Spce-user at lists.sipwise.com
More information about the Spce-user