Hi Claudio, Actually, by looking at your stacktrace, it's sure : you are not currently using our DataSourcePersistanceManager ! So be sure that magnolia reads your modified jackrabbit-mysql-search.xml instead of the default one. Don't forget to configure jackrabbit-mysql-search.xml and to create the DataSource in Tomcat (or your application container). Re-read the mail I posted previously ... perhaps I should edit the wiki for the mysql topic, and add our DataSourcePersistanceManager solution ...
Anthony On Tue, 7 Nov 2006 10:12:27 +0100, "Claudio Greuter" <[email protected]> wrote: > > Hello Anthony, > > As I wrote yesterday I successfully set up maghnolia on Mysql using your > persistence manager. I let it run for a day to see if the problem I had > was gone, but today morning I had the same issue again: > > I cannot login to the admin central, because it seems that the user data > cannot be loaded due to a mysql connection problem. I managed to > reproduce it by: > 1 stopping the mysql server > 2. trying to log in > 3. restarting mysql server and try to log in again > > After this I see some strange exceptions, telling me that the mysql > connection failed. > > What really makes me curious is that I find the class > simpleDbPersistenceManager in the exception stacktrace, although I > adjusted the configurazion to use your JAR > > <Snippet> > org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager.exists(Si > mpleDbPersistenceManager.java:827) > <Snippet> > > I don't know what is still using the SimpleDBPersistenceManager. > > Below I post the full stack trace of the exception, if you want to take > a look. Sorry that this makes the Mail huge, but I don't know a better > way to share the stacktrace. > > Thanks&Cheers > > Claudio > > > > ERROR org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager > 07.11.2006 09:57:52 -- failed to check existence of node state: > 51ae3379-67cf-4994-9e05-f97cb8bc3e4a > com.mysql.jdbc.CommunicationsException: Communications link failure due > to underlying exception: > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFException > > STACKTRACE: > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934) > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) > at > com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState > ment.java:1129) > at > com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta > tement.java:681) > at > com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:803) > at > org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager.exists(Si > mpleDbPersistenceManager.java:827) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.hasNonVirtualIte > mState(SharedItemStateManager.java:811) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(Sha > redItemStateManager.java:244) > at > org.apache.jackrabbit.core.state.LocalItemStateManager.hasItemState(Loca > lItemStateManager.java:171) > at > org.apache.jackrabbit.core.state.XAItemStateManager.hasItemState(XAItemS > tateManager.java:261) > at > org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(Se > ssionItemStateManager.java:126) > at > org.apache.jackrabbit.core.ItemManager.createItemInstance(ItemManager.ja > va:462) > at > org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:320) > at > org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2372) > at info.magnolia.cms.core.Content.<init>(Content.java:109) > at > info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java > :253) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.isValidUser(JCRAuthent > icationModule.java:118) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.login(JCRAuthenticatio > nModule.java:72) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.access$000(Unknown > Source) > at javax.security.auth.login.LoginContext$4.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.login.LoginContext.invokePriv(Unknown > Source) > at javax.security.auth.login.LoginContext.login(Unknown Source) > at > info.magnolia.cms.security.Authenticator.authenticate(Authenticator.java > :114) > at > info.magnolia.cms.security.SecurityFilter.authenticate(SecurityFilter.ja > va:145) > at > info.magnolia.cms.security.SecurityFilter.isAllowed(SecurityFilter.java: > 119) > at > info.magnolia.cms.security.SecurityFilter.doFilter(SecurityFilter.java:9 > 5) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MultipartRequestFilter.doFilter(MultipartReque > stFilter.java:80) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MgnlVirtualUriFilter.doFilter(MgnlVirtualUriFi > lter.java:83) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.ContentTypeFilter.doFilter(ContentTypeFilter.j > ava:66) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MagnoliaManagedFilter.doFilter(MagnoliaManaged > Filter.java:71) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica > tionFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java > :126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java > :105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 > 48) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j > ava:833) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce > ss(Http11AprProtocol.java:639) > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285) > at java.lang.Thread.run(Unknown Source) > > > ** END NESTED EXCEPTION ** > > > > Last packet sent to the server was 16 ms ago. > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2592) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) > at > com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState > ment.java:1129) > at > com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta > tement.java:681) > at > com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:803) > at > org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager.exists(Si > mpleDbPersistenceManager.java:827) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.hasNonVirtualIte > mState(SharedItemStateManager.java:811) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(Sha > redItemStateManager.java:244) > at > org.apache.jackrabbit.core.state.LocalItemStateManager.hasItemState(Loca > lItemStateManager.java:171) > at > org.apache.jackrabbit.core.state.XAItemStateManager.hasItemState(XAItemS > tateManager.java:261) > at > org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(Se > ssionItemStateManager.java:126) > at > org.apache.jackrabbit.core.ItemManager.createItemInstance(ItemManager.ja > va:462) > at > org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:320) > at > org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2372) > at info.magnolia.cms.core.Content.<init>(Content.java:109) > at > info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java > :253) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.isValidUser(JCRAuthent > icationModule.java:118) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.login(JCRAuthenticatio > nModule.java:72) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.access$000(Unknown > Source) > at javax.security.auth.login.LoginContext$4.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.login.LoginContext.invokePriv(Unknown > Source) > at javax.security.auth.login.LoginContext.login(Unknown Source) > at > info.magnolia.cms.security.Authenticator.authenticate(Authenticator.java > :114) > at > info.magnolia.cms.security.SecurityFilter.authenticate(SecurityFilter.ja > va:145) > at > info.magnolia.cms.security.SecurityFilter.isAllowed(SecurityFilter.java: > 119) > at > info.magnolia.cms.security.SecurityFilter.doFilter(SecurityFilter.java:9 > 5) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MultipartRequestFilter.doFilter(MultipartReque > stFilter.java:80) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MgnlVirtualUriFilter.doFilter(MgnlVirtualUriFi > lter.java:83) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.ContentTypeFilter.doFilter(ContentTypeFilter.j > ava:66) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MagnoliaManagedFilter.doFilter(MagnoliaManaged > Filter.java:71) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica > tionFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java > :126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java > :105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 > 48) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j > ava:833) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce > ss(Http11AprProtocol.java:639) > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285) > at java.lang.Thread.run(Unknown Source) > ERROR info.magnolia.jaas.sp.jcr.JCRAuthenticationModule 07.11.2006 > 09:57:52 -- Unable to locate user [superuser], authentication failed due > to a javax.jcr.ItemNotFoundException > javax.jcr.ItemNotFoundException: 51ae3379-67cf-4994-9e05-f97cb8bc3e4a > at > org.apache.jackrabbit.core.ItemManager.createItemInstance(ItemManager.ja > va:464) > at > org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:320) > at > org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2372) > at info.magnolia.cms.core.Content.<init>(Content.java:109) > at > info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java > :253) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.isValidUser(JCRAuthent > icationModule.java:118) > at > info.magnolia.jaas.sp.jcr.JCRAuthenticationModule.login(JCRAuthenticatio > nModule.java:72) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.invoke(Unknown Source) > at javax.security.auth.login.LoginContext.access$000(Unknown > Source) > at javax.security.auth.login.LoginContext$4.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.login.LoginContext.invokePriv(Unknown > Source) > at javax.security.auth.login.LoginContext.login(Unknown Source) > at > info.magnolia.cms.security.Authenticator.authenticate(Authenticator.java > :114) > at > info.magnolia.cms.security.SecurityFilter.authenticate(SecurityFilter.ja > va:145) > at > info.magnolia.cms.security.SecurityFilter.isAllowed(SecurityFilter.java: > 119) > at > info.magnolia.cms.security.SecurityFilter.doFilter(SecurityFilter.java:9 > 5) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MultipartRequestFilter.doFilter(MultipartReque > stFilter.java:80) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MgnlVirtualUriFilter.doFilter(MgnlVirtualUriFi > lter.java:83) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.ContentTypeFilter.doFilter(ContentTypeFilter.j > ava:66) > at > info.magnolia.cms.filters.MagnoliaManagedFilter$CustomFilterChain.doFilt > er(MagnoliaManagedFilter.java:106) > at > info.magnolia.cms.filters.MagnoliaManagedFilter.doFilter(MagnoliaManaged > Filter.java:71) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica > tionFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java > :126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java > :105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 > 48) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j > ava:833) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce > ss(Http11AprProtocol.java:639) > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285) > at java.lang.Thread.run(Unknown Source) > > ******************************************** > IPH Informatik AG > Herr Claudio Greuter > Lagerhausstrasse 9 > 8400 Winterthur > Switzerland > Tel: +41 (0)52 203 26 72 > Fax: +41 (0)52 233 94 71 > Email: [EMAIL PROTECTED] > ******************************************** > > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/magnolia/developer.html > ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
