[Spce-user] Error when upgrading

John Murray john.murray at skyracktelecom.com
Thu Aug 30 17:10:26 EDT 2012

Yea! Thanks guys this is now upgraded fully.

I used mysql client to remove one of the empty peering rules in lcr_rules
table and then:

mysql < /usr/share/ngcp-db-schema/db_scripts/diff/9868.down

now the upgrade works.



-----Original Message-----
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 mailing list