MySQL Bugs: #110598: [ERROR] [MY-013183] [InnoDB] Assertion failure: fsp0fsp.cc:2152:inode thread

Bug #110598	[ERROR] [MY-013183] [InnoDB] Assertion failure: fsp0fsp.cc:2152:inode thread
Submitted:	4 Apr 2023 5:40	Modified:	4 Apr 2023 12:12
Reporter:	jack tim	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.30	OS:	Windows (Windows Server 2016 Datacenter)
Assigned to:		CPU Architecture:	x86 (Intel Xeon Silver 4216)
Tags:	013183, assertion failure, fsp0fsp.cc, innodb, inode thread

Description:
My database server is experiencing an abnormal power outage.
And then the database server won't started.
I have tried using the following configration. But it still won't start.
I want to know if this is a softwate bug or hardware malfunction.
------------------------
[mysqld]
innodb_force_recovery = 1
------------------------

Error Information:
-------------------------------------------
2023-04-03T09:00:39.291134Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: fsp0fsp.cc:2152:inode thread 1556
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/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
09:00:39 UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x2006b7dea00
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
7ff6d20f0858    mysqld.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff6d128e92b    mysqld.exe!?print_fatal_signal@@YAXH@Z()
7ff6d128e6f3    mysqld.exe!?my_server_abort@@YAXXZ()
7ff6d20d47fa    mysqld.exe!?my_abort@@YAXXZ()
7ff6d231ca99    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6d22dc866    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6d22dc46e    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6d21e40f2    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21e6d8d    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21e5e2f    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21e5ccb    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21e30c8    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21f4202    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d21f7cc4    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6d22b033d    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ffd9485cde0    ucrtbase.dll!_o__realloc_base()
7ffd97358364    KERNEL32.DLL!BaseThreadInitThunk()
7ffd98297091    ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): 
Connection ID (thread ID): 0
Status: NOT_KILLED

How to repeat:
abnormal power outage.

error log

Attachment: WIN-C3H603MDJ2J.err (application/octet-stream, text), 39.44 KiB.

Hi Mr. tim,

Thank you for your bug report.

However, it is a bug in the Microsoft's STL library.

You can circumvent it by setting a larger thread stack value.

Hi Mr. tim,

It would also be very helpful if you could supply us with a fully repeatable test case.

Please, read next comment carefully.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.