EC
1237
MySQLWARNINGCriticalReplicationHIGH confidence

Slave SQL thread ignored query due to replicate table rules

Production Risk

Low — expected behavior when using table filters; verify intent.

What this means

ER_SLAVE_IGNORED_TABLE (1237, SQLSTATE HY000) is an informational warning indicating that the replica SQL thread intentionally skipped a query because it matched a replicate-ignore-table or replicate-do-table filter rule.

Why it happens
  1. 1replicate-ignore-table filter matching the target table
  2. 2replicate-do-table filter not including the target table
How to reproduce
trigger — this will error
trigger — this will error
-- With --replicate-ignore-table=mydb.temp_table on replica
-- Master executes:
INSERT INTO mydb.temp_table VALUES (1);
-- Replica skips it, logs warning 1237

expected output

Warning (Code 1237): Slave SQL thread ignored the query because of replicate-*-table rules

Fix

Review and adjust replication filters

Review and adjust replication filters
-- On replica, check active filters:
SHOW SLAVE STATUSG
-- Or:
SHOW VARIABLES LIKE 'replicate%';

Why this works

Verify that the filter rules match the intended replication scope. Adjust if necessary.

Sources
Official documentation ↗

MySQL 8.0 — 1237 ER_SLAVE_IGNORED_TABLE

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

← All MySQL errors