2026-06-19T19:36:58.929899Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) initializing of server in progress as process 27320
2026-06-19T19:36:58.937274Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:36:59.228839Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:37:00.813733Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2026-06-19T19:37:01.679106Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.46-0ubuntu0.24.04.2).
2026-06-19T19:37:05.534586Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) starting as process 27367
2026-06-19T19:37:05.555880Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:37:05.704464Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:37:05.926082Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-06-19T19:37:05.926119Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-06-19T19:37:05.929997Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2026-06-19T19:37:05.945562Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2026-06-19T19:37:05.945659Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.46-0ubuntu0.24.04.2'  socket: '/tmp/tmp.yvtx6ccsYP/mysqld.sock'  port: 0  (Ubuntu).
2026-06-19T19:37:05.964949Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.46-0ubuntu0.24.04.2).
2026-06-19T19:37:07.416779Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.46-0ubuntu0.24.04.2)  (Ubuntu).
2026-06-19T19:37:08.904847Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) starting as process 27508
2026-06-19T19:37:08.910988Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:37:09.038572Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:37:09.205681Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-06-19T19:37:09.205714Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-06-19T19:37:09.224160Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-06-19T19:37:09.224197Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.46-0ubuntu0.24.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2026-06-19T19:39:55.811684Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.46-0ubuntu0.24.04.2).
2026-06-19T19:39:56.491118Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.46-0ubuntu0.24.04.2)  (Ubuntu).
2026-06-19T19:39:56.886973Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) starting as process 55663
2026-06-19T19:39:56.893136Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:39:57.023137Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:39:57.198567Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-06-19T19:39:57.198606Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-06-19T19:39:57.217102Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.46-0ubuntu0.24.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2026-06-19T19:39:57.217096Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-06-19T19:40:01.459346Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.46-0ubuntu0.24.04.2).
2026-06-19T19:40:02.630909Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.46-0ubuntu0.24.04.2)  (Ubuntu).
2026-06-19T19:40:03.027169Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) starting as process 56205
2026-06-19T19:40:03.033346Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:40:03.154461Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:40:03.337478Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-06-19T19:40:03.337506Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-06-19T19:40:03.354744Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-06-19T19:40:03.354809Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.46-0ubuntu0.24.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2026-06-19T19:50:11.288690Z 172 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:602:index == cursor->index thread 128494918674112
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.
2026-06-19T19:50:11Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=da5a92e332aca35db6c3d9eac1d0791508874891
Thread pointer: 0x74dd8002ae30
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 = 74dd8dfb9c70 thread_stack 0x30000
 #0 0x654fccefe13d _Z8my_abortv
 #1 0x654fcd0a832d _Z23ut_dbg_assertion_failedPKcS0_m
 #2 0x654fcd102592 <unknown>
 #3 0x654fcd0ef7f9 _Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t
 #4 0x654fccfcabb4 <unknown>
 #5 0x654fcd06bdae _Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm
 #6 0x654fccf3b7d5 _ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function
 #7 0x654fcc6904c4 _ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function
 #8 0x654fcc43bef0 _Z10read_constP5TABLEP12Index_lookup
 #9 0x654fcc43bfaf _Z21join_read_const_tableP8JOIN_TABP8POSITION
 #10 0x654fcc44c67d _ZN4JOIN29extract_func_dependent_tablesEv
 #11 0x654fcc4583d8 _ZN4JOIN14make_join_planEv
 #12 0x654fcc45ae79 _ZN4JOIN8optimizeEb
 #13 0x654fcc4b7b83 _ZN11Query_block8optimizeEP3THDb
 #14 0x654fcc51942c _ZN16Query_expression8optimizeEP3THDP5TABLEbb
 #15 0x654fcc8ba322 _ZN9Table_ref16optimize_derivedEP3THD
 #16 0x654fcc45a4c2 _ZN4JOIN8optimizeEb
 #17 0x654fcc4b7b83 _ZN11Query_block8optimizeEP3THDb
 #18 0x654fcc51942c _ZN16Query_expression8optimizeEP3THDP5TABLEbb
 #19 0x654fcc4aab43 _ZN11Sql_cmd_dml13execute_innerEP3THD
 #20 0x654fcc4aa31f _ZN11Sql_cmd_dml7executeEP3THD
 #21 0x654fcc45e5dc _Z21mysql_execute_commandP3THDb
 #22 0x654fcc46203e _Z20dispatch_sql_commandP3THDP12Parser_state
 #23 0x654fcc46428f _Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command
 #24 0x654fcc464e84 _Z10do_commandP3THD
 #25 0x654fcc5a0d36 <unknown>
 #26 0x654fcd2e91bf <unknown>
 #27 0x74debd89caa3 <unknown>
 #28 0x74debd929c6b <unknown>
 #29 0xffffffffffffffff <unknown>

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (74dd8030d9a0): is an invalid pointer
Connection ID (thread ID): 172
Status: NOT_KILLED

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.
2026-06-19T19:50:11.288691Z 0 [System] [MY-013951] [Server] 2026-06-19T19:50:11Z UTC - mysqld got signal 6 ;
2026-06-19T19:50:11.288692Z 0 [System] [MY-013951] [Server] Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
2026-06-19T19:50:11.288693Z 0 [System] [MY-013951] [Server] BuildID[sha1]=da5a92e332aca35db6c3d9eac1d0791508874891
2026-06-19T19:50:11.288694Z 0 [System] [MY-013951] [Server] Thread pointer: 0x74dd8002ae30
2026-06-19T19:50:11.288695Z 0 [System] [MY-013951] [Server] Attempting backtrace. You can use the following information to find out
2026-06-19T19:50:11.288696Z 0 [System] [MY-013951] [Server] where mysqld died. If you see no messages after this, something went
2026-06-19T19:50:11.288697Z 0 [System] [MY-013951] [Server] terribly wrong...
2026-06-19T19:50:11.288698Z 0 [System] [MY-013951] [Server] stack_bottom = 74dd8dfb9c70 thread_stack 0x30000
2026-06-19T19:50:11.288699Z 0 [System] [MY-013951] [Server]  #0 0x654fccefe13d _Z8my_abortv
2026-06-19T19:50:11.288700Z 0 [System] [MY-013951] [Server]  #1 0x654fcd0a832d _Z23ut_dbg_assertion_failedPKcS0_m
2026-06-19T19:50:11.288701Z 0 [System] [MY-013951] [Server]  #2 0x654fcd102592 <unknown>
2026-06-19T19:50:11.288702Z 0 [System] [MY-013951] [Server]  #3 0x654fcd0ef7f9 _Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t
2026-06-19T19:50:11.288703Z 0 [System] [MY-013951] [Server]  #4 0x654fccfcabb4 <unknown>
2026-06-19T19:50:11.288704Z 0 [System] [MY-013951] [Server]  #5 0x654fcd06bdae _Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm
2026-06-19T19:50:11.288705Z 0 [System] [MY-013951] [Server]  #6 0x654fccf3b7d5 _ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function
2026-06-19T19:50:11.288706Z 0 [System] [MY-013951] [Server]  #7 0x654fcc6904c4 _ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function
2026-06-19T19:50:11.288707Z 0 [System] [MY-013951] [Server]  #8 0x654fcc43bef0 _Z10read_constP5TABLEP12Index_lookup
2026-06-19T19:50:11.288708Z 0 [System] [MY-013951] [Server]  #9 0x654fcc43bfaf _Z21join_read_const_tableP8JOIN_TABP8POSITION
2026-06-19T19:50:11.288709Z 0 [System] [MY-013951] [Server]  #10 0x654fcc44c67d _ZN4JOIN29extract_func_dependent_tablesEv
2026-06-19T19:50:11.288710Z 0 [System] [MY-013951] [Server]  #11 0x654fcc4583d8 _ZN4JOIN14make_join_planEv
2026-06-19T19:50:11.288711Z 0 [System] [MY-013951] [Server]  #12 0x654fcc45ae79 _ZN4JOIN8optimizeEb
2026-06-19T19:50:11.288712Z 0 [System] [MY-013951] [Server]  #13 0x654fcc4b7b83 _ZN11Query_block8optimizeEP3THDb
2026-06-19T19:50:11.288713Z 0 [System] [MY-013951] [Server]  #14 0x654fcc51942c _ZN16Query_expression8optimizeEP3THDP5TABLEbb
2026-06-19T19:50:11.288714Z 0 [System] [MY-013951] [Server]  #15 0x654fcc8ba322 _ZN9Table_ref16optimize_derivedEP3THD
2026-06-19T19:50:11.288715Z 0 [System] [MY-013951] [Server]  #16 0x654fcc45a4c2 _ZN4JOIN8optimizeEb
2026-06-19T19:50:11.288716Z 0 [System] [MY-013951] [Server]  #17 0x654fcc4b7b83 _ZN11Query_block8optimizeEP3THDb
2026-06-19T19:50:11.288717Z 0 [System] [MY-013951] [Server]  #18 0x654fcc51942c _ZN16Query_expression8optimizeEP3THDP5TABLEbb
2026-06-19T19:50:11.288718Z 0 [System] [MY-013951] [Server]  #19 0x654fcc4aab43 _ZN11Sql_cmd_dml13execute_innerEP3THD
2026-06-19T19:50:11.288719Z 0 [System] [MY-013951] [Server]  #20 0x654fcc4aa31f _ZN11Sql_cmd_dml7executeEP3THD
2026-06-19T19:50:11.288720Z 0 [System] [MY-013951] [Server]  #21 0x654fcc45e5dc _Z21mysql_execute_commandP3THDb
2026-06-19T19:50:11.288721Z 0 [System] [MY-013951] [Server]  #22 0x654fcc46203e _Z20dispatch_sql_commandP3THDP12Parser_state
2026-06-19T19:50:11.288722Z 0 [System] [MY-013951] [Server]  #23 0x654fcc46428f _Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command
2026-06-19T19:50:11.288723Z 0 [System] [MY-013951] [Server]  #24 0x654fcc464e84 _Z10do_commandP3THD
2026-06-19T19:50:11.288724Z 0 [System] [MY-013951] [Server]  #25 0x654fcc5a0d36 <unknown>
2026-06-19T19:50:11.288725Z 0 [System] [MY-013951] [Server]  #26 0x654fcd2e91bf <unknown>
2026-06-19T19:50:11.288726Z 0 [System] [MY-013951] [Server]  #27 0x74debd89caa3 <unknown>
2026-06-19T19:50:11.288727Z 0 [System] [MY-013951] [Server]  #28 0x74debd929c6b <unknown>
2026-06-19T19:50:11.288728Z 0 [System] [MY-013951] [Server]  #29 0xffffffffffffffff <unknown>
2026-06-19T19:50:11.288729Z 0 [System] [MY-013951] [Server] Trying to get some variables.
2026-06-19T19:50:11.288730Z 0 [System] [MY-013951] [Server] Some pointers may be invalid and cause the dump to abort.
2026-06-19T19:50:11.288731Z 0 [System] [MY-013951] [Server] Query (74dd8030d9a0): is an invalid pointer
2026-06-19T19:50:11.288732Z 0 [System] [MY-013951] [Server] Connection ID (thread ID): 172
2026-06-19T19:50:11.288733Z 0 [System] [MY-013951] [Server] Status: NOT_KILLED
2026-06-19T19:50:11.288734Z 0 [System] [MY-013951] [Server] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
2026-06-19T19:50:11.288735Z 0 [System] [MY-013951] [Server] information that should help you find out what is causing the crash.
2026-06-19T19:50:11.964625Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.46-0ubuntu0.24.04.2) starting as process 115100
2026-06-19T19:50:11.967269Z 0 [System] [MY-013951] [Server] A backtrace was processed and added to the main error-log in the appropriate format.
2026-06-19T19:50:11.971798Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-06-19T19:50:13.084470Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-06-19T19:50:13.520401Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2026-06-19T19:50:13.537489Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2026-06-19T19:50:13.661928Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-06-19T19:50:13.661966Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-06-19T19:50:13.681901Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-06-19T19:50:13.682020Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.46-0ubuntu0.24.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).