Percona XtraDB Storage Engine for MySQL

main.innodb_bug36172 mysq test fails with innodb_stat.patch applied

Reported by Evgeniy on 2009-06-23
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona-XtraDB
Fix Released
High
Unassigned

Bug Description

CURRENT_TEST: main.innodb_bug36172
InnoDB: Records in wrong order on page 7 index "idx3" of table "test"."table0"
InnoDB: previous record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: SQL NULL;
 1: len 4; hex daecc14a; asc J;;
 2: len 4; hex 00000000; asc ;;
 3: len 2; hex 6aa1; asc j ;;
 4: len 6; hex 000000000202; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: len 8; hex 800012a7a373f3f9; asc s ;;
 1: len 4; hex 59c97f4f; asc Y O;;
 2: len 4; hex 00000000; asc ;;
 3: len 2; hex 84c6; asc ;;
 4: len 6; hex 000000000203; asc ;;

InnoDB: Apparent corruption in page 7 in index "idx3" of table "test"."table0"
090623 18:03:36 InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 0000000000000007ffffffffffffffff000000000000000045bf000000000000000000000008000200ac80040000000000
InnoDB: End of page dump
090623 18:03:36 InnoDB: Page checksum 3578174752, prior-to-4.0.14-form checksum 1351638465
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 7,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 8
InnoDB: Page may be an update undo log page
InnoDB: Page may be an index page where index id is 0 48
InnoDB: (index "idx3" of table "test"."table0")
InnoDB: Error in page 7 of index "idx3" of table "test"."table0"
InnoDB: Records in wrong order on page 10 index "idx5" of table "test"."table0"
InnoDB: previous record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: SQL NULL;
 1: len 15; hex 7068656e796c6b65746f6e75726961; asc phenylketonuria;;
 2: len 6; hex 000000000202; asc ;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 8; hex 80001222ac2fd055; asc " / U;;
 1: len 8; hex 76696f6c61746564; asc violated;;
 2: len 6; hex 000000000203; asc ;;

InnoDB: Apparent corruption in page 10 in index "idx5" of table "test"."table0"
090623 18:03:36 InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 000000000000000affffffffffffffff000000000000000045bf000000000000000000000008000200b180040000000000
InnoDB: End of page dump

Changed in percona-xtradb:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
importance: Undecided → High

I have fixed and committed.
It is only problem of page validation. There are no corruptions.
Thank you.

Changed in percona-xtradb:
status: New → Fix Committed
Changed in percona-xtradb:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers