Page 1 of 1

Too many connections Error

Posted: Sat Oct 27, 2012 8:14 am
by senthilcse
Hi,

after restarting openemm.sh i got following error
An error occurred

Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (Data source rejected establishment of connection, message from server: "Too many connections"); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Data source rejected establishment of connection, message from server: "Too many connections")

Please help to reslove this problem

Re: Too many connections Error

Posted: Sun Oct 28, 2012 4:01 pm
by maschoff
Maybe the limit of connections for your MySQL installation is already eaten up by other applications using the database? In this case you should increase the maximum value for DB connections in your DB configuration.

Re: Too many connections Error

Posted: Mon Oct 29, 2012 11:45 am
by senthilcse
Hi,

Thanks for Reply
I increased the max connection from 100 to 500 then restarted mysql and openemm.But there is no improvement.I will get same "Tooo Many Connections" Error
and also i got...
Error coneecting to master at "ipaddress@host" Mysql ERROR[0] Too many connections error in mysqld.log file
Please help me........

Thanks
Senthil