Hi all,
I'm attempting to migrate a fairly large xwiki instance (5000+ docs,
db image >1GB) from 0.9.840 to 1.x. The database schema update fails
when I try to access a page for the first time. I get the same problem
with both XWiki 1.1.2 and 1.2-rc1.
Full stacktraces from the log file are available here:
http://pastebin.com/fbc7639b .
Below is a cut down version:
13:23:53,377 [] [http-8080-Processor25] WARN action.RequestProcessor
- Unhandled Exception thrown: class
com.xpn.xwiki.XWikiException
13:23:53,378 [] [http-8080-Processor25] ERROR [/xwiki].[action]
- 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.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:250)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
[...]
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
saving document XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:333)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
[...]
Wrapped Exception:
java.sql.BatchUpdateException: No value specified for parameter 4
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085)
[...]
Note that this is different to
http://jira.xwiki.org/jira/browse/XWIKI-1702 (I get the error despite
running "alter table xwikidoc modify column XWD_ARCHIVE mediumtext
null;" on the db image).
Setup details:
- Linux version 2.6.18-5-686 (Debian 2.6.18.dfsg.1-13)
- mysql Ver 14.12 Distrib 5.0.32, mysql-connector-java-5.1.5-bin.jar
- IBM java 1.5.0 pxi32devifx-20071025 (SR6b)
- Tomcat 5.5.25
- XWiki 1.1.2 and 1.2-rc1
Thanks for any help!
Cheers,
Robin