2023-03-03T10:25:34.779739Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 1210571 2023-03-03T10:25:34.791791Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-03T10:25:35.311204Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-03-03T10:25:35.471497Z 1 [Warning] [MY-011018] [InnoDB] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:25:35.471564Z 1 [Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in InnoDB read-only mode. 2023-03-03T10:25:35.481830Z 2 [Warning] [MY-011018] [Server] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:25:35.482875Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:25:35.482906Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:25:35.483378Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2023-03-03T10:25:35.497994Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2023-03-03T10:25:35.515071Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-03-03T10:25:35.515124Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-03-03T10:25:35.549148Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2023-03-03T10:25:35.549219Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.30-0ubuntu0.20.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 2023-03-03T10:26:11.053357Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.30-0ubuntu0.20.04.2). 2023-03-03T10:26:11.395635Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.20.04.2) (Ubuntu). 2023-03-03T10:26:11.862651Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 1210665 2023-03-03T10:26:11.875202Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-03T10:26:12.187010Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-03-03T10:26:12.333594Z 1 [Warning] [MY-011018] [InnoDB] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:26:12.333688Z 1 [Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in InnoDB read-only mode. 2023-03-03T10:26:12.346832Z 2 [Warning] [MY-011018] [Server] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:26:12.348000Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:26:12.348028Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:26:12.385957Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-03-03T10:26:12.386011Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-03-03T10:26:12.422898Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.30-0ubuntu0.20.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 2023-03-03T10:26:12.422909Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock InnoDB: Next record offset is nonsensical 65535 in record at offset 101 InnoDB: rec address 0x7f3745030065, space id 110, page 0 2023-03-03T10:26:32.906468Z 8 [ERROR] [MY-013183] [InnoDB] Assertion failure: page0page.ic:617 thread 139875544139520 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. 10:26:32 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x55eefb08c2e0 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 = 7f37501efd10 thread_stack 0x100000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x55eef5b304c1] /usr/sbin/mysqld(print_fatal_signal(int)+0x2fb) [0x55eef49cffbb] /usr/sbin/mysqld(my_server_abort()+0x76) [0x55eef49d0106] /usr/sbin/mysqld(my_abort()+0xe) [0x55eef5b2a4be] /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x349) [0x55eef5dbaf59] /usr/sbin/mysqld(+0x26a8f4e) [0x55eef5f15f4e] /usr/sbin/mysqld(+0x26aa78b) [0x55eef5f1778b] /usr/sbin/mysqld(dict_stats_update(dict_table_t*, dict_stats_upd_option_t)+0xeff) [0x55eef5f1b91f] /usr/sbin/mysqld(dict_stats_update(dict_table_t*, dict_stats_upd_option_t)+0xef2) [0x55eef5f1b912] /usr/sbin/mysqld(ha_innobase::open(char const*, int, unsigned int, dd::Table const*)+0xa14) [0x55eef5b86fc4] /usr/sbin/mysqld(handler::ha_open(TABLE*, char const*, int, int, dd::Table const*)+0x59) [0x55eef4ae1139] /usr/sbin/mysqld(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*)+0x1238) [0x55eef497a728] /usr/sbin/mysqld(open_table(THD*, TABLE_LIST*, Open_table_context*)+0x121f) [0x55eef47cd9af] /usr/sbin/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)+0x3c7) [0x55eef47cf2d7] /usr/sbin/mysqld(open_tables_for_query(THD*, TABLE_LIST*, unsigned int)+0x93) [0x55eef47d0693] /usr/sbin/mysqld(Sql_cmd_dml::prepare(THD*)+0x13c) [0x55eef48bcdfc] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0xfe) [0x55eef48c684e] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa00) [0x55eef4862c30] /usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x434) [0x55eef4867a94] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1d17) [0x55eef4869cd7] /usr/sbin/mysqld(do_command(THD*)+0x207) [0x55eef486afd7] /usr/sbin/mysqld(+0x1153e48) [0x55eef49c0e48] /usr/sbin/mysqld(+0x282ea4d) [0x55eef609ba4d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7f3769f5e609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f37691ca163] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (55eefb0955c0): select * into outfile "/home/myuser/myfile.txt" FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' from MyDb.MyTable Connection ID (thread ID): 8 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. 2023-03-03T10:26:33.547087Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.20.04.2) starting as process 1210746 2023-03-03T10:26:33.559510Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-03T10:26:34.109088Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-03-03T10:26:34.263946Z 1 [Warning] [MY-011018] [InnoDB] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:26:34.264019Z 1 [Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in InnoDB read-only mode. 2023-03-03T10:26:34.275299Z 2 [Warning] [MY-011018] [Server] Skip updating information_schema metadata in InnoDB read-only mode. 2023-03-03T10:26:34.277058Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:26:34.277094Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode. 2023-03-03T10:26:34.277796Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2023-03-03T10:26:34.294464Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2023-03-03T10:26:34.326102Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-03-03T10:26:34.326184Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-03-03T10:26:34.363121Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2023-03-03T10:26:34.363171Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.30-0ubuntu0.20.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).