Unable to generate usage data with SQL exception 

 
 
 
 
Issue:
 
Unable to generate usage data with below exception:
 
ERROR [db.Transaction.Transaction] (Usage-HB-1:null) (logid: Unexpected exception: 
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 
 
Cause:

If there is no configuration for mysql user, default value will come into effect, which is 1024. With 1024 open file limit mysql can manage upto 214 connections. Even if the max_connections is configured 2100 (my.cnf), it will be ignored.

Resolution:

To address this issue we need to adjust max_connections and open files accordingly.

Please update the file /etc/security/limits.conf in MySQL server with configuration below:

mysql hard nofile 8192
mysql soft nofile 8192

Please update the file my.cnf in MySQL server with configuration below:

[mysqld]
open_files_limit = 8192
max_connections = 1500

 

 
Have more questions? Submit a request

Comments

 
Adding comment, please wait....

Provide Feedback on Article:

Subject:
Comments:*