Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-12956

Fix diff tests under mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8-SNAPSHOT
    • Fix Version/s: 5.6.0-HF26, 5.8
    • Component/s: Core, Diff

      Description

      Some diff tests are failing under mysql because the "htmltext" column is filled with too much data:

      https://qa.nuxeo.org/jenkins/view/Critical/job/nuxeo-master-fullbuild-part1-multidb-linux/727/Slave=MULTIDB_LINUX,dbprofile=mysql,jdk=openjdk-7-jdk/testReport/junit/org.nuxeo.ecm.diff.service/TestDocumentDiff/org_nuxeo_ecm_diff_service_TestDocumentDiff/
      org.nuxeo.ecm.diff.service.TestDocumentDiff.org.nuxeo.ecm.diff.service.TestDocumentDiff

      org.nuxeo.ecm.core.api.ClientException: Failed to save session
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1890)
      	at org.nuxeo.ecm.core.test.CoreFeature.initializeSession(CoreFeature.java:183)
      	at org.nuxeo.ecm.core.test.CoreFeature.beforeRun(CoreFeature.java:90)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner.beforeRun(FeaturesRunner.java:198)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner.run(FeaturesRunner.java:297)
      	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:53)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:123)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:104)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
      	at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
      	at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:175)
      	at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:107)
      	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:68)
      Caused by: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO `simpletypes` (`id`, `boolean`, `string`, `textarea`, `integer`, `date`, `htmltext`) VALUES (?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:157)
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1884)
      	... 16 more
      Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO `simpletypes` (`id`, `boolean`, `string`, `textarea`, `integer`, `date`, `htmltext`) VALUES (?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:605)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:501)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:471)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:427)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:388)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:364)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:343)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:153)
      	... 17 more
      Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'htmltext' at row 1
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2028)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
      	at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeBatch(StatementWrapper.java:721)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:589)
      	... 24 more
      Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'htmltext' at row 1
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3607)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1980)
      	... 27 more
      

      https://qa.nuxeo.org/jenkins/view/Critical/job/nuxeo-master-fullbuild-part1-multidb-linux/727/Slave=MULTIDB_LINUX,dbprofile=mysql,jdk=openjdk-7-jdk/testReport/junit/org.nuxeo.ecm.diff.service/TestDiffDisplayService/org_nuxeo_ecm_diff_service_TestDiffDisplayService/
      org.nuxeo.ecm.diff.service.TestDiffDisplayService.org.nuxeo.ecm.diff.service.TestDiffDisplayService

      org.nuxeo.ecm.core.api.ClientException: Failed to save session
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1890)
      	at org.nuxeo.ecm.core.test.CoreFeature.initializeSession(CoreFeature.java:183)
      	at org.nuxeo.ecm.core.test.CoreFeature.beforeRun(CoreFeature.java:90)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner.beforeRun(FeaturesRunner.java:198)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner.run(FeaturesRunner.java:297)
      	at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:53)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:123)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:104)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
      	at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
      	at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:175)
      	at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:107)
      	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:68)
      Caused by: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO `simpletypes` (`id`, `boolean`, `string`, `textarea`, `integer`, `date`, `htmltext`) VALUES (?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:157)
      	at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1884)
      	... 16 more
      Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO `simpletypes` (`id`, `boolean`, `string`, `textarea`, `integer`, `date`, `htmltext`) VALUES (?, ?, ?, ?, ?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:605)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:501)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:471)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:427)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:388)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:364)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:343)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:153)
      	... 17 more
      Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'htmltext' at row 1
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2028)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
      	at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeBatch(StatementWrapper.java:721)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:589)
      	... 24 more
      Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'htmltext' at row 1
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3607)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1980)
      	... 27 more
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.