日志是這樣的,有沒有大神幫忙看下是怎么回事啊?
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.
2020-10-30T04:15:03.766909Z 0 [System] [MY-010116] [Server] D:\MySql\bin\mysqld (mysqld 8.0.19) starting as process 9108
2020-10-30T04:15:04.821867Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-30T04:15:04.827559Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-30T04:15:04.912168Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-30T04:15:05.642703Z 0 [System] [MY-010931] [Server] D:\MySql\bin\mysqld: ready for connections. Version: '8.0.19' socket: '' port: 3306 MySQL Community Server - GPL.
2020-10-30T04:15:05.802738Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
04:19:04 UTC - mysqld got exception 0x80000003 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x29b653b6a90
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...
7ff786bd60d2 mysqld.exe!my_sigabrt_handler()[my_thr_init.cc:372]
7ff9c22fe19d ucrtbase.dll!raise()
7ff9c22ff071 ucrtbase.dll!abort()
7ff78700fada mysqld.exe!temptable::Cursor::export_row_to_mysql()[cursor.h:185]
7ff7870100ac mysqld.exe!temptable::Handler::index_read()[handler.cc:479]
7ff785d72a06 mysqld.exe!handler::ha_index_read_map()[handler.cc:3228]
7ff78616779a mysqld.exe!end_update()[sql_executor.cc:7566]
7ff78616ddfa mysqld.exe!sub_select_op()[sql_executor.cc:3277]
7ff7861b70b5 mysqld.exe!JOIN_CACHE::generate_full_extensions()[sql_join_buffer.cc:2070]
7ff7861b811c mysqld.exe!JOIN_CACHE_BNL::join_matching_records()[sql_join_buffer.cc:1967]
7ff7861b845e mysqld.exe!JOIN_CACHE::join_records()[sql_join_buffer.cc:1785]
7ff78616ddfa mysqld.exe!sub_select_op()[sql_executor.cc:3277]
7ff78616871f mysqld.exe!evaluate_join_record()[sql_executor.cc:3895]
7ff78616dc9f mysqld.exe!sub_select()[sql_executor.cc:3555]
7ff78616674a mysqld.exe!do_select()[sql_executor.cc:3151]
7ff786168d64 mysqld.exe!JOIN::exec()[sql_executor.cc:336]
7ff78608b686 mysqld.exe!SELECT_LEX_UNIT::execute()[sql_union.cc:1651]
7ff7860f4be2 mysqld.exe!TABLE_LIST::materialize_derived()[sql_derived.cc:822]
7ff786169352 mysqld.exe!join_materialize_derived()[sql_executor.cc:4829]
7ff78616a111 mysqld.exe!QEP_TAB::prepare_scan()[sql_executor.cc:3608]
7ff78616da29 mysqld.exe!sub_select()[sql_executor.cc:3437]
7ff78616674a mysqld.exe!do_select()[sql_executor.cc:3151]
7ff786168d64 mysqld.exe!JOIN::exec()[sql_executor.cc:336]
7ff78608b544 mysqld.exe!SELECT_LEX_UNIT::execute()[sql_union.cc:1632]
7ff786006083 mysqld.exe!Sql_cmd_dml::execute_inner()[sql_select.cc:910]
7ff786005e26 mysqld.exe!Sql_cmd_dml::execute()[sql_select.cc:718]
7ff785f12d71 mysqld.exe!mysql_execute_command()[sql_parse.cc:4603]
7ff785f139c4 mysqld.exe!mysql_parse()[sql_parse.cc:5290]
7ff785f0cb60 mysqld.exe!dispatch_command()[sql_parse.cc:1781]
7ff785f0dade mysqld.exe!do_command()[sql_parse.cc:1276]
7ff785d8cfc8 mysqld.exe!handle_connection()[connection_handler_per_thread.cc:302]
7ff786f987a1 mysqld.exe!pfs_spawn_thread()[pfs.cc:2857]
7ff786bd606c mysqld.exe!win_thread_start()[my_thread.cc:53]
7ff9c22b03ba ucrtbase.dll!_o_exp()
7ff9c5117e94 KERNEL32.DLL!BaseThreadInitThunk()
7ff9c6047ad1 ntdll.dll!RtlUserThreadStart()
uj5u.com熱心網友回復:
這是宕機了。1、更新下版本吧。如果還不行,祈禱下一個版本。
2、修改下SQL, 這個具體的。。。 看你運氣。
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/196164.html
標籤:MySQL
上一篇:MySQL 組合索引
下一篇:作業
