Not the answer you need?
Register and ask your own question!

gvwstate.dat not found during pxc startup

jdanilsonjdanilson EntrantInactive User Role Novice
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

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.