MySQL Replication breaks 'Unknown column '%-.192s' in '%-.192s'

MySQL & MariaDB Other MySQL® Questions
1

Hello,

From today i am facing strange error on replication slave. Don’t how to fix it please help.

mysql> show slave status\G
Last_Error: Query caused different errors on master and slave. Error on master: ‘Unknown column ‘%-.192s’ in ‘%-.192s’’ (1054), Error on slave: ‘no error’ (0).Default database: ‘DB NAME’. Query: ‘UPDATE TABLE QUERY’

I verified table schema and structure on master/slave which is same on both.
Please help me out to get rid of this.

Error 1054 stats following:
Error Code: 1054 means SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column ‘%s’ in ‘%s’

Not sure what does that means 'Unknown column ‘%-.192s’ in ‘%-.192s’

Thank you.
Irfan

2

I have not seen that error. It looks like a) a bug in mysqld (did you search for it?) and b) your tables have different structures on the master and slave.

3

put show create table output