Thanks for the pointer. We are using a much later version of Resin than that bug was marked as fixed for, so I'm not sure if that's our problem. We'll give the increased timeout a shot, though.
On Fri, Apr 9, 2010 at 2:06 AM, Jan Haderka <[email protected]>wrote: > > Seeing this http://bugs.caucho.com/view.php?id=1137 > I'd guess your problem might be timeout as well. JackRabbit is using > long living connections and you are right that with Bundle PM it should > be also able to reconnect. Nevertheless I'd try to increase timeout on > MySQL and also check if you pool has some default timeout and is not > killing connections after while. > > HTH, > Jan > > > On Thu, 2010-04-08 at 14:01 -0400, Miranda Jones wrote: > > Hello all, > > > > We are running Magnolia 4.3.1 on Resin using MySQL for Jackrabbit. > > Our database configuration is in the Resin config set up as a JNDI > > DataSource. Everything runs fine until the site has been idle for a > > while, and then we run into connection failures with the database. It > > is my understanding that the bundle persistence manager is supposed to > > reconnect things, but it seems like that is not happening properly. > > We need to restart the site to get things to work again. > > > > Does the error below look familiar to anyone or anyone have a > > suggestion how we might fix this? > > > > Our database node in the Resin config is set up like this: > > > > <database> > > <jndi-name>java:comp/env/jdbc/foo</jndi-name> > > <driver type="com.mysql.jdbc.Driver"> > > <url>jdbc:mysql://localhost/foo</url> > > <user>foo</user> > > <password>bar</password> > > </driver> > > <max-connections>100</max-connections> > > <ping>true</ping> > > <ping-table>CONFIG_BINVAL</ping-table> > > </database> > > > > Normally, on all our other sites, we would set up the database driver > > with com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource, and > > in fact I did on this one, but then after reading the wiki > > documentation and noticing all the examples used > > com.mysql.jdbc.Driver, and seeing somewhere (I can't remember if it > > was on the Magnolia or Jackrabbit wiki) that connection pools > > shouldn't be used, I switched it, trying to fix the issue. It is > > still happening, though. > > > > After a while, we see the following stack trace (and similar ones) > > many many times: > > > > ERROR org.apache.jackrabbit.core.RepositoryImpl 06.04.2010 10:27:24 > > -- error while closing persistence manager of workspace mgnlSystem > > java.lang.NullPointerException > > at > > com.caucho.sql.UserConnection.getAutoCommit(UserConnection.java:616) > > at > > > org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.close(ConnectionRecoveryManager.java:314) > > at > > > org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.close(BundleDbPersistenceManager.java:1002) > > at org.apache.jackrabbit.core.RepositoryImpl > > $WorkspaceInfo.doDispose(RepositoryImpl.java:2124) > > at org.apache.jackrabbit.core.RepositoryImpl > > $WorkspaceInfo.dispose(RepositoryImpl.java:2069) > > at > > > org.apache.jackrabbit.core.RepositoryImpl.doShutdown(RepositoryImpl.java:1131) > > at > > > org.apache.jackrabbit.core.RepositoryImpl.shutdown(RepositoryImpl.java:1081) > > at > > > org.apache.jackrabbit.core.jndi.BindableRepository.shutdown(BindableRepository.java:242) > > at > > > org.apache.jackrabbit.core.jndi.RegistryHelper.unregisterRepository(RegistryHelper.java:94) > > at > > > info.magnolia.jackrabbit.ProviderImpl.shutdownRepository(ProviderImpl.java:238) > > at > > > info.magnolia.cms.beans.config.ContentRepository.shutdown(ContentRepository.java:205) > > at > > info.magnolia.cms.beans.config.ConfigLoader.unload(ConfigLoader.java:86) > > at info.magnolia.cms.servlets.MgnlServletContextListener > > $1.doExec(MgnlServletContextListener.java:165) > > at info.magnolia.context.MgnlContext > > $VoidOp.exec(MgnlContext.java:433) > > at info.magnolia.context.MgnlContext > > $VoidOp.exec(MgnlContext.java:431) > > at > > info.magnolia.context.MgnlContext.doInSystemContext(MgnlContext.java:396) > > at > > > info.magnolia.cms.servlets.MgnlServletContextListener.contextDestroyed(MgnlServletContextListener.java:163) > > at com.caucho.server.webapp.WebApp.stop(WebApp.java:2773) > > at com.caucho.server.webapp.WebApp.destroy(WebApp.java:2797) > > at > > > com.caucho.server.deploy.DeployController.stopImpl(DeployController.java:750) > > at > > > com.caucho.server.deploy.AbstractDeployControllerStrategy.stop(AbstractDeployControllerStrategy.java:77) > > at > > com.caucho.server.deploy.DeployController.stop(DeployController.java:571) > > at > > com.caucho.server.deploy.DeployContainer.stop(DeployContainer.java:380) > > at > > com.caucho.server.webapp.WebAppContainer.stop(WebAppContainer.java:1111) > > at com.caucho.server.host.Host.stop(Host.java:559) > > at com.caucho.server.host.Host.destroy(Host.java:576) > > at > > > com.caucho.server.deploy.DeployController.stopImpl(DeployController.java:750) > > at > > > com.caucho.server.deploy.AbstractDeployControllerStrategy.stop(AbstractDeployControllerStrategy.java:77) > > at > > com.caucho.server.deploy.DeployController.stop(DeployController.java:571) > > at > > com.caucho.server.deploy.DeployContainer.stop(DeployContainer.java:380) > > at > > com.caucho.server.host.HostContainer.stop(HostContainer.java:495) > > at com.caucho.server.cluster.Server.stop(Server.java:1649) > > at com.caucho.server.cluster.Server.destroy(Server.java:1671) > > at com.caucho.server.resin.Resin.destroy(Resin.java:817) > > at com.caucho.server.resin.Resin > > $DestroyThread.run(Resin.java:1787) > > > > > > Thanks, > > Miranda > > > > -- > > Miranda Jones > > Objective Consulting, Inc. > > http://www.spiders.com > > > ---------------------------------------------------------------- > For list details see > http://www.magnolia-cms.com/home/community/mailing-lists.html > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > > -- Miranda Jones Objective Consulting, Inc. http://www.spiders.com ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
