hello can someone please help me i tried hours of trouble shooting and cant figure this issue out the following error happens everything runs smooth until at random times the uniserver crashes and i get the following errors SQLSTATE [2002] no connection could be made the target machine refused it. And this Mysql error log.
2023-10-20T20:03:22.696358Z 815 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:1338:index->id == btr_page_get_index_id(page) thread 10316
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to MySQL Bugs (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: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery (http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html)
InnoDB: about forcing recovery.
2023-10-20T20:03:22Z UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x23f2b001080
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...
7ff712dafa68 mysqld_z.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff711f39411 mysqld_z.exe!?print_fatal_signal@@YAXH@Z()
7ff711f39153 mysqld_z.exe!?my_server_abort@@YAXXZ()
7ff712d93a7a mysqld_z.exe!?my_abort@@YAXXZ()
7ff712fec7f9 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()
7ff712fc33d7 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()
7ff713050b5c 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()
7ff713076c32 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()
7ff712e79cc1 mysqld_z.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff711d22042 mysqld_z.exe!?ha_index_read_map@handler@@QEAAHPEAEPEBEKW4ha_rkey_function@@@Z()
7ff71202f330 mysqld_z.exe!?read_const@@YAHPEAUTABLE@@PEAUTABLE_REF@@@Z()
7ff71202edcf mysqld_z.exe!?join_read_const_table@@YAHPEAVJOIN_TAB@@PEAUPOSITION@@@Z()
7ff711f7e5ac mysqld_z.exe!?extract_func_dependent_tables@JOIN@@AEAA_NXZ()
7ff711f80ff5 mysqld_z.exe!?make_join_plan@JOIN@@AEAA_NXZ()
7ff711f832d4 mysqld_z.exe!?optimize@JOIN@@QEAA_N_N@Z()
7ff711ff7f19 mysqld_z.exe!?optimize@Query_block@@QEAA_NPEAVTHD@@_N@Z()
7ff712098cc3 mysqld_z.exe!?optimize@Query_expression@@QEAA_NPEAVTHD@@PEAUTABLE@@_N2@Z()
7ff711ff5130 mysqld_z.exe!?execute_inner@Sql_cmd_dml@@MEAA_NPEAVTHD@@@Z()
7ff711ff5012 mysqld_z.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@Z()
7ff711ef276a mysqld_z.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff711eed581 mysqld_z.exe!?dispatch_sql_command@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff711eec2b5 mysqld_z.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff711eed946 mysqld_z.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff711d19178 mysqld_z.exe!?thread_id@THD@@QEBAIXZ()
7ff7133a5b79 mysqld_z.exe!?my_init_dynamic_array@@YA_NPEAUDYNAMIC_ARRAY@@IIPEAXII@Z()
7ff712da05ac mysqld_z.exe!?my_thread_self_setname@@YAXPEBD@Z()
7fff6d53268a ucrtbase.dll!_o_exp()
7fff70487974 KERNEL32.DLL!BaseThreadInitThunk()
7fff70a9a0b1 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (23f2adafa00): SELECT
Connection ID (thread ID): 815
Status: NOT_KILLED
The manual page at MySQL :: MySQL 8.1 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing (http://dev.mysql.com/doc/mysql/en/crashing.html) contains
information that should help you find out what is causing the crash.
2023-10-20T20:11:50.585738Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-10-20T20:11:50.585955Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-10-20T20:11:50.585973Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 6052
2023-10-20T20:11:50.633534Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-20T20:11:51.956229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-20T20:11:52.468492Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-10-20T20:11:52.473848Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-10-20T20:11:52.737069Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-10-20T20:11:52.737351Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-20T20:11:52.799486Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-10-20T20:11:52.799597Z 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-10-21T00:03:01.719910Z 467 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:1338:index->id == btr_page_get_index_id(page) thread 3872
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to MySQL Bugs (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: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery (http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html)
InnoDB: about forcing recovery.
2023-10-21T00:03:01Z UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x1e4d7cc0ac0
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...
7ff712dafa68 mysqld_z.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff711f39411 mysqld_z.exe!?print_fatal_signal@@YAXH@Z()
7ff711f39153 mysqld_z.exe!?my_server_abort@@YAXXZ()
7ff712d93a7a mysqld_z.exe!?my_abort@@YAXXZ()
7ff712fec7f9 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()
7ff712fc33d7 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()
7ff713050b5c 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()
7ff713076c32 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()
7ff712e79cc1 mysqld_z.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff711d22042 mysqld_z.exe!?ha_index_read_map@handler@@QEAAHPEAEPEBEKW4ha_rkey_function@@@Z()
7ff71202f330 mysqld_z.exe!?read_const@@YAHPEAUTABLE@@PEAUTABLE_REF@@@Z()
7ff71202edcf mysqld_z.exe!?join_read_const_table@@YAHPEAVJOIN_TAB@@PEAUPOSITION@@@Z()
7ff711f7e5ac mysqld_z.exe!?extract_func_dependent_tables@JOIN@@AEAA_NXZ()
7ff711f80ff5 mysqld_z.exe!?make_join_plan@JOIN@@AEAA_NXZ()
7ff711f832d4 mysqld_z.exe!?optimize@JOIN@@QEAA_N_N@Z()
7ff711ff7f19 mysqld_z.exe!?optimize@Query_block@@QEAA_NPEAVTHD@@_N@Z()
7ff712098cc3 mysqld_z.exe!?optimize@Query_expression@@QEAA_NPEAVTHD@@PEAUTABLE@@_N2@Z()
7ff711ff5130 mysqld_z.exe!?execute_inner@Sql_cmd_dml@@MEAA_NPEAVTHD@@@Z()
7ff711ff5012 mysqld_z.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@Z()
7ff711ef276a mysqld_z.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff711eed581 mysqld_z.exe!?dispatch_sql_command@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff711eec2b5 mysqld_z.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff711eed946 mysqld_z.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff711d19178 mysqld_z.exe!?thread_id@THD@@QEBAIXZ()
7ff7133a5b79 mysqld_z.exe!?my_init_dynamic_array@@YA_NPEAUDYNAMIC_ARRAY@@IIPEAXII@Z()
7ff712da05ac mysqld_z.exe!?my_thread_self_setname@@YAXPEBD@Z()
7fff6d53268a ucrtbase.dll!_o_exp()
7fff70487974 KERNEL32.DLL!BaseThreadInitThunk()
7fff70a9a0b1 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1e4d7cad6d0): SELECT
Connection ID (thread ID): 467
Status: NOT_KILLED
The manual page at MySQL :: MySQL 8.1 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing (http://dev.mysql.com/doc/mysql/en/crashing.html) contains
information that should help you find out what is causing the crash.
2023-10-21T00:04:01.687860Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-10-21T00:04:01.688052Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-10-21T00:04:01.688071Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 8904
2023-10-21T00:04:01.712750Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-21T00:04:02.646189Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-21T00:04:03.186446Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-10-21T00:04:03.191679Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-10-21T00:04:03.389209Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-10-21T00:04:03.389988Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-21T00:04:03.448471Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-10-21T00:04:03.448625Z 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-10-20T20:03:22.696358Z 815 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:1338:index->id == btr_page_get_index_id(page) thread 10316
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to MySQL Bugs (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: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery (http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html)
InnoDB: about forcing recovery.
2023-10-20T20:03:22Z UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x23f2b001080
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...
7ff712dafa68 mysqld_z.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff711f39411 mysqld_z.exe!?print_fatal_signal@@YAXH@Z()
7ff711f39153 mysqld_z.exe!?my_server_abort@@YAXXZ()
7ff712d93a7a mysqld_z.exe!?my_abort@@YAXXZ()
7ff712fec7f9 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()
7ff712fc33d7 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()
7ff713050b5c 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()
7ff713076c32 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()
7ff712e79cc1 mysqld_z.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff711d22042 mysqld_z.exe!?ha_index_read_map@handler@@QEAAHPEAEPEBEKW4ha_rkey_function@@@Z()
7ff71202f330 mysqld_z.exe!?read_const@@YAHPEAUTABLE@@PEAUTABLE_REF@@@Z()
7ff71202edcf mysqld_z.exe!?join_read_const_table@@YAHPEAVJOIN_TAB@@PEAUPOSITION@@@Z()
7ff711f7e5ac mysqld_z.exe!?extract_func_dependent_tables@JOIN@@AEAA_NXZ()
7ff711f80ff5 mysqld_z.exe!?make_join_plan@JOIN@@AEAA_NXZ()
7ff711f832d4 mysqld_z.exe!?optimize@JOIN@@QEAA_N_N@Z()
7ff711ff7f19 mysqld_z.exe!?optimize@Query_block@@QEAA_NPEAVTHD@@_N@Z()
7ff712098cc3 mysqld_z.exe!?optimize@Query_expression@@QEAA_NPEAVTHD@@PEAUTABLE@@_N2@Z()
7ff711ff5130 mysqld_z.exe!?execute_inner@Sql_cmd_dml@@MEAA_NPEAVTHD@@@Z()
7ff711ff5012 mysqld_z.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@Z()
7ff711ef276a mysqld_z.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff711eed581 mysqld_z.exe!?dispatch_sql_command@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff711eec2b5 mysqld_z.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff711eed946 mysqld_z.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff711d19178 mysqld_z.exe!?thread_id@THD@@QEBAIXZ()
7ff7133a5b79 mysqld_z.exe!?my_init_dynamic_array@@YA_NPEAUDYNAMIC_ARRAY@@IIPEAXII@Z()
7ff712da05ac mysqld_z.exe!?my_thread_self_setname@@YAXPEBD@Z()
7fff6d53268a ucrtbase.dll!_o_exp()
7fff70487974 KERNEL32.DLL!BaseThreadInitThunk()
7fff70a9a0b1 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (23f2adafa00): SELECT
tables
FROM phpmyadmin
.pma__recent
WHERE username
= 'root'Connection ID (thread ID): 815
Status: NOT_KILLED
The manual page at MySQL :: MySQL 8.1 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing (http://dev.mysql.com/doc/mysql/en/crashing.html) contains
information that should help you find out what is causing the crash.
2023-10-20T20:11:50.585738Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-10-20T20:11:50.585955Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-10-20T20:11:50.585973Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 6052
2023-10-20T20:11:50.633534Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-20T20:11:51.956229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-20T20:11:52.468492Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-10-20T20:11:52.473848Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-10-20T20:11:52.737069Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-10-20T20:11:52.737351Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-20T20:11:52.799486Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-10-20T20:11:52.799597Z 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-10-21T00:03:01.719910Z 467 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0sea.cc:1338:index->id == btr_page_get_index_id(page) thread 3872
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to MySQL Bugs (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: MySQL :: MySQL 8.0 Reference Manual :: 15.21.3 Forcing InnoDB Recovery (http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html)
InnoDB: about forcing recovery.
2023-10-21T00:03:01Z UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x1e4d7cc0ac0
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...
7ff712dafa68 mysqld_z.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff711f39411 mysqld_z.exe!?print_fatal_signal@@YAXH@Z()
7ff711f39153 mysqld_z.exe!?my_server_abort@@YAXXZ()
7ff712d93a7a mysqld_z.exe!?my_abort@@YAXXZ()
7ff712fec7f9 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()
7ff712fc33d7 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()
7ff713050b5c 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()
7ff713076c32 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()
7ff712e79cc1 mysqld_z.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff711d22042 mysqld_z.exe!?ha_index_read_map@handler@@QEAAHPEAEPEBEKW4ha_rkey_function@@@Z()
7ff71202f330 mysqld_z.exe!?read_const@@YAHPEAUTABLE@@PEAUTABLE_REF@@@Z()
7ff71202edcf mysqld_z.exe!?join_read_const_table@@YAHPEAVJOIN_TAB@@PEAUPOSITION@@@Z()
7ff711f7e5ac mysqld_z.exe!?extract_func_dependent_tables@JOIN@@AEAA_NXZ()
7ff711f80ff5 mysqld_z.exe!?make_join_plan@JOIN@@AEAA_NXZ()
7ff711f832d4 mysqld_z.exe!?optimize@JOIN@@QEAA_N_N@Z()
7ff711ff7f19 mysqld_z.exe!?optimize@Query_block@@QEAA_NPEAVTHD@@_N@Z()
7ff712098cc3 mysqld_z.exe!?optimize@Query_expression@@QEAA_NPEAVTHD@@PEAUTABLE@@_N2@Z()
7ff711ff5130 mysqld_z.exe!?execute_inner@Sql_cmd_dml@@MEAA_NPEAVTHD@@@Z()
7ff711ff5012 mysqld_z.exe!?execute@Sql_cmd_dml@@UEAA_NPEAVTHD@@@Z()
7ff711ef276a mysqld_z.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff711eed581 mysqld_z.exe!?dispatch_sql_command@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff711eec2b5 mysqld_z.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff711eed946 mysqld_z.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff711d19178 mysqld_z.exe!?thread_id@THD@@QEBAIXZ()
7ff7133a5b79 mysqld_z.exe!?my_init_dynamic_array@@YA_NPEAUDYNAMIC_ARRAY@@IIPEAXII@Z()
7ff712da05ac mysqld_z.exe!?my_thread_self_setname@@YAXPEBD@Z()
7fff6d53268a ucrtbase.dll!_o_exp()
7fff70487974 KERNEL32.DLL!BaseThreadInitThunk()
7fff70a9a0b1 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1e4d7cad6d0): SELECT
tables
FROM phpmyadmin
.pma__recent
WHERE username
= 'root'Connection ID (thread ID): 467
Status: NOT_KILLED
The manual page at MySQL :: MySQL 8.1 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing (http://dev.mysql.com/doc/mysql/en/crashing.html) contains
information that should help you find out what is causing the crash.
2023-10-21T00:04:01.687860Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-10-21T00:04:01.688052Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-10-21T00:04:01.688071Z 0 [System] [MY-010116] [Server] C:\UniServerZ\core\mysql\bin\mysqld_z.exe (mysqld 8.0.31) starting as process 8904
2023-10-21T00:04:01.712750Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-21T00:04:02.646189Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-21T00:04:03.186446Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-10-21T00:04:03.191679Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-10-21T00:04:03.389209Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-10-21T00:04:03.389988Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-21T00:04:03.448471Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-10-21T00:04:03.448625Z 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.