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

Could not execute JDBC batch update in SegmentsExperiment

    Description

    modules-integration-db2111

    [exec] 07:07:50,962 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] [jcc][t4][102][10040][4.24.92] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
         [exec] Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
         [exec] [jcc][t4][102][10040][4.24.92] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
         [exec] Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
         [exec] 07:07:50,972 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.SEGMENTSEXPERIMENT, DRIVER=4.24.92
         [exec] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.SEGMENTSEXPERIMENT, DRIVER=4.24.92
         [exec] 
         [exec] > Task :apps:segments:segments-test:testIntegration
         [exec] 
         [exec] com.liferay.segments.service.test.SegmentsExperimentServiceTest > testGetSegmentsExperimentsWithViewPermission FAILED
         [exec]     org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
         [exec]         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
         [exec]         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
         [exec]         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
         [exec]         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
         [exec]         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
         [exec]         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
         [exec]         at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)
         [exec]         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
         [exec]         at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260)
         [exec]         at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:89)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:136)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
         [exec]         at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.kernel.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:64)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec]         at com.sun.proxy.$Proxy743.addSegmentsExperiment(Unknown Source)
         [exec]         at com.liferay.segments.service.test.SegmentsExperimentServiceTest.testGetSegmentsExperimentsWithViewPermission(SegmentsExperimentServiceTest.java:214)
         [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:218)
         [exec]         at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [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:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [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] 
         [exec]         Caused by:
         [exec]         com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.24.92] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
         [exec]         Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
         [exec]             at com.ibm.db2.jcc.am.b6.a(b6.java:502)
         [exec]             at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:434)
         [exec]             at com.ibm.db2.jcc.am.k4.a(k4.java:5420)
         [exec]             at com.ibm.db2.jcc.am.k4.c(k4.java:4998)
         [exec]             at com.ibm.db2.jcc.am.k4.executeBatch(k4.java:3052)
         [exec]             at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
         [exec]             at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
         [exec]             at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
         [exec]             at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
         [exec]             ... 48 more
    

    modules-integration-oracle122

    [exec] 07:20:06,404 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] 07:20:06,404 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] 07:20:06,820 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] 07:20:06,820 ERROR [com.liferay.segments.test-executor-thread][JDBCExceptionReporter:234] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec] 
         [exec] 
         [exec] > Task :apps:segments:segments-test:testIntegration
         [exec] 
         [exec] com.liferay.segments.service.test.SegmentsExperimentLocalServiceTest > testGetSegmentsEntrySegmentsExperiments FAILED
         [exec]     org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
         [exec]         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
         [exec]         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
         [exec]         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
         [exec]         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
         [exec]         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
         [exec]         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
         [exec]         at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)
         [exec]         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
         [exec]         at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260)
         [exec]         at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:89)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:136)
         [exec]         at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
         [exec]         at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec]         at com.sun.proxy.$Proxy959.addSegmentsExperiment(Unknown Source)
         [exec]         at com.liferay.segments.service.test.SegmentsExperimentLocalServiceTest.testGetSegmentsEntrySegmentsExperiments(SegmentsExperimentLocalServiceTest.java:207)
         [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:218)
         [exec]         at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:79)
         [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:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:57)
         [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] 
         [exec]         Caused by:
         [exec]         java.sql.BatchUpdateException: ORA-00001: unique constraint (LPORTAL.IX_72C2980B) violated
         [exec]             at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)
         [exec]             at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)
         [exec]             at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)
         [exec]             at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)
         [exec]             at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
         [exec]             at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
         [exec]             at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
         [exec]             at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
         [exec]             ... 45 more
    

    Failing tasks: https://testray.liferay.com/home/-/testray/subtasks/692220865/view?cur=1&delta=20&testraySubtaskId=692220865

      Attachments

        Activity

          People

          • Assignee:
            joshua.itagaki Joshua Itagaki
            Reporter:
            joshua.itagaki Joshua Itagaki
            Participants of an Issue:
            Recent user:
            Brian Wulbern
            Engineering Assignee:
            Eduardo García
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

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

              Packages

              Version Package
              7.2.10 DXP FP2
              7.2.10.1 DXP SP1
              Master