My Oracle Support Banner

How To Recover The mysql.ndb_sql_metadata System Table If It's Restored With --disable-indexes Option, But --rebuild-index Option Is Not Applied (Doc ID 2997258.1)

Last updated on MAY 13, 2024

Applies to:

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

Symptoms

 This document describes how to fix the mysql.ndb_sql_metadata system table from the state that the ordered index part of the PRIMARY key does not exist. If a native backup is restored to the new cluster using the ndb_restore command with --disable-indexes --include-stored-grants options causes the mysql.ndb_sql_metadata system table to be restored without the ordered index part of the PRIMARY key. (Only the hash index for the PRIMARY key exists.) If you happen to take a backup when the ordered index part of the PRIMARY key does not exists, the table will never get the normal state by restoring that backup. Without the ordered index part of this table, an SQL node will report errors like below:

 

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
Cause
Solution
References


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