[
http://jira.xwiki.org/jira/browse/XWIKI-2074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vincent Massol closed XWIKI-2074.
---------------------------------
Resolution: Fixed
Fixed
> 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.2.1, 1.3 M1
> Reporter: Vincent Massol
> Assigned To: 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
