impossible restore from backup / xtrabackup crash
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Unassigned |
Bug Description
[root@murr tmp]# cat xtrabackup_
# This MySQL options file was generated by innobackup.
# The MySQL server
[mysqld]
datadir=/tmp
innodb_
innodb_
innodb_
innodb_
innodb_
xtrabackup --prepare
xtrabackup Ver 0.9 Rev 83 for 5.0.84 unknown-linux-gnu (x86_64)
xtrabackup: cd to ./xtrabackup_
xtrabackup: This target seems to be not prepared yet.
090923 21:58:21 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Warning: cannot open ./xtrabackup_
xtrabackup: 'ib_logfile0' seems to be 'xtrabackup_
xtrabackup: xtrabackup_logfile detected: size=10682368, start_lsn=(145 3582940994)
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Log scan progressed past the checkpoint lsn 145 3582940994
090923 21:58:21 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: ############### CORRUPT LOG RECORD FOUND
InnoDB: Log record type 50, space id 509, page number 928702
InnoDB: Log parsing proceeded successfully up to 145 3582942359
InnoDB: Previous log record type 14, is multi 1
InnoDB: Recv offset 1368, prev 1362
InnoDB: Hex dump of corrupt log starting 100 bytes before the start
InnoDB: of the previous log rec,
InnoDB: and ending 100 bytes after the start of the corrupt rec:
len 206; hex 0465eda681cece8
InnoDB: WARNING: the log file may have been corrupt and it
InnoDB: is possible that the log scan did not proceed
InnoDB: far enough in recovery! Please run CHECK TABLE
InnoDB: on your InnoDB tables to check that they are ok!
InnoDB: If mysqld crashes after this recovery, look at
InnoDB: http://
InnoDB: about forcing recovery.
InnoDB: Doing recovery: scanned up to log sequence number 145 3588183552 (55 %)
InnoDB: Doing recovery: scanned up to log sequence number 145 3591384476 (88 %)
090923 21:58:21 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 1 2 3 090923 21:58:21InnoDB: Assertion failure in thread 1142401344 in file log0recv.c line 886
InnoDB: Failing assertion: !page || (ibool)
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.
Changed in percona-xtrabackup: | |
importance: | Undecided → High |
milestone: | none → release-1.2 |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
Changed in percona-xtrabackup: | |
milestone: | 1.2 → 1.3.1 |
the problem should be fixed in 1.4