[xwiki-users] Failed to migrate database from release 3.4 to 4.1.2
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
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 < [email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO
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 : [email protected] [mailto:[email protected]] 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 < [email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
CHENEAU-GREHALLE Nicolas -
Denis Gervalle