[Spce-user] DB table ngcp.db_schema contains wrong value

[Alex Lutay]

Hi all!

Max, thank you for pointing the problem and thank you to Marc for
clarification. I have pushed the additional in schema tables.
So, for now users will see:
> Error: DB table ngcp.db_schema contains duplicated revisions: 12345
> Please execute: mysql -uroot ngcp -e "delete n2 FROM $TABLE n1, $TABLE n2 WHERE n1.revision = n2.revision AND n1.node IN ('spce','') AND n2.node NOT IN ('spce','');"
The fixes are in trunk and mr3.6 and will be hotfixed to mr3.6.1/mr3.6.2
as soon as pass all the auto-upgrade tests.

Thank you!

On 05/01/15 18:11, Marc Storck wrote:
> I had them same issue, it turned out that my db_schema table had
> duplicate entries for certain revisions (1 line with node=$hostname and
> 1 line with node=spce).
>
> I had to manually remove the duplicated where node=$hostname.
>
> Please replace $hostname with the value that shows up in your table.
>
> Regards,
>
> Marc
>
>> On 05 Jan 2015, at 17:59, Max Power <mpower at entelit.ca
>> <mailto:mpower at entelit.ca>> wrote:
>>
>> Hi All,
>> When trying to update from 3.6.1 to 3.6.2 we are getting an error we
>> have been unable to move past. The system is otherwise up to date. We
>> have tried running the command it suggested and poked through the
>> database. We haven’t been able to resolve. Any advice?
>> *Error: DB table ngcp.db_schema contains wrong value.*
>> *Please execute 'mysql -uroot "update ngcp.db_schema set node='spce'"'*

-- 
Alexander Lutay
Head of Quality Assurance
Sipwise GmbH, Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Office: +43(0)13012036
Email: alutay at sipwise.com
Website: http://www.sipwise.com

Meet us @ AFRICACOM : Booth A17/A18
11-13 November 2014 : CTICC Cape Town, South Africa