Database page corruption detected at page 1 with encryption enabled table full backup
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
I have a sample table with encryption enabled:
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=
And an infinite loop:
[root@ps-pxb-5 ~]# cat alter_rotate_
import mysql.connector
cnx = mysql.connector
cursor = cnx.cursor()
alter_stmt = "ALTER INSTANCE ROTATE INNODB MASTER KEY"
while(True):
print "Master key rotated"
cursor.
cursor.close()
cnx.close()
Steps:
1. Run python script (altering master key) -> leave running
2. alter table sbtest1 compression='zlib';
3. /usr/local/
Result:
160516 12:37:31 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/
Using server version 5.7.11-4
/usr/local/
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
InnoDB: Number of pools: 1
160516 12:37:31 >> log scanned up to (3218914516)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 35 for mysql/plugin, old maximum was 0
160516 12:37:32 [01] Copying ./ibdata1 to /home/backup_
160516 12:37:33 >> log scanned up to (3218919028)
160516 12:37:34 >> log scanned up to (3218922543)
160516 12:37:34 [01] ...done
160516 12:37:50 [01] Copying ./db2/sbtest1.ibd to /home/backup_
160516 12:37:51 >> log scanned up to (3218987189)
160516 12:37:52 >> log scanned up to (3218990704)
160516 12:37:53 >> log scanned up to (3218994310)
160516 12:37:54 >> log scanned up to (3218997825)
160516 12:37:55 >> log scanned up to (3219001431)
160516 12:37:56 >> log scanned up to (3219004894)
160516 12:37:57 >> log scanned up to (3219008607)
160516 12:37:58 >> log scanned up to (3219012304)
160516 12:37:59 >> log scanned up to (3219016290)
160516 12:38:00 >> log scanned up to (3219019896)
160516 12:38:01 >> log scanned up to (3219023775)
160516 12:38:02 >> log scanned up to (3219027488)
160516 12:38:03 [01] ...done
160516 12:38:03 [01] Copying ./dbtest/
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
160516 12:38:03 >> log scanned up to (3219030896)
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./dbtest/
[01] xtrabackup: Error: xtrabackup_
[01] xtrabackup: Error: failed to copy datafile.
Same thing if you try to backup while doing "alter table sbtest1 compression="
160523 10:12:41 [01] ...done #sql-1665_ 3.ibd to /home/backup_ dir/full/ dbtest/ #sql-1665_ 3.ibd #sql-1665_ 3.ibd seems to be corrupted. copy_datafile( ) failed.
160523 10:12:41 [01] Copying ./dbtest/
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
160523 10:12:41 >> log scanned up to (35313522605)
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./dbtest/
[01] xtrabackup: Error: xtrabackup_
[01] xtrabackup: Error: failed to copy datafile.