MySQL Bugs: #23730: innodb page dumps difficult to read in error log

Bug #23730	innodb page dumps difficult to read in error log
Submitted:	27 Oct 2006 16:58	Modified:	30 Oct 2006 12:01
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	*	OS:
Assigned to:	Heikki Tuuri	CPU Architecture:	Any

Description:
Sometimes when mysql crashes, innodb needs to print out
some hex dumps for diagnostics purposes.

But these are difficult to read, since the bytes are
printed in a long line.

How to repeat:
See an example error file:
InnoDB: file read of page 1105475.
InnoDB: You may have to recover from a backup.
060531  7:01:46  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex a12ecb290010de430010de420010de4400000020931e22c745bf000000000000000000000000006f3b0a81bb000000000000000201b801b900000000000000000000000000000000013effffffff0000000eb7f3004a0000000000000000010002001b696e66696d756d0006000b000073757072656d756d02000010002280000013d1bf552b8fac650000328bb63480000f000904fb8000002702000018002280000013d1bf552b8fac660000328bb63480000f000905128000000e02000020002280000013d1bf552c8fac650000328bb63480000f000905298000002802040028002280000013d1bf552c8fac660000328bb63480000f000905408000000702000030002280000013d1bf552d8fac650000328bb63480000f000905578000003402000038002280000013d1bf552d8fac660000328bb63480000f0009056e8000000b02000040002280000013d1bf552e8fac650000328bb63480000f000905858000002d02040048002280000013d1bf552e8fac660000328bb63480000f0009059c8000000e02000050002280000013d1bf552f8fac650000328bb63480000f000905b38000003402000058002280000013d1bf552f8fac660000328bb63480000f000905ca8000000d02000060002280000013d1bf55308fac650000328bb63480000f000905e18000001e02040068002280000013d1bf55308fac660000048000860a00038000cfac9d3a800000c98fac9e2724201c0905040004000f1a560000007a000002777200860300048000860300048000860a00038000cfac9d52800000c98fac9e2724201c0905040004080f1a8a0000007a000002777200860300048000860300048000860a00038000cfac9d52800000c98faca12724201c0905040404100f1abe0000007a000002777200860300048000860300048000860a00038000cfac9d53800000c98fac9e2724201c0905040004180f1af20000007a000002777200860300048000860300048000860a00038000cfac9d54800000c98fac9e2724201c0905040004200f1b260000007a000002777200860300048000860300048000860a00038000cfac9d54800000c98faca12724201c0905040004280f1b5a0000007a000002777200860300048000860300048000860a00038000cfac9d55800000c98fac9e2724201c0905040404300f1b8e0000007a000002777200860300048000860300048000860a00038000cfac9d56800000c98fac9e2724201c0905040004380f1bc20000007a000002777200860300048000860300048000860a00038000cfac9d57800000c98faca12724201c0905040004400f1bf60000007a000002777200860300048000860300048000860a00038000cfac9d66800000c98fac9e2724201c0905040004480f1c2a0000007a000002777200860300048000860300048000860a00038000cfac9d66800000c98faca12724201c0905040404500f1c5e0000007a000002777200860300048000860300048000860a00038000cfac9d6e800000c98fac9e2724201c0905040004580f1c920000007a000002777200860300048000860300048000860a00038000cfac9d6e800000c98faca12724201c0905040004600f1cc60000007a000002777200860300048000860300048000860a00038000cfac9d6f800000c98fac9e2724201c0905040004680f1cfa0000007a000002777200860300048000860300048000860a00038000cfac9d6f800000c98faca12724201c0905040404700f1d2e0000007a000002777200860300048000860300048000860a00038000cfac9d70800000c98fac9e2724201c0905040004780f1d620000007a000002777200860300048000860300048000860a00038000cfac9d70800000c98faca12724201c0905040004800f1d960000007a000002777200860300048000860300048000860a00038000cfac9d72800000c98fac9e2724201c0905040004880f1dca0000007a000002777200860300048000860300048000860a00038000cfac9d72800000c98faca12724201c0905040404900f1dfe0000007a000002777300860300048000860300048000860a00038000cfbcaa4a800000c98fac9e2724201c0905040004980f1e320000007a000002777300860300048000860300048000860a00038000cfbcb6a2800000c98fac9e2724201c0905040004a00f1e660000007a000002777300860300048000860300048000860a00038000cfbcb7aa800000c98fac9e2724201c0905040004a80f1e9a0000007a000002777300860300048000860300048000860a00038000cfbcb7b2800000c98fac9e2724201c0905040404b00f1ece0000007a000002777300860300048000860300048000860a00038000cfbcb7fa800000c98fac9e2724201c0905040004b80f1f020000007a000002777300860300048000860300048000860a00038000cfbcb7fa800000c98faca12724201c0905040004c00f1f360000007a000002777300860300048000860300048000860a00038000cfbcb810800000c98fac9e2724201c0905040004c80f1f6a0000007a000002777300860300048000860300048000860a00038000cfbcb86d800000c98fac9e2724201c0905040404d00f1f9e0000007a000002777300860300048000860300048000860a00038000cfbcb86d800000c98faca12724201c0905040004d80f1fd20000007a000002777300860300048000860300048000860a00038000cfbcb894800000c98fac9e2724201c0905040004e00f20060000007a000002777300860300048000860300048000860a00038000cfbcb9b2800000c98fac9e2724201c0905040004e80f203a0
<cut>
asc  . )   C   B   D      " E              o;                                >           J 
<cut>
 ;InnoDB: End of page dump
060531  7:01:46  InnoDB: Page checksum 644071840, prior-to-4.0.14-form checksum 1240221236

Suggested fix:
Use a better format, like this for example:

[DEBUG]  20:55:06 [line 0314] - print_hex printing 4095 lines and 15 bytes
00000000h: 8B 1D 84 CC 05 08 8B 55 F8 89 D0 C1 E0 04 29 D0 ; .......U......). 
00000010h: 8D 14 85 00 00 00 00 8B 44 0B 0C FF 74 10 08 E8 ; ........D...t... 
00000020h: 72 72 FF FF 83 C4 10 8B 55 08 89 D0 C1 E0 03 29 ; rr......U......) 
00000030h: D0 8D 0C 85 00 00 00 00 8B 1D 84 CC 05 08 8B 55 ; ...............U 
00000040h: F8 89 D0 C1 E0 04 29 D0 8D 14 85 00 00 00 00 8B ; ......)......... 
00000050h: 44 0B 0C C7 44 10 08 00 00 00 00 83 EC 08 8B 55 ; D...D..........U 
00000060h: 08 89 D0 C1 E0 03 29 D0 8D 0C 85 00 00 00 00 8B ; ......).........

Shane,

the hex dump is intentionally just one long string. Then it is easy to adjust the width of the Windows Notepad editor so that a possible periodic pattern in the hex dump is seen. Searching the hex dump works in the editor. And piping the hex dump into a program is easy.

I am putting this to the 'Won't fix' state.

Regards,

Heikki

heh, this is the fixed version of the previously attached print_hex function, fyi :)

Attachment: print_hex.c (text/plain), 2.90 KiB.