It would be good to also know the SQL command that fails. I think it is another field that has NOT NULL specified in the database, not XWD_ARCHIVE.
Thanks for the tip, Sergiu. The reason I thought XWD_ARCHIVE needed the alteration is because it's documented here: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HField27XWD... . I have uploaded full logs with SQL query logging enabled here: http://soal.org/xwiki/xwikiMigrationLogs.zip . The archive includes logs taken on XWiki 1.1.2, 1.2-rc1 and 1.2-rc2. On all versions, the BatchUpdateException described previously is preceded by 2 invocations of the following query: insert into xwikipreferences (XWP_LANGUAGE, XWP_DEFAULT_LANGUAGE, XWP_MULTI_LINGUAL, XWP_AUTHENTICATE_EDIT, XWP_AUTHENTICATE_VIEW, XWP_AUTH_ACTIVE_CHECK, XWP_BACKLINKS, XWP_SKIN, XWP_STYLESHEET, XWP_STYLESHEETS, XWP_EDITOR, XWP_EDITBOX_WIDTH, XWP_EDITBOX_HEIGHT, XWP_WEBCOPYRIGHT, XWP_TITLE, XWP_VERSION, XWP_MENU, XWP_META, XWP_USE_EMAIL_VERIFICATION, XWP_SMTP_SERVER, XWP_ADMIN_EMAIL, XWP_VALIDATION_EMAIL_CONTENT, XWP_CONFIRMATION_EMAIL_CONTENT, XWP_INVITATION_EMAIL_CONTENT, XWP_MACROS_LANGUAGE, XWP_MACROS_VELOCITY, XWP_MACROS_GROOVY, XWP_MACROS_WIKI2, XWP_MACROS_MAPPING, XWP_NOTIFICATION_PAGES, XWP_LEFT_PANELS, XWP_RIGHT_PANELS, XWP_SHOW_LEFT_PANELS, XWP_SHOW_RIGHT_PANELS, XWP_PAGE_WIDTH, XWP_LANGUAGES, XWP_REGISTRATION_ANONYMOUS, XWP_REGISTRATION_REGISTERED, XWP_EDIT_ANONYMOUS, XWP_EDIT_REGISTERED, XWP_COMMENT_ANONYMOUS, XWP_COMMENT_REGISTERED, XWP_DOCUMENT_BUNDLES, XWP_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) I also noticed that on XWiki 1.2 rc1 and rc2 I now get an additional exception like this before the BatchUpdateException: [...] Wrapped Exception: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo.setDiff [...] Not sure if this is related. See logs in http://soal.org/xwiki/xwikiMigrationLogs.zip for details. Regards. Robin. On 02/01/2008, Sergiu Dumitriu <[email protected]> wrote:
Robin Fernandes wrote:
Hi all,
I'm attempting to migrate a fairly large xwiki instance (5000+ docs, db image >1GB) from 0.9.840 to 1.x. The database schema update fails when I try to access a page for the first time. I get the same problem with both XWiki 1.1.2 and 1.2-rc1.
Full stacktraces from the log file are available here: http://pastebin.com/fbc7639b .
pastebin doesn't work right now... Try rafb: http://rafb.net/paste/
Below is a cut down version:
It would be good to also know the SQL command that fails. I think it is another field that has NOT NULL specified in the database, not XWD_ARCHIVE. See http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Logging to find out how to make the logs show queries.
Sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users