1777
MySQLERRORNotableReplicationHIGH confidence
Binlog statement mode and no replicated tables
Production Risk
High — replicated data may be inconsistent.
What this means
A statement using STATEMENT binlog format references tables that are excluded from replication by replication filters, creating a potential inconsistency.
Why it happens
- 1binlog_format=STATEMENT combined with replicate_ignore_table or replicate_wild_ignore_table filters.
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs when filtered tables are referenced in statement-mode binlog events
expected output
ERROR 1777 (HY000): Statement cannot be executed because it refers to a table that is excluded from replication.
Fix
Switch to ROW-based replication to avoid statement-filter conflicts
Switch to ROW-based replication to avoid statement-filter conflicts
SET GLOBAL binlog_format = 'ROW';
Why this works
Row-based replication handles filtered tables without ambiguity.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1777 ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev