InnoDB: Assertion failure in thread <nr> in file log0recv.c line 1105 InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Alexey Kopytov | ||
2.0 |
Fix Released
|
High
|
Alexey Kopytov | ||
2.1 |
Fix Released
|
High
|
Alexey Kopytov |
Bug Description
May be duplicate of:
https:/
https:/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
130507 04:57:16 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-
pb/test-
xtrabackup_55 version 2.1.0beta1 for Percona Server 5.5.16 Linux (x86_64) (revision id: undefined)
incremental backup from 889443043 is enabled.
xtrabackup: cd to /mnt/var/
xtrabackup: This target seems to be already prepared.
xtrabackup: xtrabackup_logfile detected: size=141885440, start_lsn=
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
130507 4:57:17 InnoDB: Warning: allocated tablespace 108, old maximum was 9
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
zip_size = 8192
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
xtrabackup: Renaming ./rqg1/
Applying /mnt/var/
xtrabackup: page size for /mnt/var/
Applying /mnt/var/
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)
130507 4:57:17 InnoDB: The InnoDB memory heap is disabled
130507 4:57:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130507 4:57:17 InnoDB: Compressed tables use zlib 1.2.3
130507 4:57:17 InnoDB: Initializing buffer pool, size = 100.0M
130507 4:57:17 InnoDB: Completed initialization of buffer pool
130507 4:57:17 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 889443043
130507 4:57:17 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Doing recovery: scanned up to log sequence number 894685696 (4 %)
InnoDB: Doing recovery: scanned up to log sequence number 899928576 (8 %)
InnoDB: Doing recovery: scanned up to log sequence number 905171456 (12 %)
InnoDB: Doing recovery: scanned up to log sequence number 910414336 (16 %)
InnoDB: Doing recovery: scanned up to log sequence number 915657216 (20 %)
InnoDB: Doing recovery: scanned up to log sequence number 920900096 (24 %)
InnoDB: Doing recovery: scanned up to log sequence number 926142976 (29 %)
InnoDB: Doing recovery: scanned up to log sequence number 931385856 (33 %)
InnoDB: Doing recovery: scanned up to log sequence number 936628736 (37 %)
InnoDB: Doing recovery: scanned up to log sequence number 941871616 (41 %)
InnoDB: Doing recovery: scanned up to log sequence number 947114496 (45 %)
InnoDB: Doing recovery: scanned up to log sequence number 952357376 (49 %)
130507 4:57:17 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 (cannot find space: 117) (cannot find space: 164) (cannot find space: 176) (cannot find space: 105)35 (cannot find space: 66) (cannot find space: 69) (cannot find space: 35)36 (cannot find space: 167) (cannot find space: 168)37 (cannot find space: 134)38 39 (cannot find space: 50) (cannot find space: 44)40 41 (cannot find space: 138) (cannot find space: 141) (cannot find space: 144) (cannot find space: 148) (cannot find space: 161)42 (cannot find space: 31)43 (cannot find space: 163)44 (cannot find space: 169)45 (cannot find space: 128)46 47 (cannot find space: 156)48 (cannot find space: 136)49 (cannot find space: 44) (cannot find space: 104) (cannot find space: 61) (cannot find space: 89) (cannot find space: 105) (cannot find space: 109) (cannot find space: 121) (cannot find space: 125) (cannot find space: 78) (cannot find space: 110) (cannot find space: 43) (cannot find space: 91) (cannot find space: 34) (cannot find space: 35) (cannot find space: 37) (cannot find space: 49) (cannot find space: 50) (cannot find space: 51) (cannot find space: 66) (cannot find space: 69) (cannot find space: 99) (cannot find space: 100) (cannot find space: 101) (cannot find space: 103) (cannot find space: 112) (cannot find space: 117) (cannot find space: 118) (cannot find space: 57)50 (cannot find space: 36)51 (cannot find space: 42) (cannot find space: 58) (cannot find space: 45) (cannot find space: 92) (cannot find space: 62) (cannot find space: 31) (cannot find space: 32)52 (cannot find space: 72)53 (cannot find space: 82)54 (cannot find space: 29)55 56 57 (cannot find space: 56) (cannot find space: 59)58 (cannot find space: 164)59 60 61 62 (cannot find space: 101)63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Doing recovery: scanned up to log sequence number 957600256 (54 %)
InnoDB: Doing recovery: scanned up to log sequence number 962843136 (58 %)
InnoDB: Doing recovery: scanned up to log sequence number 968086016 (62 %)
InnoDB: Doing recovery: scanned up to log sequence number 973328896 (66 %)
InnoDB: Doing recovery: scanned up to log sequence number 978571776 (70 %)
InnoDB: Doing recovery: scanned up to log sequence number 983814656 (74 %)
InnoDB: Doing recovery: scanned up to log sequence number 989057536 (78 %)
InnoDB: Doing recovery: scanned up to log sequence number 994300416 (83 %)
130507 4:57:19 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 (cannot find space: 369) (cannot find space: 343) (cannot find space: 374) (cannot find space: 346) (cannot find space: 347)130507 4:57:19 InnoDB: Assertion failure in thread 140419081942784 in file log0recv.c line 1105
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.
innobackupex: Error:
innobackupex: ibbackup failed at /mnt/bin/
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 366 lines (+137/-44)2 files modifiedpatches/innodb56.patch (+91/-22)
src/xtrabackup.cc (+46/-22)
- Laurynas Biveinis (community): Approve
-
Diff: 365 lines (+137/-44)2 files modifiedpatches/innodb56.patch (+91/-22)
src/xtrabackup.cc (+46/-22)
tags: | added: i31441 |
summary: |
- InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == - dict_table_is_comp(index->table) + InnoDB: Assertion failure in thread 140419081942784 in file log0recv.c + line 1105InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) + == dict_table_is_comp(index->table) |
summary: |
InnoDB: Assertion failure in thread 140419081942784 in file log0recv.c - line 1105InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) - == dict_table_is_comp(index->table) + line 1105 InnoDB: Failing assertion: !page || + (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table) |
summary: |
- InnoDB: Assertion failure in thread 140419081942784 in file log0recv.c - line 1105 InnoDB: Failing assertion: !page || - (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table) + InnoDB: Assertion failure in thread <nr> in file log0recv.c line 1105 + InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == + dict_table_is_comp(index->table) |
tags: | added: i31562 |
tags: | added: ptb |
my.cnf: /mnt/var/ cpb/test- 9/mysql. 1/mysql. sock /mnt/bin/ ps-5.5 /mnt/var/ cpb/test- 9/mysql. 1/data /mnt/var/ cpb/test- 9/mysql. 1/tmp /mnt/var/ cpb/test- 9/mysql. 1/mysql. sock /mnt/var/ cpb/test- 9/mysql. 1/mysql. pid buffer_ pool_size= 1G file_format= barracuda file_per_ table=1 log_file_ size=512M track_changed_ pages=FALSE
[client]
port=10000
socket=
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
console
user=root
server-id=1
innodb_
innodb_
innodb_
innodb_
innodb_