Boostrapping a Node in NON-PRIMARY Crashes
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Galera | Status tracked in 3.x | |||||
2.x |
Fix Released
|
High
|
Alex Yurchenko | |||
3.x |
Fix Released
|
High
|
Alex Yurchenko | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Coming from 2 nodes, PXC 5.6.15, kill -9 the second node, wait for the first node to be in Initialized state then set pc.boostrap=1. You get the crash.
2014-03-01 01:05:22 9793 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
terminate called after throwing an instance of 'gu::NotSet'
06:05:32 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https:/
key_buffer_
read_buffer_
max_used_
max_threads=153
thread_count=4
connection_count=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x3250d70
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fceb4558d38 thread_stack 0x40000
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fce6c005200): is an invalid pointer
Connection ID (thread ID): 4
Status: NOT_KILLED
Related branches
- David Bennett: Pending requested
- Diff: 0 lines
[root@pxc01 pxc-5.6.15]# rpm -qa|grep -i percona XtraDB- Cluster- client- 56-5.6. 15-25.4. 731.rhel6. x86_64 xtrabackup- debuginfo- 2.1.7-721. rhel6.x86_ 64 XtraDB- Cluster- galera- 3-debuginfo- 3.3-1.207. rhel6.x86_ 64 xtrabackup- 2.1.7-721. rhel6.x86_ 64 XtraDB- Cluster- devel-56- 5.6.15- 25.4.731. rhel6.x86_ 64 XtraDB- Cluster- galera- 3-3.3-1. 207.rhel6. x86_64 XtraDB- Cluster- server- 56-5.6. 15-25.4. 731.rhel6. x86_64 XtraDB- Cluster- 56-debuginfo- 5.6.15- 25.4.731. rhel6.x86_ 64 XtraDB- Cluster- 56-5.6. 15-25.4. 731.rhel6. x86_64 XtraDB- Cluster- shared- 56-5.6. 15-25.4. 731.rhel6. x86_64 Server- shared- compat- 5.5.35- rel33.0. 611.rhel6. x86_64
Percona-
percona-
Percona-
percona-
Percona-
Percona-
Percona-
Percona-
Percona-
Percona-
Percona-
[root@pxc01 pxc-5.6.15]# cat /etc/my.cnf mysql/mysqld. sock
[client]
port = 3306
socket = /var/lib/
user = root
password = root
[mysqld] mysql/mysqld. sock mysql/mysqld. pid locking buffer_ size = 8M sort_buffer_ size = 64M min_res_ unit= 1536
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/
pid-file = /var/lib/
skip-external-
key_buffer_size = 32M
max_allowed_packet = 128M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_
myisam_
thread_cache_size = 8
query_cache_size = 0
query_cache_type = 0
query_cache_
skip-slave-start
expire_logs_days = 15
slow-query-log = 1
long_query_time = 2
#log-bin=mysql-bin
server-id = 10
log-slave-updates = 1
binlog_format = ROW
innodb_ log_buffer_ size = 8M buffer_ pool_size = 512M log_file_ size = 256M file-per- table locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2
innodb_
innodb_
innodb-
innodb_
innodb_
log-error = /var/lib/ mysql/mysqld. log mysql/mysqld- slow.log
slow_query_log_file = /var/lib/
skip-name-resolve
wsrep_provider = /usr/lib64/ libgalera_ smm.so address = gcomm://
wsrep_slave_threads = 2
wsrep_cluster_name = pxc
wsrep_sst_method = xtrabackup
wsrep_node_name = pxc01
wsrep_node_address = 192.168.56.42
wsrep_cluster_
[mysqldump]
quick
max_allowed_packet = 128M
[mysql]
no-auto-rehash