Failed to prepare full backup (size == space->size_in_header)
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.4 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Steps are:
mysql> show create table sbtest1\G
*******
Table: sbtest1
Create Table: CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=
1 row in set (0,00 sec)
Running with:
sysbench --test=
and:
sysbench --test=
Take backup:
./xtrabackup --defaults-
Prepare:
./xtrabackup --defaults-
.
.
.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: Waiting for purge to start
2016-01-19 06:19:15 0x7f01897f4700 InnoDB: Assertion failure in thread 139644578514688 in file fsp0fsp.cc line 2986
InnoDB: Failing assertion: size == space->
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
11:19:15 UTC - xtrabackup got signal 6 ;
This could be because you hit a bug or data is corrupted.
This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Thread pointer: 0x0
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...
InnoDB: 5.7.10 started; log sequence number 11766603797
xtrabackup: starting shutdown with innodb_
InnoDB: not started
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
stack_bottom = 0 thread_stack 0x10000
./xtrabackup(
./xtrabackup(
/lib64/
/lib64/
/lib64/
./xtrabackup[
./xtrabackup(
./xtrabackup(
./xtrabackup[
./xtrabackup[
./xtrabackup[
./xtrabackup[
./xtrabackup[
./xtrabackup(
./xtrabackup[
./xtrabackup[
./xtrabackup(
./xtrabackup(
./xtrabackup[
./xtrabackup(
/lib64/
/lib64/
This assertion does not apply to incremental backups.
I am able to take full backup + 1 incremental backup and prepare successfully.