Bug #97893 InnoDB: ibuf cursor restoration fails!. ibuf record inserted to page 9842:540
Submitted: 5 Dec 2019 12:11 Modified: 5 Jan 2020 13:18
Reporter: kevin kevin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.21 OS:CentOS (7.4)
Assigned to: CPU Architecture:Any
Tags: InnoDB: ibuf cursor restoration fails!. ibuf record inserted to page 9842:540

[5 Dec 2019 12:11] kevin kevin
Description:
2019-12-05T18:57:05.567322+08:00 0 [ERROR] InnoDB: ibuf cursor restoration fails!. ibuf record inserted to page 9842:540
2019-12-05T18:57:05.567913+08:00 0 [ERROR] InnoDB: Submit a detailed bug report to http://bugs.mysql.com
PHYSICAL RECORD: n_fields 1; 1-byte offsets; info bits 0
 0: len 8; hex 696e66696d756d00; asc infimum ;;
PHYSICAL RECORD: n_fields 11; 1-byte offsets; info bits 32
 0: len 4; hex 00002672; asc   &r;;
 1: len 1; hex 00; asc  ;;
 2: len 4; hex 0000022e; asc    .;;
 3: len 30; hex 000000018603000480008603000480000c0f0190802d0c0f0190802d0c0f; asc                      -     -  ; (total 46 bytes);
 4: len 4; hex 001b24f6; asc   $ ;;
 5: len 4; hex 00000000; asc     ;;
 6: len 3; hex 4e3230; asc N20;;
 7: len 5; hex 4e30303938; asc N0098;;
 8: len 7; hex 4e303030393831; asc N000981;;
 9: len 1; hex 80; asc  ;;
 10: len 8; hex 00000000000200f7; asc         ;;
DATA TUPLE: 3 fields;
 0: len 4; hex 00002672; asc   &r;;
 1: len 1; hex 00; asc  ;;
 2: len 4; hex 0000021c; asc     ;;
PHYSICAL RECORD: n_fields 11; 1-byte offsets; info bits 32
 0: len 4; hex 00002672; asc   &r;;
 1: len 1; hex 00; asc  ;;
 2: len 4; hex 0000022e; asc    .;;
 3: len 30; hex 000000018603000480008603000480000c0f0190802d0c0f0190802d0c0f; asc                      -     -  ; (total 46 bytes);
 4: len 4; hex 001b24f6; asc   $ ;;
 5: len 4; hex 00000000; asc     ;;
 6: len 3; hex 4e3230; asc N20;;
 7: len 5; hex 4e30303938; asc N0098;;
 8: len 7; hex 4e303030393831; asc N000981;;
 9: len 1; hex 80; asc  ;;
 10: len 8; hex 00000000000200f7; asc         ;;
2019-12-05T18:57:05.582374+08:00 0 [ERROR] [FATAL] InnoDB: Failed to restore ibuf position.
2019-12-05 18:57:05 0x2ae493cda700  InnoDB: Assertion failure in thread 47161220638464 in file ut0ut.cc line 943
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
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://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
10:57:05 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

How to repeat:
I cannot reproduce this
[5 Dec 2019 13:18] MySQL Verification Team
Hello Mr. kevin,

Thank you for your bug report.

However, you have provided us with sufficient info, nor are you running current 5.7 release. Hence, first of all, try running 5.7.28, because we do not want to chase some bugs that are fixed long time ago.

Next, if you manage to reproduce this, we need a fully repeatable test case, so that we can run it and find the cause of the bug.
[6 Jan 2020 1:00] Bugs System
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".