MySQL Forums
Forum List  »  Connector/Node.js

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!

Options: ReplyQuote


Subject
Written By
Posted
Error: ER_CANT_CREATE_THREAD: Can't create a new thread (errno 11);
December 12, 2020 04:33AM


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.