upgrade failing from 2.0.1 to 2.2.0

[Robert Adams]

When upgrading from 2.0.1 load to the 2.2.0 load the upgrade script was failing.

Validate InfiniDB System Catalog:
ERROR: Database upgrade script failed

Below is a work-around to get you going when you get this error when starting 'infinidb:

Validate InfiniDB System Catalog:
ERROR: Database upgrade script failed

ENTER THESE 3 SQL STATEMENTS IN THE 'idbmysql' CONSOLE FOR DATABASE 'calpontsys':

# idbmysql calpontsys

mysql> alter table syscolumn add (nextvalue bigint);
mysql> update syscolumn set nextvalue=1 where nextvalue is null;
mysql> update syscolumn set autoincrement='n' where autoincrement is null;
mysql> exit

Now you can restart 'infinidb' and make sure it starts up cleanly and you should be good to go:

# /etc/init.d/infinidb restart

[Robert Adams (radams-calpont)]

Resolved in the 2.2.1 release