Table definition on master and slave does not match,
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.
Thanks!
Subject
Views
Written By
Posted
Table definition on master and slave does not match,
1602
April 07, 2017 10:11AM
668
April 07, 2017 12:00PM
752
April 07, 2017 02:06PM
723
April 07, 2017 02:56PM
845
April 07, 2017 04:50PM
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.