My Oracle Support Banner

Tables Created in 5.6 Using Columns Having a MYSQL_TYPE_GEOMETRY Data Type (POINT, POLYGON etc) Cannot Be Upgraded to 8.0: Error MY-012064, MY-012070, MY-010767 (Doc ID 2742305.1)

Last updated on MAY 05, 2021

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

 If the server is once used as MySQL 5.6 series, and has spatial columns, and the server is upgraded to MySQL 5.7 series, and is upgraded to MySQL 8.0 series later, then the upgrade fails with the following error.

The server won't start if this error happens.

Changes

 The error happens when the server is being upgraded to MySQL 8.0 series using inplace upgrade method. This problem happens when the following conditions are met:

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 1. Check If Your System Is Affected
 2. Logical Upgrade
 3. Rebuild Table On 5.7
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.