Hi Marius,

Thanks for the quick reply. I
installed xwiki-enterprise-web-4.0-20120420.113602-201.war from the
snapshots area and this fixed the migration problem.

Frits

On Fri, Apr 20, 2012 at 2:24 PM, Marius Dumitru Florea <
mariusdumitru.flo...@xwiki.com> wrote:

> Hi Frits,
>
> Some migration issues have been fixed after 4.0RC1, and will be
> included in the 4.0 final release (which should be out in the coming
> days). Please check if your issue matches ones of these
>
> http://jira.xwiki.org/secure/IssueNavigator.jspa?reset=true&jqlQuery=project+%3D+XWIKI+AND+%28summary+~+migration+OR+description+~+migration+OR+comment+~+migration%29+AND+fixVersion+%3D+12959
> . It would be great if you could test the latest 4.0-SNAPSHOT from
> http://maven.xwiki.org/snapshots/org/xwiki/enterprise/ .
>
> Thanks,
> Marius
>
> On Fri, Apr 20, 2012 at 1:03 PM, Frits Jalvingh <j...@etc.to> wrote:
> > Hi,
> >
> > I am trying to upgrade my xwiki 3.0 installation to 4.0rc1. The database
> > migration fails as follows:
> >
> > 2012-04-20 11:53:53,030 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - Running storage schema updates and
> > migrations
> > 2012-04-20 11:53:53,126 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - Current storage version = [15429]
> > 2012-04-20 11:53:53,126 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - List of migrations that will be
> executed:
> > 2012-04-20 11:53:53,126 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager -   R35100XWIKI7564 - See
> > http://jira.xwiki.org/browse/XWIKI-7564
> > 2012-04-20 11:53:53,126 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager -   R40000XWIKI6990 - Convert document
> IDs
> > to use the new improved hash algorithm.
> > 2012-04-20 11:53:53,126 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager -   R40001XWIKI7540 - See
> > http://jira.xwiki.org/browse/XWIKI-7540
> > 2012-04-20 11:53:57,430 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - 20 schema updates
> > required.
> > 2012-04-20 11:53:58,419 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - Successfully acquired change log lock
> > 2012-04-20 11:53:58,570 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - Creating database history table with
> > name: databasechangelog
> > 2012-04-20 11:53:58,579 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - Reading from databasechangelog
> > 2012-04-20 11:53:58,582 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - Reading from databasechangelog
> > 2012-04-20 11:53:58,713 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-000::dgervalle ran successfully in 72ms
> > 2012-04-20 11:53:58,749 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-001::dgervalle ran successfully in 17ms
> > 2012-04-20 11:53:58,769 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-002::dgervalle ran successfully in 17ms
> > 2012-04-20 11:53:58,785 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-003::dgervalle ran successfully in 12ms
> > 2012-04-20 11:53:58,804 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-004::dgervalle ran successfully in 16ms
> > 2012-04-20 11:53:58,815 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-005::dgervalle ran successfully in 8ms
> > 2012-04-20 11:53:58,838 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-006::dgervalle ran successfully in 20ms
> > 2012-04-20 11:53:58,866 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-007::dgervalle ran successfully in 25ms
> > 2012-04-20 11:53:58,878 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-008::dgervalle ran successfully in 9ms
> > 2012-04-20 11:53:58,888 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-009::dgervalle ran successfully in 7ms
> > 2012-04-20 11:53:58,927 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-010::dgervalle ran successfully in 36ms
> > 2012-04-20 11:53:59,027 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-011::dgervalle ran successfully in 97ms
> > 2012-04-20 11:53:59,043 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-012::dgervalle ran successfully in 13ms
> > 2012-04-20 11:53:59,055 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-013::dgervalle ran successfully in 9ms
> > 2012-04-20 11:53:59,072 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-014::dgervalle ran successfully in 14ms
> > 2012-04-20 11:53:59,083 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-015::dgervalle ran successfully in 8ms
> > 2012-04-20 11:53:59,092 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-016::dgervalle ran successfully in 6ms
> > 2012-04-20 11:53:59,103 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-017::dgervalle ran successfully in 8ms
> > 2012-04-20 11:53:59,112 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-018::dgervalle ran successfully in 6ms
> > 2012-04-20 11:53:59,123 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - ChangeSet
> > liquibase.xml::R40000-019::dgervalle ran successfully in 9ms
> > 2012-04-20 11:53:59,128 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  c.x.x.s.m.liquibase            - Successfully released change log lock
> > 2012-04-20 11:53:59,129 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - Running migration [R35100XWIKI7564]
> with
> > version [35100]
> > 2012-04-20 11:54:34,855 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - New storage version is now [35100]
> > 2012-04-20 11:54:34,855 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - Running migration [R40000XWIKI6990]
> with
> > version [40000]
> > 2012-04-20 11:54:34,993 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 1166
> > document IDs to be converted.
> > 2012-04-20 11:54:35,173 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 1593
> object
> > IDs to be converted.
> > 2012-04-20 11:54:35,257 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 3 custom
> > mapped classes to be processed.
> > 2012-04-20 11:54:35,263 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 0
> document
> > statistics IDs to be converted.
> > 2012-04-20 11:54:35,268 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 0 referer
> > statistics IDs to be converted.
> > 2012-04-20 11:54:35,273 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 0 visit
> > statistics IDs to be converted.
> > 2012-04-20 11:54:35,273 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Converting 1166
> > document IDs in 5 tables and 0 collection tables...
> > 2012-04-20 11:54:38,449 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - All document IDs
> has
> > been converted successfully.
> > 2012-04-20 11:54:38,449 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Converting 1593
> > object IDs in 11 tables, 3 custom mapped tables and 3 collection
> tables...
> > 2012-04-20 11:54:38,717 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> WARN
> >  o.h.u.JDBCExceptionReporter    - SQL Error: 0, SQLState: 23503
> > 2012-04-20 11:54:38,717 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> ERROR
> > o.h.u.JDBCExceptionReporter    - ERROR: insert or update on table
> > "xwikilists" violates foreign key constraint "fkdf23086d283ee295"
> >  Detail: Key (xwl_id, xwl_name)=(-5504298284294640791, tags) is not
> > present in table "xwikiproperties".
> > 2012-04-20 11:54:38,718 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> WARN
> >  h.a.e.MultiTableUpdateExecutor - unable to drop temporary id table after
> > use [ERROR: current transaction is aborted, commands ignored until end of
> > transaction block]
> > 2012-04-20 11:54:38,734 [http://xwiki.itris.nl/nwiki/bin/view/Main/]
> INFO
> >  .HibernateDataMigrationManager - Failed to migrate database [xwiki]...
> > com.xpn.xwiki.store.migration.DataMigrationException: Data migration
> > R40000XWIKI6990 failed
> >
> > I am running on a Posgresql 9.1 database..
> >
> > Hope someone can help...
> >
> > Frits
> > _______________________________________________
> > users mailing list
> > users@xwiki.org
> > http://lists.xwiki.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to