Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-7564

Upgrade from a version before 3.3 fails when running on a PostgreSQL database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0-milestone-2, 3.5.1
    • 3.4, 3.5
    • Old Core, Storage
    • None
    • Debian Linux, PostgreSQL 8.4, Tomcat 6, JDK 1.6,
    • upgrade,postgresql
    • Unknown

    Description

      Upgrade to xwiki-enterprise-web-3.2.war from 3.0 or 3.1.1 fails. Tomcat is starting, but after opening xwiki in web browser I get many errors in catalina.out

      2011-10-31 20:46:01,471 [https://..../xwiki/bin/view/Main/WebHome] ERROR o.h.u.JDBCExceptionReporter    - Bad value for type long : <?xml version="1.0" encoding="UTF-8"?>
      <xwikidoc>
      <web>Scheduler</web>
      <name>WatchListJob2</name>
      <language></language>
      <defaultLanguage></defaultLanguage>
      <translation>0</translation>
      <parent>XWiki.XWikiClasses</parent>
      <creator>XWiki.Admin</creator>
      [...]
      
      2011-10-31 20:46:03,178 [https://..../xwiki/bin/view/Main/WebHome] WARN  o.a.s.a.RequestProcessor       - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 
      Oct 31, 2011 8:46:03 PM org.apache.catalina.core.StandardWrapperValve invoke
      SEVERE: Servlet.service() for servlet action 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=4}]
              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)
              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:690)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686)
              at java.lang.Thread.run(Thread.java:662)
      
      Wrapped Exception:
      
      com.xpn.xwiki.XWikiException: 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=4}]
              at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:690)
              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:1406)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1362)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1357)
              at com.xpn.xwiki.XWiki.getUserClass(XWiki.java:3078)
              at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:843)
              at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:817)
              at com.xpn.xwiki.XWiki.<init>(XWiki.java:743)
              at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:405)
              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)
              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:690)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      [...]
      Wrapped Exception:
      
      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=4}]
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1097)
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1127)
              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:1406)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1362)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1357)
              at com.xpn.xwiki.XWiki.getUserClass(XWiki.java:3078)
              at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:843)
              at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:817)
              at com.xpn.xwiki.XWiki.<init>(XWiki.java:743)
              at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:405)
              at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491)
      [...]
      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>
      

      TIA,

      R.

      Attachments

        Issue Links

          Activity

            People

              sdumitriu Sergiu Dumitriu
              dirk@computer42.org H.-Dirk Schmitt
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: