Failing assertion: dblwr_recover || memcmp(src + 16 + 4, src + (header.m_original_size + 38U) - 8 + 4, 4) == 0
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.4 |
Confirmed
|
High
|
Unassigned |
Bug Description
The result of PTB run:
with PXB optimized build:
161114 21:16:21 version_check Connecting to MySQL server with DSN 'dbi:mysql:
161114 21:16:21 version_check Connected to MySQL server
161114 21:16:21 version_check Executing a version check against the server...
161114 21:16:21 version_check Done.
161114 21:16:21 Connecting to MySQL server host: localhost, user: jenkins, password: not set, port: 10000, socket: /tmp/mysql.sock
Using server version 5.7.15-9-log
xtrabackup version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mnt/workspace/
xtrabackup: open files limit requested 0, set to 1048576
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: using O_DIRECT
InnoDB: Number of pools: 1
161114 21:16:23 >> log scanned up to (595839183)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 47 for sbtest/sbtest3, old maximum was 0
161114 21:16:24 [01] Copying ./ibdata1 to /mnt/workspace/
161114 21:16:24 [01] ...done
161114 21:16:24 [01] Copying ./sbtest/
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
161114 21:16:24 >> log scanned up to (596098807)
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Database page corruption detected at page 35, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./sbtest/
[01] xtrabackup: Error: xtrabackup_
[01] xtrabackup: Error: failed to copy datafile.
With PXB debug build:
161114 21:15:32 [01] Copying ./sbtest/
2016-11-14 21:15:32 0x7f38adc7b700 InnoDB: Assertion failure in thread 139881410443008 in file os0file.cc line 8594
InnoDB: Failing assertion: dblwr_recover || memcmp(src + 16 + 4, src + (header.
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.
21:15:32 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...
stack_bottom = 0 thread_stack 0x10000
xtrabackup(
xtrabackup(
/lib64/
/lib64/
/lib64/
xtrabackup[
xtrabackup(
xtrabackup(
xtrabackup(
xtrabackup[
xtrabackup[
/lib64/
/lib64/
Please report a bug at https:/
tags: | added: ptb |
tags: | added: qa |
my.cnf:
[client] /tmp/mysql. sock /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/Percona- Server- 5.7.15- 9-Linux. x86_64. ssl101 /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/mnt/ var/ps_ 5.7.15_ sysbench/ test-0/ mysql.1/ data /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/mnt/ var/ps_ 5.7.15_ sysbench/ test-0/ mysql.1/ tmp /tmp/mysql. sock /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/mnt/ var/ps_ 5.7.15_ sysbench/ test-0/ mysql.1/ mysql.pid page_size= 64k load=keyring_ file.so file_data= /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/mnt/ var/ps_ 5.7.15_ sysbench/ test-0/ mysql.1/ data/keyring log-file= /mnt/workspace/ PTB-run- percona- server- 5.7-pxb- 2.4.4/BTYPE/ release/ Host/centos7- 64/mnt/ var/ps_ 5.7.15_ sysbench/ test-0/ mysql.1/ query.log
port=10000
socket=
user=root
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
innodb_
early_plugin_
keyring_
console
user=jenkins
server-id=1
general-
binlog-format=row buffer_ pool_size= 1G file_format= antelope file_per_ table=1 flush_log_ at_trx_ commit= 1 flush_method= O_DIRECT log_file_ size=1G
innodb_
innodb_checksums=ON
innodb_
innodb_
innodb_
innodb_
innodb_
log-bin=
log-bin-index=