grastate.dat zeroed on misconfiguration in my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Unassigned | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Confirmed
|
Medium
|
Unassigned |
Bug Description
Here is the flow:
[root@node3 mysql]# cat /var/lib/
# GALERA saved state
version: 2.1
uuid: 8d211006-
seqno: -1
cert_index:
[root@node3 mysql]# service mysql stop
Shutting down MySQL (Percona XtraDB Cluster)........ SUCCESS!
[root@node3 mysql]# cat /var/lib/
# GALERA saved state
version: 2.1
uuid: 8d211006-
seqno: 334193
cert_index:
Now I introduce some misconfiguration into my.cnf:
[mysqld]
...
fooey
...
Now try to restart mysql:
[root@node3 mysql]# mysqld_safe &
[1] 14755
[root@node3 mysql]# 130131 13:14:56 mysqld_safe Logging to '/var/lib/
130131 13:14:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130131 13:14:56 mysqld_safe WSREP: Running position recovery with --log_error=
nohup: ignoring input and appending output to `nohup.out'
130131 13:15:01 mysqld_safe WSREP: Failed to recover position: 130131 13:14:56 [Note] Plugin 'FEDERATED' is disabled. 130131 13:14:56 InnoDB: The InnoDB memory heap is disabled 130131 13:14:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130131 13:14:56 InnoDB: Compressed tables use zlib 1.2.3 130131 13:14:56 InnoDB: Using Linux native AIO 130131 13:14:56 InnoDB: Initializing buffer pool, size = 128.0M 130131 13:14:56 InnoDB: Completed initialization of buffer pool 130131 13:14:56 InnoDB: highest supported file format is Barracuda. 130131 13:14:56 InnoDB: Waiting for the background threads to start 130131 13:14:57 Percona XtraDB (http://
[root@node3 mysql]# cat /var/lib/
# GALERA saved state
version: 2.1
uuid: 00000000-
seqno: -1
cert_index:
According to Codership, this should not happen:
"[1/31/13 1:21:22 PM] Alexey Yurchenko / Codership: I'm seeing the same logs here, the same failure to recover, but grastate.dat stays intact."
Therefore this must be something specific to PXC.
[root@node3 mysql]# rpm -qa | grep -i percona
Percona-
Percona-
percona-
Percona-
Percona-
| wsrep_provider_
[root@node3 mysql]# uname -a
Linux node3 2.6.32-
[root@node3 mysql]# cat /etc/issue
CentOS release 6.3 (Final)
Kernel \r on an \m
tags: | added: grastate |
tags: | added: i61146 |
Changed in percona-xtradb-cluster: | |
importance: | Undecided → Medium |
http:// sprunge. us/dPFQ