Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-102603

SQLIntegrityConstraintViolationException for UpgradeAssetDisplayPageEntryTest

    Description

    UpgradeAssetDisplayPageEntryTest is failing with oracle and db2 with:

         [exec] com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest > testUpgradeLocalStagingGroupMultipleArticlesMultipleVersions FAILED
         [exec]     com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=12;ROOT.JOURNALARTICLE, DRIVER=4.24.92
         [exec]     	at com.ibm.db2.jcc.am.b6.a(b6.java:806)
         [exec]     	at com.ibm.db2.jcc.am.b6.a(b6.java:66)
         [exec]     	at com.ibm.db2.jcc.am.b6.a(b6.java:140)
         [exec]     	at com.ibm.db2.jcc.am.k3.b(k3.java:2464)
         [exec]     	at com.ibm.db2.jcc.am.k3.c(k3.java:2445)
         [exec]     	at com.ibm.db2.jcc.t4.ab.n(ab.java:894)
         [exec]     	at com.ibm.db2.jcc.t4.ab.a(ab.java:119)
         [exec]     	at com.ibm.db2.jcc.t4.p.a(p.java:50)
         [exec]     	at com.ibm.db2.jcc.t4.aw.b(aw.java:220)
         [exec]     	at com.ibm.db2.jcc.am.k4.bm(k4.java:3571)
         [exec]     	at com.ibm.db2.jcc.am.k4.a(k4.java:4616)
         [exec]     	at com.ibm.db2.jcc.am.k4.b(k4.java:4154)
         [exec]     	at com.ibm.db2.jcc.am.k4.be(k4.java:821)
         [exec]     	at com.ibm.db2.jcc.am.k4.executeUpdate(k4.java:795)
         [exec]     	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
         [exec]     	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.addJournalArticle(UpgradeAssetDisplayPageEntryTest.java:190)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.createJournalArticle(UpgradeAssetDisplayPageEntryTest.java:247)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.createJournalArticles(UpgradeAssetDisplayPageEntryTest.java:267)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.testUpgradeLocalStagingGroup(UpgradeAssetDisplayPageEntryTest.java:402)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.testUpgradeLocalStagingGroupMultipleArticlesMultipleVersions(UpgradeAssetDisplayPageEntryTest.java:97)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$2.evaluate(TestExecutorRunnable.java:234)
         [exec]     	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]     	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.TimeoutTestRule$1.evaluate(TimeoutTestRule.java:89)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:143)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:181)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
         [exec]     	at java.lang.Thread.run(Thread.java:745)
         [exec] com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest > testUpgradeLocalStagingGroupMultipleArticlesMultipleVersions FAILED
         [exec]     java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LPORTAL.IX_85C52EEC) violated
         [exec] 
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
         [exec]     	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
         [exec]     	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
         [exec]     	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
         [exec]     	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
         [exec]     	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
         [exec]     	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
         [exec]     	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.addJournalArticle(UpgradeAssetDisplayPageEntryTest.java:190)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.createJournalArticle(UpgradeAssetDisplayPageEntryTest.java:247)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.createJournalArticles(UpgradeAssetDisplayPageEntryTest.java:267)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.testUpgradeLocalStagingGroup(UpgradeAssetDisplayPageEntryTest.java:402)
         [exec]     	at com.liferay.journal.upgrade.v1_1_6.test.UpgradeAssetDisplayPageEntryTest.testUpgradeLocalStagingGroupMultipleArticlesMultipleVersions(UpgradeAssetDisplayPageEntryTest.java:97)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$2.evaluate(TestExecutorRunnable.java:234)
         [exec]     	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]     	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.TimeoutTestRule$1.evaluate(TimeoutTestRule.java:89)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:143)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:181)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
         [exec]     	at java.lang.Thread.run(Thread.java:745)
         [exec]     Caused by: Error : 1, Position : 0, Sql = insert into JournalArticle (uuid_, id_, resourcePrimKey, groupId, companyId, userId, userName, createDate, modifiedDate, folderId, classNameId, classPK, treePath, layoutUuid) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 ), OriginalSql = insert into JournalArticle (uuid_, id_, resourcePrimKey, groupId, companyId, userId, userName, createDate, modifiedDate, folderId, classNameId, classPK, treePath, layoutUuid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-00001: unique constraint (LPORTAL.IX_85C52EEC) violated
         [exec] 
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
         [exec]     	... 48 more

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              brooke.dalton Brooke Dalton
              Reporter:
              brooke.dalton Brooke Dalton
              Participants of an Issue:
              Recent user:
              Jason Pince
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                6 weeks ago

                Packages

                Version Package
                7.1.X
                7.2.X
                7.2.1 CE GA2
                Master