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

StagingImplTest integration tests are failing on Oracle and DB2

    Description

    Tests in StagingImplTest class are failing when run on Oracle 12.2 or DB2 11.1

         [exec] 16:38:28,714 ERROR [com.liferay.staging.test.StagingImplTest-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] 16:38:28,716 ERROR [com.liferay.staging.test.StagingImplTest-executor-thread][JDBCExceptionReporter:234] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.LAYOUTVERSION, DRIVER=4.24.92
         [exec] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.LAYOUTVERSION, DRIVER=4.24.92
         [exec] 16:38:28,721 ERROR [com.liferay.staging.test.StagingImplTest-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] 16:38:28,722 ERROR [com.liferay.staging.test.StagingImplTest-executor-thread][JDBCExceptionReporter:234] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.LAYOUTVERSION, DRIVER=4.24.92
         [exec] Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.LAYOUTVERSION, DRIVER=4.24.92
         [exec] 16:38:28,874 ERROR [com.liferay.staging.test.StagingImplTest-executor-thread][BackgroundTaskMessageListener:173] Unable to execute background task
         [exec] com.liferay.exportimport.kernel.lar.PortletDataException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
         [exec] 	at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:433)
         [exec] 	at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:456)
         [exec] 	at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:442)
         [exec] 	at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:340)
         [exec] 	at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:78)
         [exec] 	at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:392)
         [exec] 	at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:456)
         [exec] 	at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:442)
         [exec] 	at com.liferay.exportimport.internal.controller.LayoutImportController.doImportFile(LayoutImportController.java:580)
         [exec] 	at com.liferay.exportimport.internal.controller.LayoutImportController.importFile(LayoutImportController.java:220)
         [exec] 	at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:219)
         [exec] 	at sun.reflect.GeneratedMethodAccessor1109.invoke(Unknown Source)
         [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
         [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
         [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.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec] 	at com.sun.proxy.$Proxy93.importLayouts(Unknown Source)
         [exec] 	at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:121)
         [exec] 	at com.liferay.exportimport.internal.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:285)
         [exec] 	at com.liferay.exportimport.internal.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:258)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
         [exec] 	at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39)
         [exec] 	at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
         [exec] 	at com.liferay.exportimport.internal.background.task.LayoutStagingBackgroundTaskExecutor.execute(LayoutStagingBackgroundTaskExecutor.java:145)
         [exec] 	at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:62)
         [exec] 	at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:43)
         [exec] 	at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:75)
         [exec] 	at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:132)
         [exec] 	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
         [exec] 	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
         [exec] 	at com.liferay.portal.kernel.messaging.SynchronousDestination.send(SynchronousDestination.java:41)
         [exec] 	at com.liferay.portal.kernel.test.rule.SynchronousDestinationTestRule$CleanTransactionSynchronousDestination.access$201(SynchronousDestinationTestRule.java:369)
         [exec] 	at com.liferay.portal.kernel.test.rule.SynchronousDestinationTestRule$CleanTransactionSynchronousDestination$1.call(SynchronousDestinationTestRule.java:381)
         [exec] 	at com.liferay.portal.kernel.test.rule.SynchronousDestinationTestRule$CleanTransactionSynchronousDestination$1.call(SynchronousDestinationTestRule.java:377)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
         [exec] 	at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39)
         [exec] 	at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
         [exec] 	at com.liferay.portal.kernel.test.rule.SynchronousDestinationTestRule$CleanTransactionSynchronousDestination.send(SynchronousDestinationTestRule.java:375)
         [exec] 	at com.liferay.portal.messaging.internal.DefaultMessageBus.sendMessage(DefaultMessageBus.java:309)
         [exec] 	at com.liferay.portal.kernel.messaging.MessageBusUtil.sendMessage(MessageBusUtil.java:82)
         [exec] 	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl.triggerBackgroundTask(BackgroundTaskLocalServiceImpl.java:672)
         [exec] 	at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
         [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
         [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
         [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.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec] 	at com.sun.proxy.$Proxy1195.triggerBackgroundTask(Unknown Source)
         [exec] 	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl$3.call(BackgroundTaskLocalServiceImpl.java:730)
         [exec] 	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl$3.call(BackgroundTaskLocalServiceImpl.java:726)
         [exec] 	at com.liferay.portal.kernel.transaction.TransactionCommitCallbackUtil$1.doCommitted(TransactionCommitCallbackUtil.java:43)
         [exec] 	at com.liferay.portal.kernel.transaction.NewTransactionLifecycleListener.committed(NewTransactionLifecycleListener.java:29)
         [exec] 	at com.liferay.portal.kernel.transaction.TransactionLifecycleManager.fireTransactionCommittedEvent(TransactionLifecycleManager.java:33)
         [exec] 	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._commit(DefaultTransactionExecutor.java:108)
         [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.$Proxy95.enableLocalStaging(Unknown Source)
         [exec] 	at com.liferay.exportimport.kernel.service.StagingLocalServiceUtil.enableLocalStaging(StagingLocalServiceUtil.java:88)
         [exec] 	at com.liferay.staging.test.StagingImplTest.enableLocalStaging(StagingImplTest.java:365)
         [exec] 	at com.liferay.staging.test.StagingImplTest.enableLocalStagingWithContent(StagingImplTest.java:415)
         [exec] 	at com.liferay.staging.test.StagingImplTest.testLocalStagingAssetCategories(StagingImplTest.java:149)
         [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:181)
         [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:118)
         [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:156)
         [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:77)
         [exec] 	at java.lang.Thread.run(Thread.java:745)
    

    See also on Testray

      Attachments

        Issue Links

          Activity

            People

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

              Dates

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

                Packages

                Version Package