ENGINE-03005 Execution of UPDATE - Oracle

wagner.araujo · December 12, 2018, 3:20pm

I am using version 7.10 and trying to execute the claim or complete (via REST or API) causes the following error:

ENGINE-03005 Execution of ‘UPDATE TaskEntity [46850f66-fe0f-11e8-9ea9-34238774a727]’ failed. Entity was updated by another transaction concurrently.

This error only occurs with the datasource configured for Oracle. I did the test using H2 and PostgreSQL and the error does not happen, it works perfectly.

I have tried in 2 instances of different Oracle and the error occurs for the 2 instances.

I created a simple flow and executed by TaskList and the error occurs too.

Can anybody help me ?

Yana · December 12, 2018, 4:09pm

It would help us if you provide:

Oracle version
driver version
complete stack trace of the exception

wagner.araujo · December 12, 2018, 5:01pm

Oracle Version: 11.2.0.4.0
Driver Version: ojdbc7.jar
Java Version: 10.2
Note: The error occurs via REST call or via API (claim)
Stack Trace:
14:58:19,074 ERROR [stderr] (default task-6) com.arch.exception.ValidationException: ENGINE-03005 Execution of ‘UPDATE TaskEntity[46850f66-fe0f-11e8-9ea9-34238774a727]’ failed. Entity was updated by another transaction concurrently.
14:58:19,075 ERROR [stderr] (default task-6) at deployment.admfis-web.war//br.com.jarch.bpm.util.BpmUtils.validResponse(BpmUtils.java:676)
14:58:19,075 ERROR [stderr] (default task-6) at deployment.admfis-web.war//br.com.jarch.bpm.util.BpmUtils.claim(BpmUtils.java:112)
14:58:19,076 ERROR [stderr] (default task-6) at deployment.admfis-web.war//com.arch.crud.action.BaseListTaskAction.assigneeTask(BaseListTaskAction.java:114)
14:58:19,076 ERROR [stderr] (default task-6) at deployment.admfis-web.war//br.com.dsfnet.admfis.client.bpmn.AuditoriaListaTaskAction$Proxy$_$$_WeldClientProxy.assigneeTask(Unknown Source)
14:58:19,081 ERROR [stderr] (default task-6) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:19,081 ERROR [stderr] (default task-6) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
14:58:19,081 ERROR [stderr] (default task-6) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
14:58:19,082 ERROR [stderr] (default task-6) at java.base/java.lang.reflect.Method.invoke(Method.java:564)
14:58:19,082 ERROR [stderr] (default task-6) at javax.el.api@1.0.12.Final//javax.el.ELUtil.invokeMethod(ELUtil.java:311)
14:58:19,082 ERROR [stderr] (default task-6) at javax.el.api@1.0.12.Final//javax.el.BeanELResolver.invoke(BeanELResolver.java:415)
14:58:19,083 ERROR [stderr] (default task-6) at javax.el.api@1.0.12.Final//javax.el.CompositeELResolver.invoke(CompositeELResolver.java:256)
14:58:19,083 ERROR [stderr] (default task-6) at org.glassfish.javax.el@3.0.1-b08-jbossorg-1//com.sun.el.parser.AstValue.invoke(AstValue.java:285)
14:58:19,083 ERROR [stderr] (default task-6) at org.glassfish.javax.el@3.0.1-b08-jbossorg-1//com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)
14:58:19,083 ERROR [stderr] (default task-6) at org.jboss.weld.core@3.0.5.Final//org.jboss.weld.module.web.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)
14:58:19,083 ERROR [stderr] (default task-6) at org.jboss.weld.core@3.0.5.Final//org.jboss.weld.module.web.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
14:58:19,083 ERROR [stderr] (default task-6) at org.jboss.weld.core@3.0.5.Final//org.jboss.weld.module.web.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)
14:58:19,084 ERROR [stderr] (default task-6) at org.jboss.weld.core@3.0.5.Final//org.jboss.weld.module.web.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
14:58:19,084 ERROR [stderr] (default task-6) at com.sun.jsf-impl@2.3.5.SP2//com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:107)
14:58:19,084 ERROR [stderr] (default task-6) at javax.faces.api@2.3.5.SP1//javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
14:58:19,084 ERROR [stderr] (default task-6) at com.sun.jsf-impl@2.3.5.SP2//com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
14:58:19,084 ERROR [stderr] (default task-6) at javax.faces.api@2.3.5.SP1//javax.faces.component.UICommand.broadcast(UICommand.java:330)
14:58:19,084 ERROR [stderr] (default task-6) at javax.faces.api@2.3.5.SP1//javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:870)
14:58:19,084 ERROR [stderr] (default task-6) at javax.faces.api@2.3.5.SP1//javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1418)
14:58:19,085 ERROR [stderr] (default task-6) at com.sun.jsf-impl@2.3.5.SP2//com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
14:58:19,085 ERROR [stderr] (default task-6) at com.sun.jsf-impl@2.3.5.SP2//com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
14:58:19,085 ERROR [stderr] (default task-6) at com.sun.jsf-impl@2.3.5.SP2//com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:201)
14:58:19,085 ERROR [stderr] (default task-6) at javax.faces.api@2.3.5.SP1//javax.faces.webapp.FacesServlet.service(FacesServlet.java:670)
14:58:19,085 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
14:58:19,085 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
14:58:19,086 ERROR [stderr] (default task-6) at deployment.admfis-web.war//org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:81)
14:58:19,086 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
14:58:19,086 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
14:58:19,086 ERROR [stderr] (default task-6) at io.undertow.websocket@2.0.13.Final//io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:173)
14:58:19,087 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
14:58:19,087 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
14:58:19,087 ERROR [stderr] (default task-6) at io.opentracing.contrib.opentracing-jaxrs2//io.opentracing.contrib.jaxrs2.server.SpanFinishingFilter.doFilter(SpanFinishingFilter.java:55)
14:58:19,087 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
14:58:19,087 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
14:58:19,088 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
14:58:19,088 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
14:58:19,088 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
14:58:19,088 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
14:58:19,088 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
14:58:19,089 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
14:58:19,089 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
14:58:19,089 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
14:58:19,089 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
14:58:19,090 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
14:58:19,090 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
14:58:19,090 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
14:58:19,090 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
14:58:19,090 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
14:58:19,091 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
14:58:19,091 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
14:58:19,091 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
14:58:19,091 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
14:58:19,091 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)
14:58:19,092 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
14:58:19,092 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
14:58:19,092 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
14:58:19,092 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
14:58:19,092 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
14:58:19,093 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
14:58:19,093 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
14:58:19,093 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
14:58:19,093 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
14:58:19,093 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
14:58:19,094 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
14:58:19,094 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
14:58:19,094 ERROR [stderr] (default task-6) at org.wildfly.extension.undertow@14.0.1.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)
14:58:19,094 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
14:58:19,094 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
14:58:19,095 ERROR [stderr] (default task-6) at io.undertow.servlet@2.0.13.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
14:58:19,095 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:360)
14:58:19,095 ERROR [stderr] (default task-6) at io.undertow.core@2.0.13.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
14:58:19,095 ERROR [stderr] (default task-6) at org.jboss.threads@2.3.2.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
14:58:19,095 ERROR [stderr] (default task-6) at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
14:58:19,095 ERROR [stderr] (default task-6) at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
14:58:19,096 ERROR [stderr] (default task-6) at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
14:58:19,096 ERROR [stderr] (default task-6) at java.base/java.lang.Thread.run(Thread.java:844)

Yana · December 13, 2018, 7:29am

Did you disable the batch processing?
https://docs.camunda.org/manual/7.10/user-guide/process-engine/database/#jdbc-batch-processing

wagner.araujo · December 13, 2018, 11:19am

He had not done that.
I did as suggested and added the parameter:
jdbcBatchProcessing = false
This problem has resolved but this error is now occurring
ORA-08177: can not serialize access for this transaction

Note: It worked in version 7.7 and I am now migrating to version 7.10

wagner.araujo · December 13, 2018, 11:48am

I already discovered the last problem “ORA-08177: can not serialize access for this transaction”.
I’m sorry the mistake was mine.
I had changed the transaction type without datasource.
I changed to TRANSACTION_READ_COMMITTED and the tests are running perfectly.

The hint of configuring the jdbcBatchProcessing parameter to false worked perfectly.

Thank you very much for your attention

system · January 30, 2024, 11:29am