20 Apr
2012
20 Apr
'12
3:28 p.m.
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.florea(a)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=pr…
. 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 <jal(a)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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users