MySQL Bugs: #64429: Failing assertion: page_is_comp(get_block->frame) == page_is

Bug #64429	Failing assertion: page_is_comp(get_block->frame) == page_is_comp(page)
Submitted:	23 Feb 2012 5:14	Modified:	7 Nov 2015 8:58
Reporter:	zhai weixiang (OCA)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: InnoDB Plugin storage engine	Severity:	S1 (Critical)
Version:	5.1.48	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	innodb_plugin

Description:
Recently we got a assertion failure as follows:

120221  3:53:51  InnoDB: Assertion failure in thread 1299265856 in file btr/btr0cur.c line 245
InnoDB: Failing assertion: page_is_comp(get_block->frame) == page_is_comp(page)

After this the server crash we tried to restart mysqld and always got another failure even with innodb_force_recovery(1-5):

120221  3:54:15  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 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 120221  3:54:52  InnoDB: Assertion failure in thread 1138456896 in file log/log0recv.c line 1216
InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)

while innodb_force_recovery was set to 6 ,there's a  different assert failure  happened 

120221 22:39:40  InnoDB: error: space object of table'lg_core_0007/lg_order_0472',
InnoDB: space id 2017 did not exist in memory. Retrying an open.
120221 22:39:40  InnoDB: Assertion failure in thread 1331177792 in file fil/fil0fil.c line 2982
InnoDB: Failing assertion: flags != DICT_TF_COMPACT

How to repeat:
can't repeat

Please, send your my.cnf file content and entire error log (compressed). Had you moved ib* files anywhere while server was running?

I'd suggest to upgrade to 6.1.61 in any case. See bug #54009 etc

error log

Attachment: alert.log (text/x-log), 50.96 KiB.

my.cnf

Attachment: my.cnf (application/octet-stream, text), 2.58 KiB.

I think this is a  different case.

Upgrade to 5.1.61 is still needed. We do not fix bugs that are not repeatable with current versions.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Same assertion was noted in 5.5.x also, see https://bugs.launchpad.net/percona-server/+bug/939248.

notice the higher versions of innodb-force-recovery may lead to further problems and permanent corruption on older versions.

see change notes for https://bugs.mysql.com/bug.php?id=71420

about original crash,  it was some corruption, but we cannot confirm a cause or bug due to insufficient information.