innodb plugin can't update records

Bug #585963 reported by Alex Yurchenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Invalid
Undecided
Unassigned
Trunk
Invalid
Undecided
Unassigned

Bug Description

DBT2 causes accepting server to crash with the following:
100526 8:08:55 [Note] WSREP: Member 1 (node1) synced with group.
InnoDB: Error: trying to access update undo rec field 23 in index "PRIMARY" of table "dbt2"."warehouse"
InnoDB: but index has only 11 fields
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: Run also CHECK TABLE "dbt2"."warehouse"
InnoDB: n_fields = 4, i = 2, ptr 0x2aaab00cf0d7
InnoDB: Error: trying to access update undo rec for table dbt2/warehouse
InnoDB: but the table id in the undo record is wrong
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: Run also CHECK TABLE dbt2/warehouse
InnoDB: table dbt2/warehouse, index PRIMARY, n_uniq 1
InnoDB: undo rec address 0x2aaab00cf0b8, type 0 cmpl_info 4
InnoDB: undo rec table id 0 0, index table id 0 122
InnoDB: dump of 150 bytes in undo rec: len 150; hex 822f400480000175048000000804800008a304800000050108040000000017ef184f1c657700000012ae94e080000015822f5c0480000175048000000804800008a3048000000601080400000000181f187f1c667700000012ae94e080000015822f780480000175048000000804800008a3048000000701080400000000184f18af1c677700000012ae94e080000015822f94048000; asc /@ u O ew /\ u fw /x u O gw / ;
InnoDB: index record PHYSICAL RECORD: n_fields 11; compact format; info bits 0
 0: len 4; hex 80000001; asc ;; 1: len 6; hex 00000094954e; asc N;; 2: len 7; hex 00000017db2a40; asc *@;; 3: len 9; hex 34572bf94dee2f6147; asc 4W+ M /aG;; 4: len 18; hex de564a3b742b50f6fe6d357632ee2e3ded54; asc VJ;t+P m5v2 .= T;; 5: len 20; hex 254e23524ff27c3ff63b5b5feeeb7e2159e44850; asc %N#RO |? ;[_ ~!Y HP;; 6: len 18; hex ef5b53214a563538dc233b2b246350ec3d64; asc [S!JV58 #;+$cP =d;; 7: len 2; hex 7477; asc tw;; 8: len 9; hex 353437343131313131; asc 547411111;; 9: len 8; hex c217265305a3a23f; asc &S ?;; 10: len 12; hex 8000004b41e22eac2a780000; asc KA . *x ;;

InnoDB: record version PHYSICAL RECORD: n_fields 11; compact format; info bits 0
 0: len 4; hex 80000001; asc ;; 1: len 6; hex 000000947811; asc x ;; 2: len 7; hex 00000017be17ff; asc ;; 3: len 9; hex 34572bf94dee2f6147; asc 4W+ M /aG;; 4: len 18; hex de564a3b742b50f6fe6d357632ee2e3ded54; asc VJ;t+P m5v2 .= T;; 5: len 20; hex 254e23524ff27c3ff63b5b5feeeb7e2159e44850; asc %N#RO |? ;[_ ~!Y HP;; 6: len 18; hex ef5b53214a563538dc233b2b246350ec3d64; asc [S!JV58 #;+$cP =d;; 7: len 2; hex 7477; asc tw;; 8: len 9; hex 353437343131313131; asc 547411111;; 9: len 8; hex c217265305a3a23f; asc &S ?;; 10: len 12; hex 8000004b2d9a295141580000; asc K- )QAX ;;

InnoDB: Record trx id 0 9730065, update rec trx id 1 1963229184
InnoDB: Roll ptr in rec 0 398333951, in update rec 0 134512640
InnoDB: Purge system view:
Normal read view
Read view low limit trx n:o 0 9699840
Read view up limit trx id 0 9699840
Read view low limit trx id 0 9699840
Read view individually stored trx ids:
InnoDB: Purge trx n:o 0 9739433, undo n_o 0 0
InnoDB: Purge next stored 1, page_no 2996, offset 0,
InnoDB: Purge hdr_page_no 2996, hdr_offset 7950
InnoDB: unknown error code 11
100526 8:12:50 InnoDB: Assertion failure in thread 1226967360 in file row/row0mysql.c line 560
InnoDB: We intentionally generate a memory trap.

mysql> CHECK TABLE dbt2.warehouse;
ERROR 1047 (08S01): Unknown command

Revision history for this message
Alex Yurchenko (ayurchen) wrote :

must have been a problem with snapshot, not repeatable.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.