Slave hung with state "Checking table" after restore
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
The slave is hung with the state "Checking table" after restoring from backup.
mysql> show slave status\G
*******
Replicate
Replicate_
Master_
Replicate_
Slave_
Last_
Last_
1 row in set (0.00 sec)
Changed in percona-server: | |
status: | Incomplete → New |
The backup is created using innobackupex, pigz, and tar
/usr/bin/env innobackupex --slave-info --stream=tar ./ | pigz - > $file
The restored database is created using tar and innobackupex
tar xipf
innobackupex --apply-log --use-memory=4G
xtrabackup version 2.2.12 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 8726828)
Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f
CentOS release 6.6 (Final)
Linux twilight-salad 3.18.19- 61.el6. x86_64 #1 SMP Mon Jul 27 11:04:37 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux