MySQL Forums
Forum List  »  InnoDB

mysql 8.0.27 went crash
Posted by: y y
Date: April 19, 2022 07:09PM

Hello, when I use mysql 8.0.27, it went crash.The error message is as follow. I met the crash of mysql 8.0.27 more than 10 times in this month。I wonder what can I do to deal this problem. Anyone offers any help, we are very grateful。

2022-04-19T06:37:49.539128Z 4488 [ERROR] [MY-010934] [Server] Out of memory (Needed 1062928 bytes)
2022-04-19T06:37:49.618125Z 4488 [ERROR] [MY-010934] [Server] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
2022-04-19T06:37:49.619147Z 4488 [ERROR] [MY-010934] [Server] Out of memory (Needed 1062928 bytes)
2022-04-19T06:37:49.619519Z 4488 [ERROR] [MY-010934] [Server] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
08:25:38 UTC - mysqld got exception 0xc0000005 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x20bdadd1d10
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...
7ff7a6a12493 mysqld.exe!temptable::Table::indexes_destroy()[table.cc:280]
7ff7a6a11662 mysqld.exe!temptable::Table::~Table()[table.cc:103]
7ff7a6a0e55a mysqld.exe!temptable::Key_value_store<std::shared_timed_mutex,std::unordered_map>::erase()[kv_store.h:131]
7ff7a6a0e2b8 mysqld.exe!temptable::Handler::delete_table()[handler.cc:161]
7ff7a5984db8 mysqld.exe!close_tmp_table()[sql_tmp_table.cc:2393]
7ff7a5885227 mysqld.exe!QEP_TAB::cleanup()[sql_select.cc:3359]
7ff7a58860a5 mysqld.exe!JOIN::destroy()[sql_select.cc:1690]
7ff7a5900d60 mysqld.exe!Query_block::cleanup()[sql_union.cc:1610]
7ff7a5900f0f mysqld.exe!Query_expression::cleanup()[sql_union.cc:1379]
7ff7a577901c mysqld.exe!mysql_execute_command()[sql_parse.cc:4722]
7ff7a5773b91 mysqld.exe!dispatch_sql_command()[sql_parse.cc:5137]
7ff7a5772996 mysqld.exe!dispatch_command()[sql_parse.cc:1926]
7ff7a5773e8f mysqld.exe!do_command()[sql_parse.cc:1344]
7ff7a55ca0c8 mysqld.exe!handle_connection()[connection_handler_per_thread.cc:302]
7ff7a698d1cf mysqld.exe!pfs_spawn_thread()[pfs.cc:2949]
7ff7a657244c mysqld.exe!win_thread_start()[my_thread.cc:74]
7ff9fcd9f4a0 ucrtbase.dll!_o__realloc_base()
7ff9ff8884d4 KERNEL32.DLL!BaseThreadInitThunk()
7ffa006ee851 ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (20c0475f8b8): SELECT

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 8.0.27 went crash
642
y y
April 19, 2022 07:09PM
278
April 19, 2022 10:58PM
244
y y
April 20, 2022 01:41AM
228
y y
April 20, 2022 01:50AM
259
April 20, 2022 10:19AM
249
y y
April 20, 2022 06:20PM
258
April 20, 2022 06:53PM
218
y y
April 23, 2022 06:52PM
236
April 25, 2022 12:22AM
233
April 25, 2022 05:50AM
246
April 25, 2022 09:48AM
226
y y
April 25, 2022 08:36PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.