Last Updated: 2014-04-15
Condition or Error
Replication fails to extract the data from the MySQL binary log, and the replicator will not go online again.
The format of
types between MySQL 4.x and MySQL 5.0 changed, however, the
datatype was not automatically modified during an upgrade
process. This means that tables that were created in MySQL 4.x
and now exist within MySQL 5.0 using the
DECIMAL generate an
incompatible entry within the MySQL binary log. The upgrade
and mysql_upgrade commands do not update
the tables correctly. More detailed information on the change
and issue can be located in
ALTER TABLE faulty MODIFY COLUMN faulty_column DECIMAL;
This should be performed on the Primary within your topology. To correct the error, you must use tpm reset-thl to regenerate the THL.