[Spce-user] Error when upgrading

[John Murray]

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.

Regards

John

-----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.

br,
daniel

_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
http://lists.sipwise.com/listinfo/spce-user