4 Jan
2008
4 Jan
'08
1:09 p.m.
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#HField27XW…
.
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 <sergiu(a)xwiki.com> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users