[Spce-user] Error when upgrading

[John Murray]

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?

Regards

John

-----Original Message-----
From: spce-user-bounces at lists.sipwise.com [mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Jon Bonilla (Manwe)
Sent: 29 August 2012 23:49
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Error when upgrading

El Wed, 29 Aug 2012 23:21:18 +0100
"John Murray" <john.murray at skyracktelecom.com> escribió:

> Hi,
> 
>  
> 
> I get:
> 
>  
> 
> Executing /usr/share/ngcp-upgrade-2.6/ngcp-update-passwords
> 
> Adjusting passwords in /etc/ngcp-config/: OK
> 
> Running DB update...
> 
> Starting MySQL (Percona Server): mysqld already running.
> 
> Revision 0010_create_bss.up has been applied already, nothing to do.
> 
> Revision 0020_create_oss.up has been applied already, nothing to do.
> 
> Revision 0030_create_kamailio_301.up has been applied already, nothing 
> to do.
> 
> Revision 0040_create_oss_triggers_kamailio.up has been applied 
> already, nothing to do.
> 
> Revision 0050_create_accounting.up has been applied already, nothing to do.
> 
> Revision 0060_create_syslog.up has been applied already, nothing to do.
> 
> Applying revision script
> /usr/share/ngcp-db-schema/db_scripts/base/0070_not_replicated.up: 
> ERROR 1050
> (42S01) at line 2: Table 'acc_backup' already exists
> 
> failed. :(
>

No upgrade script below 8169.up should be applied in a 2.5-->2.6 install. All the db revs below that should be already in place and the upgrade script will skip them.

Could you please post the content of your ngcp database? Did you play with the database contents or are you trying to upgrade from a previous version not 2.5?

Please, give us more information about your deployment.


cheers,

Jon


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