Failed to migrate database from release 3.4 to 4.1.2

classic Classic list List threaded Threaded
3 messages Options
ncg
Reply | Threaded
Open this post in threaded view
|

Failed to migrate database from release 3.4 to 4.1.2

ncg
Hi,

 

I try to install the release 4.1.2 on 3.4.

During the database migration, there is this error message :

 

2012/06/27 13:26:54 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
c.x.x.s.m.h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] -
Converting 12568 document statistics IDs in 1 tables and 0 collection
tables...

2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] WARN
o.h.util.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000

2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR
o.h.util.JDBCExceptionReporter - Duplicate entry '-5487128615380216001'
for key 1

2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
c.x.x.s.m.h.HibernateDataMigrationManager - Failed to migrate database
[xwiki]...

com.xpn.xwiki.store.migration.DataMigrationException: Data migration
R40000XWIKI6990 failed

 

Somebody could help me about this message ?

Even in debug mode, I don't have any information about this duplicate
entry (which table ? which column ?)

 

Thank you for any help.

 

Nicolas

_______________________________________________
users mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Failed to migrate database from release 3.4 to 4.1.2

Denis Gervalle-2
Hi Nicolas,

We have detected some issues regarding the migration of statistics tables
in all 4.x version.
We are working hard on fixing these for 4.1.3 which we expect to release
quickly.
If you do not care about statistics, you may empty stats tables, and the
migration should run fine.
Else, you need to wait for 4.1.3.
Sorry for the inconvenience.

On Wed, Jun 27, 2012 at 3:31 PM, CHENEAU-GREHALLE Nicolas <
[hidden email]> wrote:

> Hi,
>
>
>
> I try to install the release 4.1.2 on 3.4.
>
> During the database migration, there is this error message :
>
>
>
> 2012/06/27 13:26:54 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
> c.x.x.s.m.h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] -
> Converting 12568 document statistics IDs in 1 tables and 0 collection
> tables...
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] WARN
> o.h.util.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR
> o.h.util.JDBCExceptionReporter - Duplicate entry '-5487128615380216001'
> for key 1
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
> c.x.x.s.m.h.HibernateDataMigrationManager - Failed to migrate database
> [xwiki]...
>
> com.xpn.xwiki.store.migration.DataMigrationException: Data migration
> R40000XWIKI6990 failed
>
>
>
> Somebody could help me about this message ?
>
> Even in debug mode, I don't have any information about this duplicate
> entry (which table ? which column ?)
>
>
>
> Thank you for any help.
>
>
>
> Nicolas
>
> _______________________________________________
> users mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/users
>



--
Denis Gervalle
SOFTEC sa - CEO
eGuilde sarl - CTO
_______________________________________________
users mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/users
ncg
Reply | Threaded
Open this post in threaded view
|

Re: Failed to migrate database from release 3.4 to4.1.2

ncg
Great, the migration is ok (no error) when I empty the stats tables :

2012/06/27 14:43:15 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.x.s.m.h.HibernateDataMigrationManager - Exiting because xwiki.store.migration.exitAfterEnd is set

However, when I restart XWiki, I've many error messages :

2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property sheet of object id 2186376547412776710
2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property allow of object id -5988059480303893268
2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property groups of object id -5988059480303893268
2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property levels of object id -5988059480303893268
2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property users of object id -5988059480303893268
2012/06/27 14:46:01 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property accessibility of object id -614498398768250718
... (more lines like that)
2012/06/27 14:46:03 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.xwiki.store.XWikiHibernateStore - No data for property plugins of object id 2824806279857424438
2012/06/27 14:46:03 [http://172.24.1.135:8080/xem/bin/view/Main/] WARN  c.x.x.i.q.ConfiguredQueryExecutorProvider - Could not find a QueryExecutor with hint hibernate which is the hint for the storage engine. the default QueryExecutor will not be used instead.
org.xwiki.component.manager.ComponentLookupException: Can't find descriptor for the component [role = [interface org.xwiki.query.QueryExecutor] hint = [hibernate]]
... (more "No data" errors)
2012/06/27 14:46:08 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR c.x.x.p.w.WatchListJobManager - Cannot initialize WatchListJob
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document xwiki:Scheduler.WatchListHourlyNotifier
Wrapped Exception: Failed to commit or rollback transaction. Root cause []
...
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.xpn.xwiki.objects.StringProperty#<?xml version="1.0" encoding="UTF-8"?>

<contextDatabase></contextDatabase>
...


I've missed something ?

Thank you

Nicolas

-----Message d'origine-----
De : [hidden email] [mailto:[hidden email]] De la part de Denis Gervalle
Envoyé : mercredi 27 juin 2012 16:47
À : XWiki Users
Objet : Re: [xwiki-users] Failed to migrate database from release 3.4 to4.1.2

Hi Nicolas,

We have detected some issues regarding the migration of statistics tables
in all 4.x version.
We are working hard on fixing these for 4.1.3 which we expect to release
quickly.
If you do not care about statistics, you may empty stats tables, and the
migration should run fine.
Else, you need to wait for 4.1.3.
Sorry for the inconvenience.

On Wed, Jun 27, 2012 at 3:31 PM, CHENEAU-GREHALLE Nicolas <
[hidden email]> wrote:

> Hi,
>
>
>
> I try to install the release 4.1.2 on 3.4.
>
> During the database migration, there is this error message :
>
>
>
> 2012/06/27 13:26:54 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
> c.x.x.s.m.h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] -
> Converting 12568 document statistics IDs in 1 tables and 0 collection
> tables...
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] WARN
> o.h.util.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] ERROR
> o.h.util.JDBCExceptionReporter - Duplicate entry '-5487128615380216001'
> for key 1
>
> 2012/06/27 13:26:58 [http://172.24.1.135:8080/xem/bin/view/Main/] INFO
> c.x.x.s.m.h.HibernateDataMigrationManager - Failed to migrate database
> [xwiki]...
>
> com.xpn.xwiki.store.migration.DataMigrationException: Data migration
> R40000XWIKI6990 failed
>
>
>
> Somebody could help me about this message ?
>
> Even in debug mode, I don't have any information about this duplicate
> entry (which table ? which column ?)
>
>
>
> Thank you for any help.
>
>
>
> Nicolas
>
> _______________________________________________
> users mailing list
> [hidden email]
> http://lists.xwiki.org/mailman/listinfo/users
>



--
Denis Gervalle
SOFTEC sa - CEO
eGuilde sarl - CTO
_______________________________________________
users mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
[hidden email]
http://lists.xwiki.org/mailman/listinfo/users