Cluster Alter Table Cannot Complete INPLACE If Old Type Temporal Columns In Use (Doc ID 2104718.1)

Last updated on MAY 12, 2016

Applies to:

MySQL Cluster - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

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.

 

Changes

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms