Mysql Insert Query Slow - Process Error

Submitted by caio____ on Wed, 01/29/2014 - 19:01
1
0
-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

Comments

Submitted by ttoine on Fri, 01/31/2014 - 16:18

I edited your question to add some computer code style.

Permalink
Submitted by rafael.vianna on Mon, 02/03/2014 - 17:28

Hi,

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

Permalink
Submitted by ttoine on Tue, 02/04/2014 - 14:14

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 ?

Permalink
1 answer

Submitted by caio____ on Tue, 02/04/2014 - 14:49
1
0
-1

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.

  • 263 reads
Notifications