Hello,
We are using Magnolia CE 4.5.7 together with MySQL (via JNDI on Tomcat
7.x). Basically everything works fine.
However after a while the database connection seems to become inactive.
When trying to activate content or do some other actions the requests take
quite long and the console log shows something like the following
error/warning.
bit.core.persistence.db.DatabasePersistenceManager: execute failed, about
to reconnect...
After some retries the connection comes back. Beside the unnecessary delay
sometimes the activation requests failes - as running too long.
The JNDI resource is configured the following way.
<Resource auth="Container" name="jdbc/???DS"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/???"
maxActive="100" maxIdle="30" maxWait="10000"
testOnBorrow="true"
minEvictableIdleTimeMillis="21600000"
timeBetweenEvictionRunsMillis="1800000" numTestsPerEviction="-1"
username="????" password="????"/>
Any idea what we may do wrong or what values should be used for JNDI or
direct MySQL configuration.
Thanks,
Jan Christian
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
