Error: ER_CANT_CREATE_THREAD: Can't create a new thread (errno 11);
Posted by:
Tuong Lau
Date: December 12, 2020 04:33AM
When the server A connected to two seperate mysqldb servers B and C. The server A reported the errors as follow:
Error: ER_CANT_CREATE_THREAD: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug at Handshake.Sequence._packetToError (/home/abc/workspace/node_modules/my$ at Handshake.ErrorPacket (/home/abc/workspace/node_modules/mysql/lib/prot$ at Protocol._parsePacket (/home/abc/workspace/node_modules/mysql/lib/prot$ at Parser._parsePacket (/home/abc/workspace/node_modules/mysql/lib/prot
RAM configuration for mysql db server B and C is 192GB, Ubuntu 18.04.3 LTS Server, mysql 8, and its mysqld.cnf file configured as: max_connections = 100000 innodb_buffer_pool_size = 20G tmp_table_size = 1G max_heap_table_size = 1G read_rnd_buffer_size = 1G thread_cache_size = 100000 open_files_limit = 1000000 table_definition_cache = 40096 table_open_cache = 1000000
Someone has any idea for this problem. Many thanks!
Subject
Written By
Posted
Error: ER_CANT_CREATE_THREAD: Can't create a new thread (errno 11);
December 12, 2020 04:33AM
December 14, 2020 11:52AM
Sorry, you can't reply to this topic. It has been closed.
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.