I am trying to restart mysql however I am getting stuck in this loop.
I have tried doing innodb_force_recovery = 4 in an attempt to backup the tables, but even that fails. Please suggest how to get this up and running.
2024-09-21T11:41:21.146039Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39-0ubuntu0.20.04.1) starting as process 287290
2024-09-21T11:41:21.155269Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.
2024-09-21T11:41:21.156630Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-21T11:41:23.407433Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: fut0lst.ic:82:addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA thread 140535711876864
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.
2024-09-21T11:41:23Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=26eb959d4d27330a3b28319eb9ea144b2a96f707
Thread pointer: 0x0
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 = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x5609f1d2c771]
/usr/sbin/mysqld(print_fatal_signal(int)+0x39b) [0x5609f0b9ed6b]
/usr/sbin/mysqld(my_server_abort()+0x76) [0x5609f0b9eeb6]
/usr/sbin/mysqld(my_abort()+0xe) [0x5609f1d2670e]
/usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x349) [0x5609f1fca2e9]
/usr/sbin/mysqld(+0x258619c) [0x5609f1fa419c]
/usr/sbin/mysqld(trx_rseg_init_thread(void*, unsigned long)+0x663) [0x5609f1fab383]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)(void*, unsigned long), void*, unsigned long> > >::_M_run()+0xcc) [0x5609f1f9ff4c]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd6df4) [0x7fd6dc93cdf4]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7fd6dca58609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fd6dc629353]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.