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

Increase the limit of the parent size to the maximum supported by MySQL

    XMLWordPrintable

    Details

    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      SQL Error: 1406, SQLState: 22001 Data truncation: Data too long 
      for column 'XWD_PARENT' at row 1 Failed to perform the migration of 
      [xwiki:TEST.Too long Hierarchy\. Too long Hierarchy\. Too long Hierarchy
       9]. com.xpn.xwiki.XWikiException: Error number 0 in 0: Error number 
      3201 in 3: Exception while saving document xwiki:TEST.Test.Test\. This 
      is a test page.Long Hierarchy.Too long Hierarchy\. Too long Hierarchy\. 
      Too long Hierarchy 1.Too long Hierarchy\. Too long Hierarchy\. Too long 
      Hierarchy 2.Too long Hierarchy\. Too long Hierarchy\. Too long Hierarchy
       3.Too long Hierarchy\. Too long Hierarchy\. Too long Hierarchy 4.Too 
      long Hierarchy\. Too long Hierarchy\. Too long Hierarchy 5.Too long 
      Hierarchy\. Too long Hierarchy\. Too long Hierarchy 6.Too long 
      Hierarchy\. Too long Hierarchy\. Too long Hierarchy 7.Too long 
      Hierarchy\. Too long Hierarchy\. Too long Hierarchy 8.Too long 
      Hierarchy\. Too long Hierarchy\. Too long Hierarchy 9.WebHome at 
      com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:729)
       at 
      com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:257)
       at 
      com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:217)
       at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:2052) at 
      com.xpn.xwiki.doc.DefaultDocumentAccessBridge.saveDocument(DefaultDocumentAccessBridge.java:994)
       at 
      com.xpn.xwiki.doc.DefaultDocumentAccessBridge.setDocumentParentReference(DefaultDocumentAccessBridge.java:326)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.moveDocument(MigrationPlanExecutor.java:227)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:139)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performAction(MigrationPlanExecutor.java:153)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.executor.MigrationPlanExecutor.performMigration(MigrationPlanExecutor.java:110)
       at 
      org.xwiki.contrib.nestedpagesmigrator.internal.job.MigrationPlanExecutorJob.runInternal(MigrationPlanExecutorJob.java:58)
       at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243) at 
      org.xwiki.job.AbstractJob.run(AbstractJob.java:220) at 
      java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at 
      java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at 
      java.lang.Thread.run(Unknown Source) Caused by: 
      javax.persistence.PersistenceException: 
      org.hibernate.exception.DataException: could not execute statement at 
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
       at 
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
       at 
      org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
       at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366) at
       org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453) 
      at 
      org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3212)
       at 
      org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2380)
       at 
      org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:448)
       at 
      org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183)
       at 
      org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
       at 
      org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281)
       at 
      org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
       at 
      com.xpn.xwiki.internal.store.hibernate.HibernateStore.endTransaction(HibernateStore.java:848)
       at 
      com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:603)
       at 
      com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:720)
       ... 26 more Caused by: org.hibernate.exception.DataException: could not
       execute statement at 
      org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
       at 
      org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
       at 
      org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
       at 
      org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
       at 
      org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
       at 
      org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3492)
       at 
      org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3354)
       at 
      org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3768)
       at 
      org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:201)
       at 
      org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
       at 
      org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
       at java.util.LinkedHashMap.forEach(Unknown Source) at 
      org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
       at 
      org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:345)
       at 
      org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
       at 
      org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93)
       at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362) 
      ... 37 more Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation:
       Data truncation: Data too long for column 'XWD_PARENT' at row 1: null 
      at 
      com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
       at 
      com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
       at 
      com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
       at 
      com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
       at 
      com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
       at 
      com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
       at 
      org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
       at 
      org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
       at 
      org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
       at 
      org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
       ... 49 more

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              acotiuga Alex Cotiugă
              Reporter:
              acotiuga Alex Cotiugă
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response: