Communications link failure
179 views
Skip to first unread message
Nick
Apr 4, 2018, 10:14:28 AM4/4/18
to jBPM Usage
Hi,
I got the following error from time to time. After the error I keep getting "org.hibernate.exception.JDBCConnectionException: could not prepare statement" until restarting the kie server.
I am using spring boot kie server 7.6.0.Final. Client application makes call to an API gateway application and then it acts as proxy to make request to kie server. Both the gateway application and kie server make connection to the database. When the error happened, I am very sure there isn't any problem to connect to database at least from the gateway application.
Could it be an issue of connection pool?
kie-server_1 | Hibernate: select user0_.id as id1_8_0_, user0_.birthDate as birthDat2_8_0_ from User user0_ where user0_.id=?
kie-server_1 | 2018-04-04 13:48:16.820 ERROR 5 --- [nio-8080-exec-8] o.h.engine.jdbc.spi.SqlExceptionHelper : Communications link failure
kie-server_1 |
kie-server_1 | The last packet successfully received from the server was 35,428,101 milliseconds ago. The last packet sent successfully to the server was 13 milliseconds ago.
kie-server_1 | 2018-04-04 13:48:16.905 WARN 5 --- [nio-8080-exec-8] e.l.MarshalVariablesProcessEventListener : Errer while storing process variable user due to org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
kie-server_1 | 2018-04-04 13:48:16.905 DEBUG 5 --- [nio-8080-exec-8] o.k.s.p.KieSpringTransactionManager : Current TX name (According to TransactionSynchronizationManager) : null
kie-server_1 | 2018-04-04 13:48:16.905 DEBUG 5 --- [nio-8080-exec-8] o.k.s.p.KieSpringTransactionManager : Current TX: org.springframework.transaction.support.DefaultTransactionStatus@1813d807
kie-server_1 | 2018-04-04 13:48:16.906 ERROR 5 --- [nio-8080-exec-8] o.h.engine.jdbc.spi.SqlExceptionHelper : ARJUNA017020: Transaction is not active on the thread!
kie-server_1 | 2018-04-04 13:48:17.065 WARN 5 --- [nio-8080-exec-8] o.j.s.t.p.TaskTransactionInterceptor : Could not commit session
kie-server_1 |
kie-server_1 | javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement
kie-server_1 | at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) ~[hibernate-entitymanager-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) ~[hibernate-entitymanager-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:492) ~[hibernate-entitymanager-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParameters(JPATaskPersistenceContext.java:645) ~[jbpm-human-task-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryWithParametersInTransaction(JPATaskPersistenceContext.java:457) ~[jbpm-human-task-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.commands.GetTasksForProcessCommand.execute(GetTasksForProcessCommand.java:93) ~[jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.commands.GetTasksForProcessCommand.execute(GetTasksForProcessCommand.java:34) ~[jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:80) ~[jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65) ~[jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:87) [jbpm-human-task-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:48) [jbpm-human-task-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-api-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:45) [drools-persistence-api-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.internalExecute(OptimisticLockRetryInterceptor.java:102) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:83) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:44) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.internalExecute(ExecutionErrorHandlerInterceptor.java:66) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:52) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:29) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:37) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:41) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:49) [jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.impl.command.CommandBasedTaskService.execute(CommandBasedTaskService.java:159) [jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.task.SynchronizedTaskService.execute(SynchronizedTaskService.java:851) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.services.task.admin.listener.TaskCleanUpProcessEventListener.afterProcessCompleted(TaskCleanUpProcessEventListener.java:47) [jbpm-human-task-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.event.ProcessEventSupport.fireAfterProcessCompleted(ProcessEventSupport.java:76) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.setState(WorkflowProcessInstanceImpl.java:367) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.setState(WorkflowProcessInstanceImpl.java:394) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.nodeInstanceCompleted(WorkflowProcessInstanceImpl.java:654) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.EndNodeInstance.internalTrigger(EndNodeInstance.java:71) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:179) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerNodeInstance(NodeInstanceImpl.java:373) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerCompleted(NodeInstanceImpl.java:332) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.ExtendedNodeInstanceImpl.triggerCompleted(ExtendedNodeInstanceImpl.java:44) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.StateBasedNodeInstance.triggerCompleted(StateBasedNodeInstance.java:346) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.StateBasedNodeInstance.triggerCompleted(StateBasedNodeInstance.java:323) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.WorkItemNodeInstance.triggerCompleted(WorkItemNodeInstance.java:337) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.WorkItemNodeInstance.workItemCompleted(WorkItemNodeInstance.java:400) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.WorkItemNodeInstance.signalEvent(WorkItemNodeInstance.java:376) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.signalEvent(WorkflowProcessInstanceImpl.java:496) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.processinstance.JPAWorkItemManager.completeWorkItem(JPAWorkItemManager.java:167) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at com.optabot.jbpm.workitemhandler.FBProfileWorkItemHandler.executeWorkItem(FBProfileWorkItemHandler.java:127) [fb-profile-workitemhandler-0.0.31.jar:na]
kie-server_1 | at org.drools.persistence.jpa.processinstance.JPAWorkItemManager.internalExecuteWorkItem(JPAWorkItemManager.java:69) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.WorkItemNodeInstance.internalTrigger(WorkItemNodeInstance.java:140) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:179) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerNodeInstance(NodeInstanceImpl.java:373) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerCompleted(NodeInstanceImpl.java:332) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.StartNodeInstance.triggerCompleted(StartNodeInstance.java:72) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.node.StartNodeInstance.internalTrigger(StartNodeInstance.java:43) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:179) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:38) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:233) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:450) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:209) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:193) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:185) [jbpm-flow-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:1854) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:121) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.fluent.impl.PseudoClockRunner.executeBatch(PseudoClockRunner.java:102) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.fluent.impl.PseudoClockRunner.executeBatches(PseudoClockRunner.java:69) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.fluent.impl.PseudoClockRunner.execute(PseudoClockRunner.java:61) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.fluent.impl.PseudoClockRunner.execute(PseudoClockRunner.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.PersistableRunner$TransactionInterceptor.execute(PersistableRunner.java:594) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.PersistableRunner$TransactionInterceptor.execute(PersistableRunner.java:552) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.internalExecute(OptimisticLockRetryInterceptor.java:102) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:83) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:44) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-api-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:45) [drools-persistence-api-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.internalExecute(ExecutionErrorHandlerInterceptor.java:66) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:52) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:29) [jbpm-runtime-manager-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.PersistableRunner.execute(PersistableRunner.java:398) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.persistence.PersistableRunner.execute(PersistableRunner.java:66) [drools-persistence-jpa-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:37) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:41) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:263) [drools-core-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.kie.services.impl.ProcessServiceImpl.startProcess(ProcessServiceImpl.java:110) [jbpm-kie-services-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.jbpm.kie.services.impl.ProcessServiceImpl.startProcess(ProcessServiceImpl.java:90) [jbpm-kie-services-7.6.0.Final.jar!/:7.6.0.Final]
kie-server_1 | at org.kie.server.springboot.samples.remote.rest.dialogue.DialogueResource.action(DialogueResource.java:303) [classes!/:na]
kie-server_1 | at org.kie.server.springboot.samples.remote.rest.dialogue.DialogueResource.action(DialogueResource.java:207) [classes!/:na]
kie-server_1 | at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source) ~[na:na]
kie-server_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111-internal]
kie-server_1 | at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111-internal]
kie-server_1 | at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.internal.Errors.process(Errors.java:297) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.internal.Errors.process(Errors.java:267) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) [jersey-common-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) [jersey-server-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) [jersey-container-servlet-core-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) [jersey-container-servlet-core-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) [jersey-container-servlet-core-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) [jersey-container-servlet-core-2.25.1.jar!/:na]
kie-server_1 | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) [jersey-container-servlet-core-2.25.1.jar!/:na]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakSecurityContextRequestFilter.doFilter(KeycloakSecurityContextRequestFilter.java:53) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakAuthenticatedActionsFilter.doFilter(KeycloakAuthenticatedActionsFilter.java:82) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakPreAuthActionsFilter.doFilter(KeycloakPreAuthActionsFilter.java:84) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakAuthenticationProcessingFilter.successfulAuthentication(KeycloakAuthenticationProcessingFilter.java:206) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakSecurityContextRequestFilter.doFilter(KeycloakSecurityContextRequestFilter.java:79) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakAuthenticatedActionsFilter.doFilter(KeycloakAuthenticatedActionsFilter.java:82) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakAuthenticationProcessingFilter.successfulAuthentication(KeycloakAuthenticationProcessingFilter.java:206) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.keycloak.adapters.springsecurity.filter.KeycloakPreAuthActionsFilter.doFilter(KeycloakPreAuthActionsFilter.java:84) [keycloak-spring-security-adapter-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.3.RELEASE.jar!/:4.2.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.tomcat.AbstractAuthenticatedActionsValve.invoke(AbstractAuthenticatedActionsValve.java:67) [spring-boot-container-bundle-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.keycloak.adapters.tomcat.AbstractKeycloakAuthenticatorValve.invoke(AbstractKeycloakAuthenticatorValve.java:181) [spring-boot-container-bundle-3.4.3.Final.jar!/:3.4.3.Final]
kie-server_1 | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_111-internal]
kie-server_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_111-internal]
kie-server_1 | at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.23.jar!/:8.5.23]
kie-server_1 | at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111-internal]
kie-server_1 | Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
kie-server_1 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1934) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1903) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.doQuery(Loader.java:925) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.doList(Loader.java:2622) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.doList(Loader.java:2605) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2434) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.Loader.list(Loader.java:2429) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) ~[hibernate-entitymanager-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483) ~[hibernate-entitymanager-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | ... 194 common frames omitted
kie-server_1 | Caused by: java.sql.SQLException: ARJUNA017020: Transaction is not active on the thread!
kie-server_1 | at com.arjuna.ats.internal.jdbc.ConnectionImple.checkTransaction(ConnectionImple.java:1052) ~[jdbc-5.6.4.Final.jar!/:5.6.4.Final]
kie-server_1 | at com.arjuna.ats.internal.jdbc.ConnectionImple.prepareStatement(ConnectionImple.java:193) ~[jdbc-5.6.4.Final.jar!/:5.6.4.Final]
kie-server_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.1.10.Final.jar!/:5.1.10.Final]
kie-server_1 | ... 211 common frames omitted
kie-server_1 |
kie-server_1 | 2018-04-04 13:48:17.301 ERROR 5 --- [nio-8080-exec-8] c.o.j.w.FBProfileWorkItemHandler : [food.get-customer-profile:62 - :3] -- org.hibernate.exception.GenericJDBCException: could not prepare statement
kie-server_1 |
kie-server_1 | org.jbpm.workflow.instance.WorkflowRuntimeException: [food.get-customer-profile:62 - :3] -- org.hibernate.exception.GenericJDBCException: could not prepare statement
Regards,
Nick Wong
Maciej Swiderski
Apr 11, 2018, 9:02:05 AM4/11/18
to Nick, jBPM Usage
It does look like connection pool issue, do you have a way to reproduce it?
Maciej
--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/4d7f1ac7-1816-45d5-b37d-bd43f52643b6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Nick
Apr 11, 2018, 1:21:09 PM4/11/18
to jBPM Usage
Hi Maciej,
Basically keep the spring boot kie-server running without making any request for more than 8 hours.
I made change 1. But problem persisted. Then, I add changes 2 and 3 (together with change 1). After that the problem had gone away. I believe autoReconnect=true solved the problem. However, I don't have chance yet to confirm if this particular change ONLY can solve the problem.
1. Add configurations to spring.datasource
tomcat:
testWhileIdle: true
timeBetweenEvictionRunsMillis: 60000
validationQuery: SELECT 1
spring:
datasource:
username: jbpm
password: jbpm
url: jdbc:mysql://35.197.102.137:3306/demo?autoReconnect=true
driver-class-name: com.mysql.jdbc.Driver
xa:
data-source-class-name: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
type: org.apache.tomcat.jdbc.pool.XADataSource
tomcat:
testWhileIdle: true
timeBetweenEvictionRunsMillis: 60000
validationQuery: SELECT 1
2. autoReconnect=true to connection URL e.g. jdbc:mysql://host:3306/demo?autoReconnect=true
@Bean
public EmbeddedServletContainerFactory embeddedServletContainerFactory() {
return new TomcatEmbeddedServletContainerFactory() {
@Value("${spring.datasource.username}")
private String username;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.url}")
private String url;
@Override
protected TomcatEmbeddedServletContainer getTomcatEmbeddedServletContainer(
Tomcat tomcat) {
tomcat.enableNaming();
return super.getTomcatEmbeddedServletContainer(tomcat);
}
@Override
protected void postProcessContext(Context context) {
ContextResource resource = new ContextResource();
resource.setName("jdbc/jbpm");
resource.setType(DataSource.class.getName());
resource.setProperty("factory", "org.apache.tomcat.jdbc.pool.DataSourceFactory");
resource.setProperty("driverClassName", "com.mysql.jdbc.Driver");
resource.setProperty("url", url);
resource.setProperty("username", username);
resource.setProperty("password", password);
resource.setProperty("validationQuery", "SELECT 1");
resource.setProperty("testOnBorrow", "true");
context.getNamingResources().addResource(resource);
LOGGER.debug("postProcessContext: added context resource");
}
Nick Wong
...
Nick
Apr 11, 2018, 2:36:19 PM4/11/18
to jBPM Usage
Hi Maciej,
More to add to my earlier email:
In fact, I am not very comfortable with autoReconnect setting as per https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
"autoReconnect
Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for a queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect before the next query issued on the connection in a new transaction. The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly, and is only designed to be used when you are unable to configure your application to handle SQLExceptions resulting from dead and stale connections properly. Alternatively, as a last option, investigate setting the MySQL server variable "wait_timeout" to a high value, rather than the default of 8 hours.
Default: false"
Do you have any suggestion?
Regards,
--Nick Wong
...
Maciej Swiderski
Apr 12, 2018, 2:29:28 AM4/12/18
to Nick, jBPM Usage
I would actually try to use verification of connections when connection is about to be used - like testOnBorrow or something like that. Maybe you can also clear the pool when there are no traffic - to not keep idle connections in the pool…
Maciej
--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/93f03c5d-2b54-46a7-b88a-c50999aff356%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages