I have deployed a ClickHouse cluster using an operator with 3 shards and 3 replicas. It is up and running. However, when I perform schema creation, at some point it throws the following error:
Example:
Error occurred during SQL script execution
Reason:
SQL Error [573] [07000]: Code: 573. DB::ErrnoException: Cannot open epoll descriptor: , errno: 24, strerror: Too many open files. (EPOLL_ERROR) (version 24.4.4.105 (official build))
, server ClickHouseNode [uri=http://10.10.50.61:81/default, options={socket_timeout=75000,use_server_time_zone=false,use_time_zone=false}]@651464263
This is due to a “too many open files” error. I have tried using init containers and ConfigMap to run the script to set ulimit inside the pods. Unfortunately, these methods have not resolved the issue.
Can someone please help me resolve the “too many open files” issue?