Error while node trying to rejoin cluster

Follow

Mrlowery1984

• December 31, 2016 04:11

30 Dec 2016 23:04:50
last 100 lines of mysql error log:
InnoDB: is in the future! Current system log sequence number 1115738224652.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2016-12-31 04:02:37 7f3b7a4b2880 InnoDB: Error: page 27325 log sequence number 1166633629391

1

• Official comment

  

  Krzysztof Ksiazek

  • December 31, 2016 09:13

  Hi,

  I'm not entirely sure what your question is about. Error log snippet tells all you need - for some reason InnoDB is in incorrect state and log sequence number doesn't match what's inside of tablespaces. What you can try is to remove whole content of MySQL data directory and see if SST will be performed correctly. If the error shows after the SST, it means that donor node has InnoDB in corrupted state. In such case you can still try to use different donor to get the SST from: http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-sst-donor

  Thanks,
  Krzysztof

  Comment actions Permalink

Please sign in to leave a comment.