[xwiki-users] 4.0rc1 database migration failed
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
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... . 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 <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
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 < [email protected]> 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... . 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 <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Frits Jalvingh -
Marius Dumitru Florea