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

Fix unit tests tear down on Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 8.4-SNAPSHOT
    • Fix Version/s: 8.10-HF01, 9.1
    • Component/s: Explorer
    • Tags:
    • Sprint:
      nxSL Sprint 8.4.4, nxSL Sprint 8.4.5, nxSL Sprint 8.10.2, nxSL Sprint 9.1.1, nxSL Sprint 9.1.3
    • Story Points:
      5

      Description

      See job at https://qa.nuxeo.org/jenkins/view/reports/job/master/job/nuxeo-master-fullbuild-part1-multidb-linux/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/

      Several random failures

      on org.nuxeo.apidoc.test.TestSnapshotWithDocPersist.testPersistWithLiveDoc at https://qa.nuxeo.org/jenkins/view/reports/job/master/job/nuxeo-master-fullbuild-part1-multidb-linux/98/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/testReport/org.nuxeo.apidoc.test/TestSnapshotWithDocPersist/testPersistWithLiveDoc/

      java.lang.AssertionError
	at org.junit.Assert.fail(Assert.java:86)
	at org.junit.Assert.assertTrue(Assert.java:41)
	at org.junit.Assert.assertTrue(Assert.java:52)
	at org.nuxeo.ecm.core.test.TransactionalFeature.nextTransaction(TransactionalFeature.java:79)
	at org.nuxeo.ecm.core.test.TransactionalFeature.nextTransaction(TransactionalFeature.java:64)
	at org.nuxeo.ecm.core.test.CoreFeature.waitForAsyncCompletion(CoreFeature.java:227)
	at org.nuxeo.ecm.core.test.CoreFeature.cleanupSession(CoreFeature.java:231)
	at org.nuxeo.ecm.core.test.CoreFeature.afterTeardown(CoreFeature.java:220)

      on org.nuxeo.apidoc.test.TestSnapshotWithDocPersist.org.nuxeo.apidoc.test.TestSnapshotWithDocPersist https://qa.nuxeo.org/jenkins/view/reports/job/master/job/nuxeo-master-fullbuild-part1-multidb-linux/98/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/testReport/org.nuxeo.apidoc.test/TestSnapshotWithDocPersist/org_nuxeo_apidoc_test_TestSnapshotWithDocPersist/

      java.lang.AssertionError
	at org.junit.Assert.fail(Assert.java:86)
	at org.junit.Assert.assertTrue(Assert.java:41)
	at org.junit.Assert.assertTrue(Assert.java:52)
	at org.nuxeo.ecm.core.test.TransactionalFeature.nextTransaction(TransactionalFeature.java:79)
	at org.nuxeo.ecm.core.test.TransactionalFeature.nextTransaction(TransactionalFeature.java:64)
	at org.nuxeo.ecm.core.test.CoreFeature.waitForAsyncCompletion(CoreFeature.java:227)
	at org.nuxeo.ecm.core.test.CoreFeature.afterRun(CoreFeature.java:185)

      on org.nuxeo.apidoc.test.TestSnapshotPersist.org.nuxeo.apidoc.test.TestSnapshotPersist

      https://qa.nuxeo.org/jenkins/view/reports/job/master/job/nuxeo-master-fullbuild-part1-multidb-linux/99/Slave=MULTIDB_LINUX,dbprofile=oracle12c,jdk=java-8-oracle/testReport/org.nuxeo.apidoc.test/TestSnapshotPersist/org_nuxeo_apidoc_test_TestSnapshotPersist/

      java.lang.AssertionError: invoke on features error [Holder [type=class org.nuxeo.runtime.test.runner.MDCFeature], Holder [type=class org.nuxeo.runtime.test.runner.ConditionalIgnoreRule$Feature], Holder [type=class org.nuxeo.runtime.test.runner.RandomBug$Feature], Holder [type=class org.nuxeo.runtime.test.runner.RuntimeFeature], Holder [type=class org.nuxeo.runtime.test.runner.ContainerFeature], Holder [type=class org.nuxeo.ecm.core.test.TransactionalFeature], Holder [type=class org.nuxeo.ecm.core.test.CoreFeature], Holder [type=class org.nuxeo.elasticsearch.test.RepositoryElasticSearchFeature], Holder [type=class org.nuxeo.ecm.platform.login.test.ClientLoginFeature], Holder [type=class org.nuxeo.ecm.directory.sql.SQLDirectoryFeature], Holder [type=class org.nuxeo.ecm.platform.test.PlatformFeature], Holder [type=class org.nuxeo.ecm.automation.test.AutomationFeature], Holder [type=class org.nuxeo.apidoc.test.RuntimeSnaphotFeature]]
	at org.nuxeo.runtime.test.runner.FeaturesLoader.apply(FeaturesLoader.java:124)
	at org.nuxeo.runtime.test.runner.FeaturesLoader.apply(FeaturesLoader.java:114)
	at org.nuxeo.runtime.test.runner.FeaturesRunner.start(FeaturesRunner.java:193)
	at org.nuxeo.runtime.test.runner.FeaturesRunner$BeforeClassStatement.evaluate(FeaturesRunner.java:264)
	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.junit.runners.Suite.runChild(Suite.java:127)
	at org.junit.runners.Suite.runChild(Suite.java:26)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:138)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.createRequestAndRun(JUnitCoreWrapper.java:113)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.executeEager(JUnitCoreWrapper.java:85)
	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:54)
	at org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:134)
	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
	Suppressed: org.nuxeo.ecm.core.api.NuxeoException: java.sql.SQLException: ORA-14452: attempt to create, alter or drop an index on temporary table already in use

		at org.nuxeo.ecm.core.test.StorageConfiguration.initJDBC(StorageConfiguration.java:148)
		at org.nuxeo.ecm.core.test.StorageConfiguration.init(StorageConfiguration.java:117)
		at org.nuxeo.ecm.core.test.CoreFeature.start(CoreFeature.java:149)
		at org.nuxeo.runtime.test.runner.FeaturesRunner$6.call(FeaturesRunner.java:197)
		at org.nuxeo.runtime.test.runner.FeaturesLoader.apply(FeaturesLoader.java:127)
		... 22 more
	Caused by: java.sql.SQLException: ORA-14452: attempt to create, alter or drop an index on temporary table already in use

		at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
		at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
		at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
		at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
		at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
		at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
		at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
		at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
		at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
		at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
		at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
		at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
		at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
		at org.nuxeo.ecm.core.storage.sql.DatabaseHelper.executeSql(DatabaseHelper.java:195)
		at org.nuxeo.ecm.core.storage.sql.DatabaseHelper.doOnAllTables(DatabaseHelper.java:188)
		at org.nuxeo.ecm.core.storage.sql.DatabaseOracle.setUp(DatabaseOracle.java:73)
		at org.nuxeo.ecm.core.test.StorageConfiguration.initJDBC(StorageConfiguration.java:146)
		... 26 more

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-20338 Infinite loop in Drive remote scan of a non synchronization root with Redis enabled

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: