gvwstate.dat not found during pxc startup

jdanilson · December 30, 2020, 4:23pm

datadir=/xyz <-- note no trailing /

show global datadir shows /xyz/ <-- note trailing /

error log says /xyz//gvwstate.dat is missing. which is correct but /xyz/gvwstate.dat does exist.

so add explicity wsrep_data_home=/xyz <-- no trailing /

and it sitll complains that /xyz/gvwstate.dat does not exists but it does.

two possible errors?

5.6.28-76.1-56-log Percona XtraDB Cluster (GPL), Rleease rel76.1 REvision f9b078d, WSREP version 25.14, wsrep_25.14
rhel 7

jrivera · December 30, 2020, 4:33pm

It perfectly works fine for me, and I don’t have to add wsrep_data_home=


[root&#64;pxc1 ~]# mysql -e 'select &#64;&#64;global.datadir' 
+------------------+
| &#64;&#64;global.datadir |
+------------------+
| /var/lib/mysql/ |
+------------------+
[root&#64;pxc1 ~]# grep datadir /etc/my.cnf
datadir=/var/lib/mysql
[root&#64;pxc1 ~]# ls -ll /var/lib/mysql/gvws*
-rw-rw---- 1 mysql mysql 170 May 31 09:29 /var/lib/mysql/gvwstate.dat
[root&#64;pxc1 ~]# rpm -qa|grep -i Percona-XtraDB-Cluster-server
Percona-XtraDB-Cluster-server-56-5.6.29-25.15.1.el6.x86_64