Mysql Insert Query Slow - Process Error

Q&A
1

I'm having a problem with the execution of processes in pretty.
There is an insert query of that is getting caught in mysql and beautiful doing a rollback in the process because of it.
Anyone have any idea what it is?

Query:

insert into BN_PVM_EXEC (DBVERSION_, EVENT_UUID, NAME_, STATE_, ITERATION_ID_, WAITING_FOR_, ACT_INST_NB_, ACT_INST_ID_, NODE_, ACT_INST_, PROCESS_, PARENT_, INTERN_INST_) values (0, null, 'Desvio56', 'active', 'it8b35c1f2-4f57-48b5-855f-71f534e7e676', 0, 0, 'mainActivityInstance', 12546, null, 377, 367631, 13495);

 

Bonita Exception:

	<org.ow2.bonita.facade.exception.BonitaInternalException>

	<detailMessage>Unexpected Exception arrived in Bonita: null id in org.ow2.bonita.runtime.model.Execution entry (don&apos;t flush the Session after an exception occurs)

	</detailMessage>

	<cause class="org.hibernate.AssertionFailure">

	<detailMessage>null id in org.ow2.bonita.runtime.model.Execution entry (don&apos;t flush the Session after an exception occurs)</detailMessage>

	<stackTrace>

	<trace>org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:82)</trace>

	<trace>org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:190)</trace>

	<trace>org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:147)</trace>

	<trace>org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219)</trace>

	<trace>org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99)</trace>

	<trace>org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:58)</trace>

	<trace>org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)</trace>

	<trace>org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)</trace>

	<trace>org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)</trace>

	<trace>org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)</trace>

	<trace>org.ow2.bonita.persistence.db.DbSessionImpl.getActivityInstance(DbSessionImpl.java:1775)</trace>

	<trace>org.ow2.bonita.services.impl.AbstractDbQuerier.getActivityInstance(AbstractDbQuerier.java:130)</trace>

	<trace>org.ow2.bonita.services.impl.QuerierChainer.getActivityInstance(QuerierChainer.java:573)</trace>

	<trace>br.com.burti.bpm.bonita.recorder.ActivityInstanceRecorder.activityInstanceArgs(ActivityInstanceRecorder.java:93)</trace>

	<trace>br.com.burti.bpm.bonita.recorder.ActivityInstanceRecorder.saveActivityInstance(ActivityInstanceRecorder.java:114)</trace>

	<trace>br.com.burti.bpm.bonita.recorder.ActivityInstanceRecorder.recordActivityFailed(ActivityInstanceRecorder.java:58)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.ow2.bonita.util.Chainer.invoke(Chainer.java:95)</trace>

	<trace>$Proxy19.recordActivityFailed(Unknown Source)</trace>

	<trace>org.ow2.bonita.definition.activity.AbstractActivity.end(AbstractActivity.java:659)</trace>

	<trace>org.ow2.bonita.definition.activity.AbstractActivity.signal(AbstractActivity.java:857)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:197)</trace>

	<trace>org.ow2.bonita.definition.activity.Task_$$_javassist_20.signal(Task_$$_javassist_20.java)</trace>

	<trace>org.ow2.bonita.runtime.TaskManager.finish(TaskManager.java:233)</trace>

	<trace>org.ow2.bonita.facade.impl.RuntimeAPIImpl.finishTask(RuntimeAPIImpl.java:408)</trace>

	<trace>org.ow2.bonita.facade.impl.RuntimeAPIImpl.executeTask(RuntimeAPIImpl.java:260)</trace>

	<trace>sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.ow2.bonita.facade.APIInterceptor$APIInterceptorCommand.execute(APIInterceptor.java:115)</trace>

	<trace>org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:183)</trace>

	<trace>$Proxy23.executeTask(Unknown Source)</trace>

	<trace>sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptorCommand.doInvocation(RESTServerAPIInterceptorCommand.java:119)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptorCommand.execute(RESTServerAPIInterceptorCommand.java:97)</trace>

	<trace>org.ow2.bonita.services.impl.DefaultCommandService.execute(DefaultCommandService.java:44)</trace>

	<trace>org.ow2.bonita.runtime.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:45)</trace>

	<trace>org.ow2.bonita.services.impl.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)</trace>

	<trace>org.ow2.bonita.services.impl.RetryInterceptor.execute(RetryInterceptor.java:59)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptor.invoke(RESTServerAPIInterceptor.java:53)</trace>

	<trace>$Proxy23.executeTask(Unknown Source)</trace>

	<trace>org.ow2.bonita.facade.impl.AbstractRemoteRuntimeAPIImpl.executeTask(AbstractRemoteRuntimeAPIImpl.java:160)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:124)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:247)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:212)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:202)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:441)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:418)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:111)</trace>

	<trace>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:217)</trace>

	<trace>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:159)</trace>

	<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</trace>

	<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</trace>

	<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</trace>

	<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</trace>

	<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</trace>

	<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)</trace>

	<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</trace>

	<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</trace>

	<trace>org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)</trace>

	<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</trace>

	<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)</trace>

	<trace>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)</trace>

	<trace>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)</trace>

	<trace>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)</trace>

	<trace>java.lang.Thread.run(Thread.java:679)</trace>

	</stackTrace>

	</cause>

	<stackTrace>

	<trace>org.ow2.bonita.facade.exception.BonitaInternalException.build(BonitaInternalException.java:57)</trace>

	<trace>org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:201)</trace>

	<trace>$Proxy23.executeTask(Unknown Source)</trace>

	<trace>sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptorCommand.doInvocation(RESTServerAPIInterceptorCommand.java:119)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptorCommand.execute(RESTServerAPIInterceptorCommand.java:97)</trace>

	<trace>org.ow2.bonita.services.impl.DefaultCommandService.execute(DefaultCommandService.java:44)</trace>

	<trace>org.ow2.bonita.runtime.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:45)</trace>

	<trace>org.ow2.bonita.services.impl.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)</trace>

	<trace>org.ow2.bonita.services.impl.RetryInterceptor.execute(RetryInterceptor.java:59)</trace>

	<trace>org.ow2.bonita.facade.rest.RESTServerAPIInterceptor.invoke(RESTServerAPIInterceptor.java:53)</trace>

	<trace>$Proxy23.executeTask(Unknown Source)</trace>

	<trace>org.ow2.bonita.facade.impl.AbstractRemoteRuntimeAPIImpl.executeTask(AbstractRemoteRuntimeAPIImpl.java:160)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</trace>

	<trace>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</trace>

	<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>

	<trace>java.lang.reflect.Method.invoke(Method.java:616)</trace>

	<trace>org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:124)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:247)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:212)</trace>

	<trace>org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:202)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:441)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:418)</trace>

	<trace>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:111)</trace>

	<trace>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:217)</trace>

	<trace>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:159)</trace>

	<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</trace>

	<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</trace>

	<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</trace>

	<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</trace>

	<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</trace>

	<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)</trace>

	<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</trace>

	<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</trace>

	<trace>org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)</trace>

	<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</trace>

	<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)</trace>

	<trace>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)</trace>

	<trace>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)</trace>

	<trace>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)</trace>

	<trace>java.lang.Thread.run(Thread.java:679)</trace>

	</stackTrace>

	</org.ow2.bonita.facade.exception.BonitaInternalException> (uncaught exception) at /home/jamworks/cloud/vendor/guzzle/guzzle/src/Guzzle/Http/Exception/BadResponseException.php line 48

 

2

I thought about using Postgres, but perform a data migration serious a bit tricky. 
I tried to execute the query using a mysql client and the problem continued. 
I took a shutdown in catalina and ran the query in mysql client again and no problems. 
I noticed that in one of the cases there was a loop that was catching and running many queries at the same time. 
Fix that and everything returned to normal. 
Thank you all for your help.

3

I edited your question to add some computer code style.

4

Hi,

Just to be sure but if you run your query directly from a MySQL tool (MySQl Workbench, for example) does it works properly?

5

Could you please tell us what version of Bonita are you using, the java web server you are using, and more ? is it mandatory for you to use Mysql, or could you use PostgreSQL ?