Hi Nils Thanks for your information. We've tried it that way and seems working better.
Regards, JC From: Nils Breunese <[email protected]> To: Magnolia User-List <[email protected]> Date: 03.01.2013 11:31 Subject: Re: [magnolia-user] Magnolia + MySQL / Connection errors Sent by: <[email protected]> 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]> ---------------------------------------------------------------- ---------------------------------------------------------------- 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]> ----------------------------------------------------------------
