You had maxActive=500 ?
The default provided with the standard conf file is 200
In another site experiencing the same problem we suggested to set:
a) in /etc/my.cnf: max_connections=650
b) in /etc/tomcat5/Catalina/localhost/ce-cream.xml:
<Resource name="jdbc/dlg"
...
...
maxActive="300"
...
...
<Resource name="jdbc/creamdb"
...
...
maxActive="300"
Then it is needed to restart both mysql and tomcat
Hope this helps
Cheers, Massimo
On Thu, 23 Jun 2011, Stephane GERARD wrote:
> 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
>
\|||/
-----------0oo----( o o )----oo0-------------------
(_)
INFN Sezione di Padova
Via Marzolo, 8
35131 Padova - Italy E-mail: massimo.sgaravatto [at] pd.infn.it
Tel: ++39 0499677360 Skype: massimo.sgaravatto
Fax: ++39 0498275952
