Cluster Alter Table Cannot Complete INPLACE If Old Type Temporal Columns In Use
Last updated on MAY 12, 2016
Applies to:MySQL Cluster - Version 7.3 and later
Information in this document applies to any platform.
In a running cluster, customer performed an alter table operation , which according to the manual ( Beginning with MySQL 5.1.17 ) has the potential to be performed ONLINE / algorithm=inplace ( synonymous terms in this context ).
When attempted the Cluster complained that this was not possible.
On investigation, the version of the Cluster software ( 7.3.6 ) was consistent with the ONLINE operation capability.
The cluster had been previously running on a version ( 7.2.15 ) and had been successfully upgraded in place to 7.3.6 a number of months prior.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms