Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-9637

Migrator to change column size for XWR_COMMENT DB to support comments longer than 768 characters

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • None
    • 5.2
    • Old Core
    • None
    • Unknown

    Description

      Issue reproduced when trying to copy http://dev.xwiki.org/xwiki/bin/view/Design/ApplicationWithinMinutes to design.xwiki.org wiki (XWiki 5.2), cause because of long save summary messages introduced when adding annotations.

      Error number 4001 in 4: Error while parsing velocity page /templates/copy.vm
      Error number 4001 in 4: Error while parsing velocity page /templates/copy.vm
      com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page /templates/copy.vm
              at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:110)
              at com.xpn.xwiki.internal.template.DefaultPrivilegedTemplateRenderer.evaluate(DefaultPrivilegedTemplateRenderer.java:125)
              at com.xpn.xwiki.internal.template.DefaultPrivilegedTemplateRenderer.evaluateTemplate(DefaultPrivilegedTemplateRenderer.java:75)
              at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1841)
              at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:166)
              at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:303)
              at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:128)
              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:617)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:121)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:206)
              at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:179)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:311)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [/templates/copy.vm]
              at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:247)
              at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:187)
              at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:105)
              ... 46 more
      Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'copyDocument' in  class com.xpn.xwiki.api.XWiki threw exception com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document design:Design.ApplicationWithinMinutes at /templates/copy.vm[line 51, column 18]
              at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:243)
              at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:187)
              at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
              at org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:530)
              at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:62)
              at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:85)
              at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
              at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
              at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
              at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
              at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
              at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
              at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:228)
              ... 48 more
      Caused by: com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document design:Design.ApplicationWithinMinutes
              at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:754)
              at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:177)
              at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:170)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1460)
              at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1405)
              at com.xpn.xwiki.XWiki.copyDocument(XWiki.java:4183)
              at com.xpn.xwiki.api.XWiki.copyDocument(XWiki.java:1586)
              at sun.reflect.GeneratedMethodAccessor2053.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
              at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
              at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
              ... 59 more
      Caused by: org.hibernate.HibernateException: Failed to commit or rollback transaction. Root cause []
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:983)
              at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:744)
              ... 71 more
      Caused by: org.hibernate.exception.DataException: could not insert: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo]
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
              at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
              at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
              at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
              at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
              at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
              at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
              at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:976)
              ... 72 more
      Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'XWR_COMMENT' at row 1
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
              at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
              at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
              at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
              at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
              at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:373)
              at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:130)
              at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:259)
              at $Proxy50.executeBatch(Unknown Source)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:56)
              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2434)
              ... 83 more
      

      For other info see XWIKI-9327

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              evalica Ecaterina Moraru (Valica)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: