Update from 8.0.19-10.1 to 8.0.20-11.3 works, but after update status and variables are not shown

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi,

I have a very strange problem: After update from 8.0.19-10.1 to 8.0.20-11.3 the following queries show nothing:

mysql> SHOW STATUS;
Empty set (0.11 sec)
mysql> SHOW VARIABLES;
Empty set (0.01 sec)

But, the cluster is in sync, all cluster node are joined. The same configuration works, when I do a new installation with the newest (8.0.20-11.3) version of cluster software. I’m running on CentOS 8.1. The procedure is reproduce able, I have Snapshots of the VM’s.

1 Like
2

Thank you for this report. I reproduced the same problem and reported bug here: [PS-7567] Minor upgrade breaks P_S tables when enforce_storage_engine is set - Percona JIRA
Can you confirm you had enforce_storage_engine variable set in your configuration file?

1 Like
3

Hi,
Yes, I have setup the enforce_storage_engine = InnoDB in the nodes of the cluster.
Thank you

1 Like