[Spce-user] Error when upgrading

[John Murray]

Great. That worked on the first box with little config.

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

Thanks

John


-----Original Message-----
From: Jon Bonilla (Manwe) [mailto:jbonilla at sipwise.com] 
Sent: 30 August 2012 00:07
To: spce-user at lists.sipwise.com
Cc: John Murray
Subject: Re: [Spce-user] Error when upgrading

El Thu, 30 Aug 2012 00:00:06 +0100
"John Murray" <john.murray at skyracktelecom.com> escribió:

> The upgrade is from clean 2.5 -> 2.6.
> 
> There are only 2 peers setup and no users as this is transit switch.
> 
> As per Daniel's email I get:
> 
> mysql -e 'select * from ngcp.db_schema where revision = 70'
> +----+----------+----------+---------------------+
> | id | revision | node     | applied_at          |
> +----+----------+----------+---------------------+
> |  7 |       70 | skyrack2 | 2012-08-10 16:00:28 |
> +----+----------+----------+---------------------+
> 
> The hostname is now skt-salem02.skyrack.net due to an admin revision. 
> Can I revert the hostname and rerun the ngcp-upgrade?
> 


You could do that or just update the node name in the database:

mysql> update ngcp.db_schema set node='mynewhostname';


mysql> update ngcp.cfg_schema set node='mynewhostname'; (this is new in 
mysql> 2.6 you'll probably don't have it yet)


We'll check this as looks like code from PRO where we have different db scripts for different nodes. It shouldn't be checked on CE systems.

Please let us know if this worked for you.