1627
MariaDBERRORCommonReplicationHIGH confidence
Replica cannot create conversion for column
Production Risk
High — replication halts until schema is reconciled.
What this means
The replica was unable to create a type-conversion table for a column because the column types are fundamentally incompatible.
Why it happens
- 1Column types differ in ways that are not convertible (e.g., string to integer).
- 2slave_type_conversions is empty or does not include the required conversion class.
How to reproduce
trigger — this will error
trigger — this will error
-- Master has VARCHAR column, replica has INT; row-based event cannot be applied
expected output
ERROR 1627: Slave cannot convert from type 'varchar(255)' to type 'int(11)' for column 1 in table 'db.t'
Fix
Align column types on master and replica
Align column types on master and replica
ALTER TABLE t MODIFY col VARCHAR(255);
Why this works
Matching schemas eliminates the need for conversion.
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1627 ER_SLAVE_CANT_CREATE_CONVERSION
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev