db sync fails to create node_tags and portgroups table in mysql 5.6

[narasimha18sv]

I am using mysql 5.6 version. While trying to sync ironic db I am getting below issue.

http://paste.openstack.org/show/547914/

After searcing in net got the below info

MySQL Cluster formerly supported online ALTER TABLE operations using the ONLINE and OFFLINE keywords. These keywords are no longer supported; their use causes a syntax error. MySQL Cluster NDB 7.5 (and later) supports online operations using the same ALGORITHM=INPLACE syntax used with the standard MySQL Server. See Section 14.1.8.2, “ALTER TABLE Online Operations in MySQL Cluster”, for more information

Please help me in resolving this issue

[narasimha18sv (narasimha18sv)]

I am using NDB cluster engine

[Sam Betts (sambetts)]

This bug has nothing to do with ONLINE/OFFLINE operations, in this migration "online" is the name of the column we are trying to add.

This is likely something to do with the syntax that sqlalchemy is generating to perform the operation and your configured mysql engine in the ironic.config file.

At first glance this command:

    ALTER TABLE conductors ADD COLUMN online BOOL;

looks like incorrect syntax, some quick googling tells me that normally it should be:

    ALTER TABLE conductors ADD online BOOL;

I think we need more information to confirm this as a bug.