Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

    Comment


    • #3
      put show create table output

      Comment

      Working...
      X