[xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.
31 Dec
2007
31 Dec
'07
1:16 p.m.
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
2 Jan
2 Jan
11:03 a.m.
New subject: [xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.
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
4 Jan
4 Jan
1:09 p.m.
New subject: [xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.
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
6100
days inactive
6104
days old
2 comments
2 participants
participants (2)
-
Robin Fernandes -
Sergiu Dumitriu