Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

  1. Bug #1706992
  2. Comment #4

Comment 4 for bug 1706992

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

There are couple of things to consider here:

a. I see following error message in your comment.

2017-07-27T14:15:28.000905Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

Which is probably coming from the said setting in my.cnf. I assume some of these setting in my.cnf are manually added at your end and not the default setting shipped by PXC install.
[mysqld]
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

b. If this is fresh install wondering why is recovery kicking off.