Dear Experts,
Almost all the jobs reaching our site abort. Looking
at /var/log/glite/glite-ce-cream.log, we see a lot of error messages of
this kind :
---------
23 Jun 2011 14:19:37,037 org.glite.ce.cream.cmdmanagement.CommandManager
- CommandManager insertCommand: JOB_REGISTER error
org.glite.ce.common.db.DatabaseException: getConnection error: Too many
connections
23 Jun 2011 14:19:37,038 org.glite.ce.common.db.DatasourceManager - Too
many connections
23 Jun 2011 14:19:37,038
org.glite.ce.creamapi.jobmanagement.cmdexecutor.AbstractJobExecutor -
getConnection error: Too many connections
org.glite.ce.common.db.DatabaseException: getConnection error: Too many
connections
at
org.glite.ce.common.db.DatasourceManager.getConnection(DatasourceManager.java:107)
at
org.glite.ce.cream.jobmanagement.db.JobDBManager.executeSelectJobLease(JobDBManager.java:182)
at
org.glite.ce.cream.jobmanagement.db.JobDBImplementation.retrieveJobLease(JobDBImplementation.java:347)
at
org.glite.ce.creamapi.jobmanagement.cmdexecutor.AbstractJobExecutor.jobRegister(AbstractJobExecutor.java:1781)
at
org.glite.ce.creamapi.jobmanagement.cmdexecutor.AbstractJobExecutor.execute(AbstractJobExecutor.java:630)
at
org.glite.ce.cream.cmdmanagement.CommandManager.insertCommand(CommandManager.java:376)
at
org.glite.ce.cream.ws.CREAM2Service.jobRegister(CREAM2Service.java:1079)
...
23 Jun 2011 14:19:37,039 org.glite.ce.cream.cmdmanagement.CommandManager
- CommandManager insertCommand: JOB_REGISTER error
org.glite.ce.common.db.DatabaseException: getConnection error: Too many
connections
---------
Since this seems to be related to the number of connexions to the mysql
DBs, we have tried to increase maxActive parameters from 500 to 750
in /usr/share/tomcat5/conf/Catalina/localhost/ce-cream.xml, but it
doesn't improve the situation.
Our cream version is :
----------
glite-ce-cream-1.12.4-2
----------
Cheers,
Stéphane
|