[xwiki-dev] Issue to investigate

Ludovic Dubost ludovic at xwiki.com
Fri Apr 20 22:56:26 CEST 2007


I've recently upgraded a wiki on the farm and the key documents that 
should not be imported in an upgrade are:

XWiki.XWikiPreferences
XWiki.WebPreferences
Main.WebPreferences (and all other spaces WebPreferences pages)
XWiki.XWikiAllGroup (list of users)
XWiki.AdminGroup (list of admins)
Main.WebHome (usually modified)

and other content page modified (panels, etc..)

Indeed it would be usefull to have an "upgrade" xar and a "install" xar

Ludovic

Vincent Massol a écrit :
>
> On Apr 20, 2007, at 10:49 AM, Sergiu Dumitriu wrote:
>
>> I think AllUsers should not be included in the XAR.
>>
>> Or even better, we should provide two XARs, one with all files except 
>> critical ones (AllUsers, Preferences, Admin), which can be used for 
>> upgrading an existing wiki, and one including these files. I know 
>> that users can unselect the above files from the complete archive, 
>> but I also know that users don't read instructions and aren't careful 
>> enough.
>
> ... especially as we don't have any documentation on what needs to be 
> imported and when..
>
> -Vincent
>
>>
>> On 4/20/07, *Michael Guntli* <michael.guntli at leica-geosystems.com 
>> <mailto:michael.guntli at leica-geosystems.com>> wrote:
>>
>>
>>     I think i know what the problem is.
>>     that happens if you import the *.xar file and it overwrites the
>>     existing
>>     global rights.. Then you have to select all users again and
>>     assign them to
>>     the all users group.. But then i get an exception, but it still
>>     works..
>>
>>     Exception:
>>
>>     Error number 3201 in 3: Exception while saving document
>>     XWiki.XWikiPreferences
>>     Wrapped Exception: could not update:
>>     [com.xpn.xwiki.objects.StringProperty#component[id,name]{id=1929900568,
>>
>>     name=users}]
>>     com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception
>>     while saving
>>     document XWiki.XWikiPreferences
>>     Wrapped Exception: could not update:
>>     [com.xpn.xwiki.objects.StringProperty#component
>>     [id,name]{id=1929900568,
>>     name=users}]
>>             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:914)
>>             at com.xpn.xwiki.web.SaveAction.save
>>     <http://web.SaveAction.save>(SaveAction.java :114)
>>             at com.xpn.xwiki.web.SaveAction.action
>>     <http://web.SaveAction.action>(SaveAction.java:123)
>>             at com.xpn.xwiki.web.XWikiAction.execute
>>     <http://web.XWikiAction.execute>(XWikiAction.java:149)
>>             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.doPost(ActionServlet.java:432)
>>             at
>>     javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>>             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
>>     <http://web.SetCharacterEncodingFilter.doFilter>(SetCharacterEncodingFilter.java:118)
>>             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:619)
>>
>>
>>     Wrapped Exception:
>>
>>     com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
>>     truncated for
>>     column 'XWS_VALUE' at row 1
>>             at
>>     com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:695)
>>             at
>>     com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3317)
>>             at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1741)
>>             at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
>>             at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
>>             at
>>     com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
>>             at
>>     com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1957)
>>             at
>>     com.mysql.jdbc.PreparedStatement.executeUpdate
>>     (PreparedStatement.java:1880)
>>             at
>>     com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741)
>>             at
>>     org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java
>>     :101)
>>             at
>>     org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
>>             at
>>     org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java
>>     :2208)
>>             at
>>     org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
>>             at
>>     org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java
>>     :2374)
>>             at
>>     org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
>>             at
>>     org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
>>             at org.hibernate.engine.ActionQueue.executeActions
>>     (ActionQueue.java:227)
>>             at
>>     org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
>>             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:573)
>>
>>             at
>>     com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:547)
>>             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 :914)
>>             at com.xpn.xwiki.web.SaveAction.save
>>     <http://web.SaveAction.save>(SaveAction.java:114)
>>             at com.xpn.xwiki.web.SaveAction.action
>>     <http://web.SaveAction.action>(SaveAction.java:123)
>>             at com.xpn.xwiki.web.XWikiAction.execute
>>     <http://web.XWikiAction.execute>(XWikiAction.java:149)
>>             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.doPost(ActionServlet.java:432)
>>             at
>>     javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>>             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
>>     <http://web.SetCharacterEncodingFilter.doFilter>(SetCharacterEncodingFilter.java:118)
>>             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:619)
>>
>>
>> Sergiu
>> -- 
>> http://purl.org/net/sergiu
>>
>> --
>> You receive this message as a subscriber of the 
>> xwiki-dev at objectweb.org <mailto:xwiki-dev at objectweb.org> mailing list.
>> To unsubscribe: mailto:xwiki-dev-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
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the xwiki-dev at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-dev-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
>   


-- 
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost 
AIM: nvludo Yahoo: ludovic





More information about the devs mailing list