[xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.
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 . Below is a cut down version: 13:23:53,377 [] [http-8080-Processor25] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException 13:23:53,378 [] [http-8080-Processor25] ERROR [/xwiki].[action] - Servlet.service() for servlet action threw exception com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:250) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426) [...] Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:333) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97) [...] Wrapped Exception: java.sql.BatchUpdateException: No value specified for parameter 4 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085) [...] Note that this is different to http://jira.xwiki.org/jira/browse/XWIKI-1702 (I get the error despite running "alter table xwikidoc modify column XWD_ARCHIVE mediumtext null;" on the db image). Setup details: - Linux version 2.6.18-5-686 (Debian 2.6.18.dfsg.1-13) - mysql Ver 14.12 Distrib 5.0.32, mysql-connector-java-5.1.5-bin.jar - IBM java 1.5.0 pxi32devifx-20071025 (SR6b) - Tomcat 5.5.25 - XWiki 1.1.2 and 1.2-rc1 Thanks for any help! Cheers, Robin
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
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
participants (2)
-
Robin Fernandes -
Sergiu Dumitriu