[xwiki-users] Migration from Xwiki 3.1.1 to 3.3 attempt failed: 'thrown exception' - xwiki-users@xwiki.org

19 Jan 2012

Hi,

I have just tried to get my Xwiki version updated from 3.1.1 to 3.3.

For some reason as I've posted about I had major errors in the upgrade 
process from 2.x over to 3.1.1 as my admin panel went funny after the 
upgrade.

Now in my attempt Tomcat's log shows this:

www# cat stdout.log | tail
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
[catalina.jar:6.0.35]
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
[catalina.jar:6.0.35]
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
[catalina.jar:6.0.35]
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
[catalina.jar:6.0.35]
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) 
[catalina.jar:6.0.35]
     at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) 
[tomcat-coyote.jar:6.0.35]
     at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

[tomcat-coyote.jar:6.0.35]
     at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
[tomcat-coyote.jar:6.0.35]
     at java.lang.Thread.run(Thread.java:619) [na:1.6.0_07]
2012-01-19 19:34:43,367 
[http://www.optiplex-networks.com/xwiki/bin/view/Main/] WARN  
o.a.s.a.RequestProcessor       - Unhandled Exception thrown: class 
com.xpn.xwiki.XWikiException

And the browser shows this:

javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could
not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128)
	org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
	com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
	org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
	org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)

*root cause*

com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki
context
Wrapped Exception: Error number 3001 in 3: Cannot load class
com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param
xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it.
	com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:419)
	com.xpn.xwiki.XWiki.getXWiki(XWiki.java:488)
	com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136)
	com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128)
	org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
	com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
	org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
	org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)

I am running Tomcat6 with Postgresql. A quick google yielded to the same 
error but with Oracle DB which gave this as a fix:

<property
name="hibernate.connection.SetBigStringTryClob">true</property>
<property name="hibernate.jdbc.batch_size">0</property>

I'm wondering if it's the same for postgres???

I will atempt to include the statements but I believe I will need to 
restore my Xwiki instance from my backups at this current moment in time!

Regards,

Kaya