[xwiki-users] question about xwiki upgrade with postgresql 8.1 database
VanderLeeden
vanderleeden at logicunited.com
Sun Feb 4 18:12:06 CET 2007
Hi Jimmy,
the following success story has been posted on Friday. Try it out. Maybe, it
helps in your case as well.
The upgrade was done with the new xwiki.cfg and our old hibernate.cfg.xml
files.
Good luck,
-Rudolf.
I just wanted to let you know that I didn't have serious problems going from
XWiki 0.9.1252 to XWiki 1.0B3 with a Postgres database.
Basically, I followed the instructions in:
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWiki10Beta3
As reported earlier, you'll get an exception ("Could not execute JDBC batch
update") connecting to XWiki 1.0B3 for the first time.
Analyzing the error message in xwiki.log:
Batch entry 0 insert into xwikidoc (XWD_FULLNAME .)
SQL ERROR: null value in column "xwd_archive" violates not-null
constraint
leads to an easy conclusion: remove the not-null constraint from the
xwd_archive column in the xwikidoc table.
The SQL statement is: ALTER TABLE xwikidoc ALTER COLUMN xwd_archive DROP
NOT NULL;
After running this SQL statement the connection was done successfully and I
could load the XAR file as described in the instructions.
In my case, only one thing was different from the old XWiki. All the
memberships in XWikiAllGroup were gone. Only the ADMIN user was a member. So
I created a Ruby script to add all users to XWikiAllGroup in the database.
This can of course also be done manually.
I don't know if this works in all Postgres cases.
BTW, I did at the same time a database upgrade from PG 8.1.3 to 8.2.1.
Rudolf VanderLeeden
SysAdmin
Logic United GmbH
(Germany)
----- Original Message -----
From: <jimmy at comkraft.com>
To: <xwiki-users at objectweb.org>
Sent: Saturday, February 03, 2007 11:36 PM
Subject: [xwiki-users] question about xwiki upgrade with postgresql 8.1
database
> Hi,
>
> Currently we are using xwiki 0.984 in production (with postgresql 8.1). We
> are planning to upgrade to 1.0 but don't want to migrate all the data from
> the old db (for version 0.984 , 27 tables) to the new db (for version 1.0,
> 36 tables).
>
> I dumped the production db into my pc and then point xwiki 1.0 code to
> this old db. I left the ...hibernate.updateschema=1 as in subversion and
> it automatically created the missing 7 tables. However, when I tried to
> start xwiki, I got the following errors in the screen:
> -------------------------------------------------------------------------
> root cause
>
> 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.TagClass
> Wrapped Exception: Could not execute JDBC batch update
> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266)
> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
> com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
> --------------------------------------------------------------------
> In xwiki.log, the error looks like:
>
> 11:55:36,605 ERROR http-8080-Processor25 [action]:invoke:253 -
> 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.TagClass
> Wrapped Exception: Could not execute JDBC batch update
> at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:266)
> at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
>
>
> Wrapped Exception:
>
>
> com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
> saving document XWiki.TagClass
> Wrapped Exception: Could not execute JDBC batch update
> at
> com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:314)
> at
> com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100)
> at
> com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94)
> at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:793)
> at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1897)
> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:601)
> at com.xpn.xwiki.XWiki.<init>(XWiki.java:513)
> at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:257)
> at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
>
>
> Wrapped Exception:
>
>
> java.sql.BatchUpdateException: Batch entry 0 insert into xwikidoc
> (XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE,
> XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE,
> XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT,
> XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS,
> XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values
> (XWiki.TagClass, TagClass, , , , 0, 2007-02-03 11:55:29.000000 -0500,
> 2007-02-03 11:55:29.000000 -0500, 2007-02-03 11:55:29.000000 -0500, , , ,
> XWiki,
> , 1.1, , , <?xml version="1.0" encoding="UTF-8"?>
>
> <class>
> <name>XWiki.TagClass</name>
> <customClass></customClass>
> <customMapping></customMapping>
> <defaultViewSheet></defaultViewSheet>
> <defaultEditSheet></defaultEditSheet>
> <defaultWeb></defaultWeb>
> <nameField></nameField>
> <validationScript></validationScript>
> <tags>
> <name>tags</name>
> <prettyName>Tags</prettyName>
> <unmodifiable>0</unmodifiable>
> <relationalStorage>1</relationalStorage>
> <displayType>checkbox</displayType>
> <multiSelect>1</multiSelect>
> <size>30</size>
> <separator> </separator>
> <separators> ,|</separators>
> <values></values>
> <number>1</number>
> <classType>com.xpn.xwiki.objects.classes.StaticListClass</classType>
> </tags>
> </class>
> , 0, , , -1050118876) was aborted. Call getNextException to see the
> cause.
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2512)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1314)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2574)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
> at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:561)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:539)
> at
> com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:309)
> at
> com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100)
> at
> com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94)
> at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:793)
> at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1897)
> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:601)
> at com.xpn.xwiki.XWiki.<init>(XWiki.java:513)
> at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:257)
> at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:346)
> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
>
>
>
> I saw some postings regarding xwiki upgrade in a postgresql environment
> but haven't seen a success story yet. Has anyone successfully upgrade the
> database in a postgresql environment? Or do you see why the above error
> could happen? I am using the xwiki 1.1 snapshot from subversion last
> night.
>
> Thanks
>
> -Jimmy
>
>
>
--------------------------------------------------------------------------------
>
> --
> You receive this message as a subscriber of the xwiki-users at objectweb.org
> mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
More information about the users
mailing list