Hi Magnolians
I have a setup with Magnolia CE 3.5.2 on Tomcat and Mysql. I am using
the PooledJNDIDatabasePersistencemanager to connect to the Database, as
suggested in the WIKI.
After a while of operation, the users cannot log into magnolia anymore.
A Tomcat restart enables them to log in again. The error below can be
found in the logfiles, and seems to be the Problem:
ERROR
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager
12.02.2008 09:44:21 -- failed to write property state:
51ae3379-67cf-4994-9e05-f97cb8bc3e4a/{}lastaccess
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection,
pool error Timeout waiting for idle object
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataS
ource.java:104)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
e.java:880)
at
com.iorga.jackrabbit.core.persistence.db.PooledJNDIDatabasePersistenceMa
nager.getLazzyConnection(PooledJNDIDatabasePersistenceManager.java:256)
...
...
...
I googled for the Error and found some hints in a tomcat forum:
One users solved this problem by setting in the datasource:
maxActive="-1" //means unlimited active connections
The mentioned user seemed happy with this solution, however I guess the
real problem is a "connection leak" in the persistence manager, and
setting maxActive="-1" would just postpone the problem until all memory
is used by tomcat..
What do you think?
Cheers
Claudio
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
