MySQL Bugs: #107086: MySQL fails to start-up when trying to start up from a snapshot (AWS).

Bug #107086	MySQL fails to start-up when trying to start up from a snapshot (AWS).
Submitted:	21 Apr 2022 18:45	Modified:	21 Apr 2022 18:53
Reporter:	Michael Amadi	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	8.0.27	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Hi, 

I am trying to restore my database from a snapshot I took on AWS. However, when I try to restore it on my RDS instance, the database fails to start up, and the below is in the error logs: 

InnoDB: Progress in percents: 12022-04-21T16:53:27.796961Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0umod.cc:153:!dummy_big_rec thread 70382163853408
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.
16:53:27 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x40031f216000
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...
stack_bottom = 40031fdff758 thread_stack 0x40000
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x30) [0x1f36c70]
/rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x29c) [0xf6d41c]
linux-vdso.so.1(__kernel_rt_sigreturn+0) [0x400013675668]
/lib64/libc.so.6(gsignal+0xb0) [0x4000138a84f0]
/lib64/libc.so.6(abort+0x154) [0x4000138a9d34]
/rdsdbbin/mysql/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x27c) [0x22146bc]
/rdsdbbin/mysql/bin/mysqld() [0x23bf440]
/rdsdbbin/mysql/bin/mysqld() [0x23bf964]
/rdsdbbin/mysql/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xdcc) [0x23c1eac]
/rdsdbbin/mysql/bin/mysqld(row_undo_step(que_thr_t*)+0x58) [0x219fdf8]
/rdsdbbin/mysql/bin/mysqld(que_run_threads(que_thr_t*)+0x688) [0x2151648]
/rdsdbbin/mysql/bin/mysqld(trx_rollback_or_clean_recovered(unsigned long)+0xa54) [0x21f6654]
/rdsdbbin/mysql/bin/mysqld(trx_recovery_rollback_thread()+0x1c) [0x21f707c]
/rdsdbbin/mysql/bin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)()> > >::_M_run()+0xec) [0x20fa24c]
/rdsdbbin/mysql/bin/mysqld() [0x29e449c]
/lib64/libpthread.so.0(+0x722c) [0x40001375622c]
/lib64/libc.so.6(+0xd2e5c) [0x400013948e5c]

How to repeat:

Not able to reproduce this, as at each attempt, it crashes.