Percona XtraDB Cluster won't start

Bug #1732752 reported by Roman Kalab on 2017-11-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
New
Undecided
Unassigned

Bug Description

Hello,
i have the problem with Percona XtraDB Cluster. Sometimes after clean shutdown, sometimes after crash the (random) node(s) of the cluster are not able to start.

Commandline used: "service mysql start" or "/usr/bin/mysqld_safe -v"
Percona version:
mysqld Ver 5.7.19-17-57 for debian-linux-gnu on x86_64 (Percona XtraDB Cluster (GPL), Release rel17, Revision 35cdc81, WSREP version 29.22, wsrep_29.22)

Output of the "mysqld_safe -v":
# /usr/bin/mysqld_safe -v
2017-11-16T17:37:18.048298Z mysqld_safe Logging to '/var/log/mysql/error.log'.
Logging to '/var/log/mysql/error.log'.
2017-11-16T17:37:18.089616Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-11-16T17:37:18.113637Z mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.mzgffn' --pid-file='/var/lib/mysql/puma-recover.pid'

Then the process dies, with exit code 0. The error log is not even created, so no info there. WSREP recovery log attached. Syslog contains no data.

The situation can be solved by removing whole content of "/var/lib/mysql/". Then the server does full SST and starts normally.
Please let me know if you need any other information.

Roman Kalab (poutnik) wrote :
affects: percona-toolkit → percona-xtradb-cluster
Roman Kalab (poutnik) wrote :
Roman Kalab (poutnik) wrote :
Roman Kalab (poutnik) wrote :
Krunal Bauskar (krunal-bauskar) wrote :

From the recovery log

mysqld: Table 'mysql.plugin' doesn't exist
2017-11-16T17:37:19.221076Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

It sounds like there is something wrong with your data-directory.

Are you using 5.6 data-directory with 5.7 binaries (w/o running mysql-upgrade).

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-2019

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers