Database Migration fails when migrating from 1.0 or older directly to 1.2
without going through a 1.1 upgrade
-------------------------------------------------------------------------------------------------------------
Key: XWIKI-2074
URL: http://jira.xwiki.org/jira/browse/XWIKI-2074
Project: XWiki Platform
Issue Type: Bug
Components: Storage
Affects Versions: 1.3 M1, 1.2.1
Reporter: Vincent Massol
Fix For: 1.3 M2, 1.2.2
The error you get is:
{noformat}
2008-02-05 22:25:29,337 [http://localhost:8081/xwiki/bin/view/Main/WebHome]
[http-8081-1] INFO .AbstractXWikiMigrationManager - Running migration
[R4359XWIKI1459] with version [4359]
2008-02-05 22:25:29,543 [http://localhost:8081/xwiki/bin/view/Main/WebHome]
[http-8081-1] INFO bernate.R4359XWIKI1459Migrator - Updating document
[XWiki.ArticleClass]...
2008-02-05 22:25:31,136 [http://localhost:8081/xwiki/bin/view/Main/WebHome]
[http-8081-1] INFO .AbstractXWikiMigrationManager - Failed to migrate
database [jguard]...
com.xpn.xwiki.XWikiException: Error number 3005 in 3: Migration failed
Wrapped Exception: Error number 3005 in 3: R4359XWIKI1459 migration failed
Wrapped Exception: Data truncation: Column was set to data type implicit
default; NULL supplied for NOT NULL column 'XWD_ARCHIVE' at row 1
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:179)
at
com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:124)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
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.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
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:233)
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:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 3005 in 3: R4359XWIKI1459 migration
failed
Wrapped Exception: Data truncation: Column was set to data type implicit
default; NULL supplied for NOT NULL column 'XWD_ARCHIVE' at row 1
at
com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHibernate(R4359XWIKI1459Migrator.java:120)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
{noformat}
This because in pre-1.0 DB the XWD_ARCHIVE had a not null constraints with was
updated to 'null allowed' in 1.1 but since that column has disappeared in the
1.2 schema Hibernate doesn't update the contraint... (thanks to Sergiu for
figuring this out).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
notifications mailing list
notifications@xwiki.org
http://lists.xwiki.org/mailman/listinfo/notifications
