On 03.02.2012 14:50, Ari wrote:

I have XWiki Enterprise 3.0.36132 and would like to upgrade to latest version. I have tried to upgrade directly to 3.4 but as it produced error message I tried to upgrade in steps..

Upgrade to 3.1.1 was ok, no db migration was needed and installed the .xar without problems. Then upgrade to 3.2.1 produced the following:

Tried to upgrade to 3.3.1 with the following: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{docId=495778886, version2=1, version1=2}] at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1110) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1140) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadRCSNodeContent(XWikiHibernateVersioningStore.java:298) at com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo.getContent(XWikiRCSNodeInfo.java:175) at com.xpn.xwiki.doc.XWikiDocumentArchive.makePatch(XWikiDocumentArchive.java:138) at com.xpn.xwiki.doc.XWikiDocumentArchive.updateArchive(XWikiDocumentArchive.java:254) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:254) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:483) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:174) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:167) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1403) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1359) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1354) at com.xpn.xwiki.XWiki.getUserClass(XWiki.java:3075) at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:840) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:814) at com.xpn.xwiki.XWiki.<init>(XWiki.java:740) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:402) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:488) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:304) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Wrapped Exception: org.postgresql.util.PSQLException: Bad value for type long : <?xml version="1.0" encoding="UTF-8"?> <xwikidoc> <web>XWiki</web> <name>XWikiUsers</name> <language></language> <defaultLanguage>en</defaultLanguage> <translation>1</translation> <parent>XWiki.WebHome</parent> <creator>XWiki.Admin</creator> <author>XWiki.Admin</author> <customClass></customClass> <contentAuthor>XWiki.Admin</contentAuthor> <creationDate>1106311618000</creationDate> . . . The DB is few GBs so automatic upgrade would be extremely wonderful. :D BR, ari

---------------- Servlet.service() for servlet [action] in context with path [/xwiki] threw exception [com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiUsers Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiUsers Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{docId=495778886, version2=1, version1=2}]] with root cause com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiUsers Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiUsers Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{docId=495778886, version2=1, version1=2}] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:422) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) -----------------

the hibernate configuration is

--------------------- <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory>

<property name="show_sql">false</property> <property name="use_outer_join">true</property>

<property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <property name="jdbc.use_scrollable_resultset">false</property>

<property name="connection.useUnicode">true</property> <property name="connection.characterEncoding">UTF-8</property>

<property name="connection.url">jdbc:postgresql://10.10.1.134/xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password"></property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>

<property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/>

</session-factory> </hibernate-configuration> ---------------------

Any help would be appreciated..

BR, ari