Hey! I am running a Canary server and i get a crash with my mysql, tried searching for the error but i cannot understand it really. Is there someone here that can help me? Its client version 13.20.
Code:
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-08-14T19:38:37.696694Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-08-14T19:38:37.696722Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 5692
2023-08-14T19:38:37.765054Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-08-14T19:38:45.179562Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-08-14T19:38:48.947410Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-08-14T19:38:48.952685Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-08-14T19:38:49.371322Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-08-14T19:38:49.371921Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-08-14T19:38:49.499853Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-08-14T19:38:49.500069Z 0 [System] [MY-010931] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe: ready for connections. Version: '8.0.31' socket: '' port: 3306 MySQL Community Server - GPL.
2023-08-14T20:33:47.395643Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-08-15T03:15:34.768114Z 1417 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:1338:index->id == btr_page_get_index_id(page) thread 1928
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.
2023-08-15T03:15:34Z UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x1db66325ea0
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...
7ff78d96fa68 mysqld_z.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff78caf9411 mysqld_z.exe!?print_fatal_signal@@YAXH@Z()
7ff78caf9153 mysqld_z.exe!?my_server_abort@@YAXXZ()
7ff78d953a7a mysqld_z.exe!?my_abort@@YAXXZ()
7ff78dbac7f9 mysqld_z.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff78db833d7 mysqld_z.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff78dc10b5c mysqld_z.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff78dc36c32 mysqld_z.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff78da39cc1 mysqld_z.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff78c8e2042 mysqld_z.exe!?ha_index_read_map@handler@@QEAAHPEAEPEBEKW4ha_rkey_function@@@Z()
7ff78cbef330 mysqld_z.exe!?read_const@@YAHPEAUTABLE@@PEAUTABLE_REF@@@Z()
7ff78cbeedcf mysqld_z.exe!?join_read_const_table@@YAHPEAVJOIN_TAB@@PEAUPOSITION@@@Z()
7ff78cb3e5ac mysqld_z.exe!?extract_func_dependent_tables@JOIN@@AEAA_NXZ()
7ff78cb40ff5 mysqld_z.exe!?make_join_plan@JOIN@@AEAA_NXZ()
7ff78cb432d4 mysqld_z.exe!?optimize@JOIN@@QEAA_N_N@Z()
7ff78cbb7f19 mysqld_z.exe!?optimize@Query_block@@QEAA_NPEAVTHD@@_N@Z()
7ff78cc58cc3 mysqld_z.exe!?optimize@Query_expression@@QEAA_NPEAVTHD@@PEAUTABLE@@_N2@Z()
7ff78cbb5130 mysqld_z.exe!?execute_inner@Sql_cmd_dml@@MEAA_NPEAVTHD@@@Z()
7ff78cbb5012 mysqld_z.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@Z()
7ff78cab276a mysqld_z.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff78caad581 mysqld_z.exe!?dispatch_sql_command@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff78caac2b5 mysqld_z.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff78caad946 mysqld_z.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff78c8d9178 mysqld_z.exe!?thread_id@THD@@QEBAIXZ()
7ff78df65b79 mysqld_z.exe!?my_init_dynamic_array@@YA_NPEAUDYNAMIC_ARRAY@@IIPEAXII@Z()
7ff78d9605ac mysqld_z.exe!?my_thread_self_setname@@YAXPEBD@Z()
7ffd0b061bb2 ucrtbase.dll!_configthreadlocale()
7ffd0d1b7614 KERNEL32.DLL!BaseThreadInitThunk()
7ffd0d7c26b1 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1db664cca80): SELECT `tables` FROM `phpmyadmin`.`pma__recent` WHERE `username` = 'root'
Connection ID (thread ID): 1417
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-08-15T03:49:19.207434Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-08-15T03:49:19.207459Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 11096
2023-08-15T03:49:19.402475Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-08-15T03:49:41.298426Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-08-15T03:49:45.199250Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-08-15T03:49:45.204893Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-08-15T03:49:45.658835Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-08-15T03:49:45.660579Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-08-15T03:49:45.866234Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-08-15T03:49:45.866553Z 0 [System] [MY-010931] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe: ready for connections. Version: '8.0.31' socket: '' port: 3306 MySQL Community Server - GPL.