EC
1654
MariaDBERRORCommonReplicationHIGH confidence

NDB replication schema error

Production Risk

High — NDB replication will not start until the schema error is resolved.

What this means

An error occurred related to the NDB replication schema, typically because the ndb_replication table has an invalid or unexpected structure.

Why it happens
  1. 1The ndb_replication table is missing, corrupted, or has an unexpected schema.
  2. 2Incompatible NDB Cluster and MySQL server versions.
How to reproduce
trigger — this will error
trigger — this will error
-- Starting replication with a malformed ndb_replication table

expected output

ERROR 1654 (HY000): NDB replication schema error.

Fix

Recreate the ndb_replication table with the correct schema

Recreate the ndb_replication table with the correct schema
DROP TABLE IF EXISTS mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication (
  db VARBINARY(63) NOT NULL,
  table_name VARBINARY(63) NOT NULL,
  server_id INT UNSIGNED NOT NULL,
  binlog_type INT UNSIGNED DEFAULT 0,
  conflict_fn VARBINARY(128) DEFAULT NULL,
  PRIMARY KEY (db, table_name, server_id)
) ENGINE=NDB;

Why this works

A correctly structured ndb_replication table allows NDB replication to initialise.

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 1654 ER_NDB_REPLICATION_SCHEMA_ERROR

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors