Home > database >  Mysql always stop in the middle of the statement execution services
Mysql always stop in the middle of the statement execution services

Time:11-01

Log is such, have a great god help to see what's going on?


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.
The 2020-10-30 T04:15:03. 766909 z 0 [System] [MY - 010116] [Server] D: \ MySql \ bin \ mysqld (mysqld 8.0.19) starting as process 9108
The 2020-10-30 T04:15:04. 821867 z 0 [System] [MY - 010229] [Server] Starting XA crash recovery...
The 2020-10-30 T04:15:04. 827559 z 0 [System] [MY - 010232] (Server) XA crash recovery finished.
The 2020-10-30 T04:15:04. 912168 z 0 [Warning] [MY - 010068] [Server] CA certificate CA. Pem is self signed.
T04:2020-10-30 sets. The 642703 z 0 [System] [MY - 010931] [Server] D: \ MySql \ bin \ mysqld: ready for connections. Version: '8.0.19 sockets:' port: 3306 MySql Community Server - the GPL.
The T04:2020-10-30 sets. The 802738 z 0 [System] [MY - 011323] (Server) X Plugin ready for connections. The Bind - address: ':' port: 33060
04:19:04 UTC - mysqld got exception 0 x80000003;
Most likely, you have hit a bug, but this error can also be under caused by malfunctioning hardware.
Thread pointer: 0 x29b653b6a90
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...
7 ff786bd60d2 mysqld. Exe! My_sigabrt_handler () [my_thr_init. Cc: 372]
7 ff9c22fe19d ucrtbase DLL! Raise ()
7 ff9c22ff071 ucrtbase DLL! Abort ()
7 ff78700fada mysqld. Exe! Temptable: : Cursor: : export_row_to_mysql ()/Cursor. H: 185
7 ff7870100ac mysqld. Exe! Temptable: : Handler: : index_read ()/Handler. Cc: 479
7 ff785d72a06 mysqld. Exe! Handler: : ha_index_read_map () [handler. Cc: 3228]
7 ff78616779a mysqld. Exe! End_update () [sql_executor. Cc: 7566]
7 ff78616ddfa mysqld. Exe! Sub_select_op () [sql_executor. Cc: 3277]
7 ff7861b70b5 mysqld. Exe! JOIN_CACHE: : generate_full_extensions () [sql_join_buffer. Cc: 2070]
7 ff7861b811c mysqld. Exe! JOIN_CACHE_BNL: : join_matching_records () [sql_join_buffer. Cc: 1967]
7 ff7861b845e mysqld. Exe! JOIN_CACHE: : join_records () [sql_join_buffer. Cc: 1785]
7 ff78616ddfa mysqld. Exe! Sub_select_op () [sql_executor. Cc: 3277]
7 ff78616871f mysqld. Exe! Evaluate_join_record () [sql_executor. Cc: 3895]
7 ff78616dc9f mysqld. Exe! Sub_select () [sql_executor. Cc: 3555]
7 ff78616674a mysqld. Exe! Do_select () [sql_executor. Cc: 3151]
7 ff786168d64 mysqld. Exe! The JOIN: : exec () [sql_executor. Cc: 336]
7 ff78608b686 mysqld. Exe! SELECT_LEX_UNIT: : execute () [sql_union. Cc: 1651]
7 ff7860f4be2 mysqld. Exe! TABLE_LIST: : materialize_derived () [sql_derived. Cc: 822]
7 ff786169352 mysqld. Exe! Join_materialize_derived () [sql_executor. Cc: 4829]
7 ff78616a111 mysqld. Exe! QEP_TAB: : prepare_scan () [sql_executor. Cc: 3608]
7 ff78616da29 mysqld. Exe! Sub_select () [sql_executor. Cc: 3437]
7 ff78616674a mysqld. Exe! Do_select () [sql_executor. Cc: 3151]
7 ff786168d64 mysqld. Exe! The JOIN: : exec () [sql_executor. Cc: 336]
7 ff78608b544 mysqld. Exe! SELECT_LEX_UNIT: : execute () [sql_union. Cc: 1632]
7 ff786006083 mysqld. Exe! Sql_cmd_dml: : execute_inner () [sql_select. Cc: 910]
7 ff786005e26 mysqld. Exe! Sql_cmd_dml: : execute () [sql_select. Cc: 718]
7 ff785f12d71 mysqld. Exe! Mysql_execute_command () [sql_parse. Cc: 4603]
7 ff785f139c4 mysqld. Exe! Mysql_parse () [sql_parse. Cc: 5290]
7 ff785f0cb60 mysqld. Exe! Dispatch_command () [sql_parse. Cc: 1781]
7 ff785f0dade mysqld. Exe! Do_command () [sql_parse. Cc: 1276]
7 ff785d8cfc8 mysqld. Exe! The handle_connection () [connection_handler_per_thread. Cc: 302]
7 ff786f987a1 mysqld. Exe! Pfs_spawn_thread () [PFS. Cc: 2857]
7 ff786bd606c mysqld. Exe! Win_thread_start () [53] my_thread. Cc:
7 ff9c22b03ba ucrtbase DLL! _o_exp ()
7 ff9c5117e94 KERNEL32. DLL! BaseThreadInitThunk ()
7 ff9c6047ad1 NTDLL. DLL! RtlUserThreadStart ()

CodePudding user response:

This is down,
1, update the version, if not yet, pray for the next version,
2, change the SQL, the concrete,,, see you luck,
  • Related