[Spce-user] error while upgrading

[Gene]

Thanks.  Next error:

Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/10180.up: ERROR 1050 (42S01) at line 13: Table 'newtemp' already exists

Attempting:  

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

yields:

ERROR 1091 (42000) at line 3: Can't DROP 'lcr_id_prefix_from_uri_idx'; check that column/key exists

 

-----Original Message-----
From: Jon Bonilla (Manwe) [mailto:jbonilla at sipwise.com] 
Sent: Tuesday, September 04, 2012 9:46 AM
To: spce-user at lists.sipwise.com
Cc: Gene 
Subject: Re: [Spce-user] error while upgrading

El Tue, 4 Sep 2012 08:08:09 -0400
"Gene " <gwillingham at telasip.com> escribió:

> Jon,
> 
> I encountered this issue as well.  The fix resolved the issue below 
> but now I have encountered another error.
> 
> Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/9868.up:
> ERROR 1060 (42S21) at line 3: Duplicate column name 'attrs'
> 
> This is an upgrade 2.4 -> 2.5 -> 2.6...  If this helps..
> 
>

Hi Gene.

That's because the script failed in the first place after adding that line and now it tries to do it again.

Please apply the 9868.down script first to remove the partial changes and then try to upgrade again.

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