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
----------------------------------------------------------------
