Jan Christian Haddorp wrote: > 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.
http://wiki.magnolia-cms.com/display/WIKI/Magnolia+CMS+with+MySQL#MagnoliaCMSwithMySQL-BundlepersistencemanagerwithJNDI suggests you increase the wait_timeout and interactive_timeout values in your MySQL server. Have you done this? Nils. ---------------------------------------------------------------- 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]> ----------------------------------------------------------------
