MySQL Forums
Forum List  »  Replication

Table definition on master and slave does not match,
Posted by: camilo rios
Date: April 07, 2017 10:11AM

I am getting this error:

Error: Table definition on master and slave does not match: Column 23 type mismatch - received type 18, XXXX has type 12.

This happened some time after a bin log format changed in the master DB from STATEMENT to MIXED. I changed the format in the slave to be MIXED as well, got a backup from another slave, changed the master bin log position, started the server and it runs fine for some time but the error appears again in a different table.

The MASTER is using INNODB and the slave uses MyISAM.

The structure of the tables is the same in both as per show create table results. The columns it reports problems with are all datetime type but they are defined the same in both servers : datetime DEFAULT NULL

I'd appreciate any help/suggestions on this issue.


Options: ReplyQuote

Written By
Table definition on master and slave does not match,
April 07, 2017 10:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.