[xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.

[Robin Fernandes]

> 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#HField27XWDARCHIVE27doesn27thaveadefaultvalue
.

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 at 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 at xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>