Bug #110060 shutdown: Failing assertion: UT_LIST_GET_LEN(rseg->update_undo_list) == 0

• Submitted: 14 Feb 2023 9:32
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S2 (Serious)
• Version: 5.7.41
• OS: Any
• CPU Architecture: Any

[14 Feb 2023 9:32] Shane Bester

Description:
InnoDB: Failing assertion: UT_LIST_GET_LEN(rseg->update_undo_list) == 0

(gdb) bt
#0  in pthread_kill () from /lib64/libpthread.so.0
#1  in handle_fatal_signal (sig=6) at ./sql/signal_handler.cc:227
#2  <signal handler called>
#3  in raise () from /lib64/libc.so.6
#4  in abort () from /lib64/libc.so.6
#5  in ut_dbg_assertion_failed at ./storage/innobase/ut/ut0dbg.cc:75
#6  in trx_rseg_mem_free at ./storage/innobase/trx/trx0rseg.cc:142
#7  in trx_sys_close () at ./storage/innobase/trx/trx0sys.cc:1207
#8  in innobase_shutdown_for_mysql () at ./storage/innobase/srv/srv0start.cc:2791
#9  in innobase_end at ./storage/innobase/handler/ha_innodb.cc:4238
#10 in ha_finalize_handlerton at ./sql/handler.cc:791
#11 in plugin_deinitialize at ./sql/sql_plugin.cc:1035
#12 in reap_plugins () at ./sql/sql_plugin.cc:1117
#13 in plugin_shutdown () at ./sql/sql_plugin.cc:1991
#14 in clean_up (print_message=true) at ./sql/mysqld.cc:1333
#15 in mysqld_main at ./sql/mysqld.cc:5212
#16 in __libc_start_main () from /lib64/libc.so.6
#17 in _start ()

How to repeat:
Occurs on each graceful shutdown.  Server is not processing much load.