1730
MySQLERRORNotableReplicationHIGH confidence
Only format description and row events are allowed in BINLOG statements
Production Risk
Medium — binlog replay fails; data may not be applied.
What this means
A BINLOG statement contained an event type other than a format description event or a row-based event, which is not permitted.
Why it happens
- 1Manually constructing or replaying a BINLOG statement with an unsupported event type.
How to reproduce
trigger — this will error
trigger — this will error
-- Occurs when mysqlbinlog output is replayed and contains unsupported event types.
expected output
ERROR 1730 (HY000): Only Format_description_log_event and row events are allowed in BINLOG statements.
Fix
Replay only valid ROW-format binlog events
Replay only valid ROW-format binlog events
mysqlbinlog --base64-output=DECODE-ROWS --verbose binlog.000001 | mysql -u root -p
Why this works
Using DECODE-ROWS outputs only valid row events suitable for replay.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1730 ER_ONLY_FD_AND_RBR_EVENTS_ALLOWED_IN_BINLOG_STATEMENT
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev