[Spce-user] Error when upgrading

[Daniel Tiefnig]

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