The replication filter includes a wildcard pattern that is not in the required 'db_pattern.table_pattern' format.
MySQL error 3067 (ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN) signals that a replication filter string is malformed. Ensure every value in CHANGE REPLICATION FILTER or the replicate-wild-* options follows 'database_pattern.table_pattern', then restart or reconfigure replication to clear the error.
ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN
Error 3067 appears when MySQL parses replication filters and finds at least one value that does not match the mandatory "database_pattern.table_pattern" syntax. The server rejects the configuration and stops processing the filter list.
The condition was introduced in MySQL 5.7.5 to validate patterns passed through CHANGE REPLICATION FILTER statements and legacy --replicate-wild-do-table or --replicate-wild-ignore-table options. Fixing the pattern or removing the entry clears the error.
The error surfaces immediately after issuing CHANGE REPLICATION FILTER, starting the replica server, or reloading configuration if the supplied filter array contains an invalid wildcard. Any string missing a dot, starting with a dot, or containing illegal characters fails validation.
It can also be triggered by automation scripts that build the filter list dynamically, typo mistakes during interactive sessions, or copy-paste errors from documentation that omitted the table part.
Locate the offending pattern, rewrite it in the proper form, and re-apply the filter. If multiple entries exist, review them all before restarting replication to avoid repeat failures.
After correction, verify with SHOW REPLICA STATUS or by inspecting performance_schema.replication_applier_filters to confirm the server accepted the list.
During initial replica setup, engineers often specify only a database name such as "sales.*". Because the filter validator expects a database pattern followed by a dot and a table pattern, the correct value must be "sales.*" actually matches the rule; however a single component like "sales" without the dot will fail.
When migrating from older versions, configuration files may contain obsolete filter syntax. Updating these entries or replacing them with CHANGE REPLICATION FILTER commands prevents error 3067 on upgrade.
Store replication configuration in version control and validate it in staging before production deployment. Use automated tests or a simple shell script that runs mysqld --validate-config to catch pattern issues early.
Within Galaxy, developers can store vetted CHANGE REPLICATION FILTER commands in an endorsed query collection and share them with the team, ensuring only validated patterns reach production replicas.
Error 1236 (ER_MASTER_FATAL_ERROR_READING_BINLOG): Triggered when replication breaks due to invalid binlog position, often following configuration errors.
Error 1872 (ER_RPL_REPLICA_INIT_INFO): Appears when replication fails to initialize, sometimes caused by incorrect filter entries combined with misconfigured channel settings.
Providing only the database portion (for example "sales") without ".table_pattern".
Using patterns such as ".customers" or "sales." causes validation failure.
Including unsupported symbols like question marks or brackets inside the pattern.
Mistyping the database or table name, resulting in double dots or consecutive wildcards.
Raised when the replica SQL thread encounters an invalid replication slot.
Occurs when auto-positioning is enabled but the GTID set is malformed.
Generic failure when applying replication filter changes, often due to syntax errors.
No. Use a wildcard such as "sales.*" to match every table. Omitting the dot or the asterisk violates the required format.
Yes. The replica refuses to apply filters with invalid patterns and replication threads will not start until the issue is fixed.
No. It affects all replication modes because the validation happens before the replication thread type is evaluated.
Galaxy lets teams store and review replication commands in shared collections, reducing copy-paste mistakes and ensuring only tested patterns reach production.
.avif)
.avif){kind=logo}
