Hi, I continued to investigate my very special issue. The problem is caused by a RCS issue. In the content of a newly created attachment (table xwikiattachment_archive), there are the following lines : 1.1 date 2011.06.17.15.16.55; author PLF071$; state Exp; branches; next ; The dollar sign at the end of my machine name seems to be the cause of the issue. On the production platform (where all is working fine), the author is "SYSTEM". I really don't know why jrcs or xwiki put PLF071$ in the author rcs field. PLF071 (without any $ sign) is only my Windows Vista computer name. If you have any idea to test, I will be very happy. Regards, Maxime 2011/6/14 Maxime Sinclair <[email protected]>:
I reproduce the problem while logging in debug mode. This is an excerpt :
11:45:34,519 [.../bin/viewattachrev/Documentation/WebHome/xwikisanitycheck.sql] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/viewattachrev.vm@4,12
DEBUG impl.SessionImpl - opened session at timestamp: 13080447345 DEBUG jdbc.ConnectionManager - opening JDBC connection INFO dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect DEBUG transaction.JDBCTransaction - begin DEBUG transaction.JDBCTransaction - current autocommit status: false DEBUG loader.Loader - loading entity: [com.xpn.xwiki.doc.XWikiAttachmentArchive#1260613346] DEBUG jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0) DEBUG hibernate.SQL - select xwikiattac0_.XWA_ID as XWA1_8_0_, xwikiattac0_.XWA_ARCHIVE as XWA2_8_0_ from xwikiattachment_archive xwikiattac0_ where xwikiattac0_.XWA_ID=? DEBUG jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0) DEBUG loader.Loader - result row: EntityKey[com.xpn.xwiki.doc.XWikiAttachmentArchive#1260613346] DEBUG jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1) DEBUG jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1) DEBUG engine.TwoPhaseLoad - resolving associations for [com.xpn.xwiki.doc.XWikiAttachmentArchive#1260613346] INFO def.DefaultLoadEventListener - Error performing load command org.hibernate.PropertyAccessException: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65) at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337) at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200) at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854) at org.hibernate.loader.Loader.doQuery(Loader.java:729) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:784) at com.xpn.xwiki.store.hibernate.HibernateAttachmentVersioningStore$1.doInHibernate(HibernateAttachmentVersioningStore.java:79) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1081) ............ Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42) ... 76 more Caused by: org.suigeneris.jrcs.rcs.parse.TokenMgrError: Lexical error at line 1, column 104. Encountered: "$" (36), after : "" at org.suigeneris.jrcs.rcs.parse.ArchiveParserTokenManager.getNextToken(ArchiveParserTokenManager.java:817) at org.suigeneris.jrcs.rcs.parse.ArchiveParser.jj_ntk(ArchiveParser.java:685) at org.suigeneris.jrcs.rcs.parse.ArchiveParser.authorName(ArchiveParser.java:527) at org.suigeneris.jrcs.rcs.parse.ArchiveParser.delta(ArchiveParser.java:385) at org.suigeneris.jrcs.rcs.parse.ArchiveParser.archive(ArchiveParser.java:96) at org.suigeneris.jrcs.rcs.parse.ArchiveParser.load(ArchiveParser.java:60) at org.suigeneris.jrcs.rcs.Archive.<init>(Archive.java:259) at org.suigeneris.jrcs.rcs.Archive.<init>(Archive.java:273) at com.xpn.xwiki.doc.XWikiAttachmentArchive.setArchive(XWikiAttachmentArchive.java:121) ... 81 more
Hope this help to understand the issue. Maxime Sinclair
2011/6/14 Maxime Sinclair <[email protected]>:
Hello,
Context : XEM 2.7.1 on Tomcat6.0 + MySQL 5.0
I'm used to restore my xwiki farm SQL backup on a test environment. I have to update the Domain names and then it works fine. But this time, I encounter the following issue : - I can retrieve the different version of an existing attachment (without any problem) - I can add a new version of an attachment (the version number is incremented and I can download it) but ... - When I look at the revision history of the attachment, all the old revisions are now lost and the following lines appear in the xwiki.log
2011-06-14 10:56:04,169 [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/viewattachrev.vm@4,12
2011-06-14 10:56:04,169 [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] WARN doc.XWikiAttachment - Failed to load archive for attachment [[email protected]]. This attachment is broken, please consider re-uploading it. Internal error: Error number 3231 in 3: Exception while loading attachment archive xwikisanitycheck.sql of document Documentation.WebHome Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Exception occurred inside setter of com.xpn.xwiki.doc.XWikiAttachmentArchive.archive
2011-06-14 10:56:04,169 [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] [http://www.lclh.org/bin/viewattachrev/Documentation/WebHome/xwikisanitycheck...] WARN doc.XWikiAttachment - Cannot retrieve versions of attachment [[email protected]]: null
Hopefully, this doesn't occur on my production environment. Do you have any idea about this issue ? Your help will be really appreciated.
Regards, Maxime Sinclair