topic ACTIVITI 6 + Spring-Boot 1.5 : MySQLIntegrityConstraintViolationException in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/activiti-6-spring-boot-1-5/m-p/36269#M15291 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I'm playing with Spring-Boot 1.5.9.RELEASE and Activiti 6.0.0 + MySQL</P><P></P><P>I started with one datasource, and&nbsp;then to 2 datasources, one for activiti, one for business entity.</P><P></P><P>I tried to change the activiti settings, to ping jdbc pool, set max transaction to 80. (And i have also a&nbsp;Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000], but this a second issue, il will create another "post")</P><P></P><P>But when i have some jobs running at the same time, i have this issue :&nbsp;<SPAN>MySQLIntegrityConstraintViolationException.</SPAN></P><P><SPAN>Even if i use one 1 or 2 datasource, even if i change some settings.</SPAN></P><P></P><P>My Bpm is compose with a "start event", some "service task" (with java class behind), this tasks are "asynchronus" and "exclusive", some "exclusive gateway" (<SPAN>"not asynchronus" &amp;&nbsp;</SPAN><SPAN>"exclusive"</SPAN>) between services, and the "end <SPAN>event"</SPAN>.</P><P></P><P>Thanks</P><P></P><P>--&nbsp;</P><P></P><P>2018-01-23 02:38:41,396 [SimpleAsyncTaskExecutor-347760] ERROR o.a.e.i.a.ExecuteAsyncRunnable - Job 352123 failed<BR />org.apache.ibatis.exceptions.PersistenceException: <BR />### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`botactiviti`.`act_ru_variable`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`))<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.deleteExecution-Inline<BR />### The error occurred while setting parameters<BR />### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?<BR />### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`botactiviti`.`act_ru_variable`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`))<BR /> at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)<BR /> at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)<BR /> at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:213)<BR /> at org.activiti.engine.impl.db.DbSqlSession.flushDeleteEntities(DbSqlSession.java:770)<BR /> at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:733)<BR /> at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:419)<BR /> at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:197)<BR /> at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:75)<BR /> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:72)<BR /> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR /> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR /> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR /> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:29)<BR /> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:44)<BR /> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:39)<BR /> at org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable.executeJob(ExecuteAsyncRunnable.java:97)<BR /> at org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable.run(ExecuteAsyncRunnable.java:75)<BR /> at java.lang.Thread.run(Thread.java:745)<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`botactiviti`.`act_ru_variable`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`))<BR /> at sun.reflect.GeneratedConstructorAccessor155.newInstance(Unknown Source)<BR /> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<BR /> at java.lang.reflect.Constructor.newInstance(Constructor.java:408)<BR /> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)<BR /> at com.mysql.jdbc.Util.getInstance(Util.java:408)<BR /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)<BR /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)<BR /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)<BR /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)<BR /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)<BR /> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)<BR /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)<BR /> at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)<BR /> at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:483)<BR /> at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)<BR /> at com.sun.proxy.$Proxy102.execute(Unknown Source)<BR /> at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)<BR /> at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)<BR /> at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)<BR /> at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)<BR /> at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)<BR /> at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)<BR /> ... 16 common frames omitted</P></BODY></HTML> Tue, 23 Jan 2018 10:25:01 GMT dgosset 2018-01-23T10:25:01Z ACTIVITI 6 + Spring-Boot 1.5 : MySQLIntegrityConstraintViolationException https://connect.hyland.com/t5/alfresco-forum/activiti-6-spring-boot-1-5/m-p/36269#M15291 Hi Community,I'm playing with Spring-Boot 1.5.9.RELEASE and Activiti 6.0.0 + MySQLI started with one datasource, and&nbsp;then to 2 datasources, one for activiti, one for business entity.I tried to change the activiti settings, to ping jdbc pool, set max transaction to 80. (And i have also a&nbsp;Timeout: Poo Tue, 23 Jan 2018 10:25:01 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-6-spring-boot-1-5/m-p/36269#M15291 dgosset 2018-01-23T10:25:01Z Re: ACTIVITI 6 + Spring-Boot 1.5 : MySQLIntegrityConstraintViolationException https://connect.hyland.com/t5/alfresco-forum/activiti-6-spring-boot-1-5/m-p/36270#M15292 <HTML><HEAD></HEAD><BODY><P style="color: #727174; background-color: #ffffff; border: 0px;">Can you share <SPAN>the process definitions and&nbsp;</SPAN>the source code service tasks in which the&nbsp;issue are reproduced?</P><P style="color: #727174; background-color: #ffffff; border: 0px;"></P><P style="color: #727174; background-color: #ffffff; border: 0px;">&gt;&nbsp;But when i have some jobs running at the same time, i have this issue :&nbsp;<SPAN style="border: 0px; font-weight: inherit;">MySQLIntegrityConstraintViolationException.</SPAN></P><P style="color: #727174; background-color: #ffffff; border: 0px;"></P><P style="color: #727174; background-color: #ffffff; border: 0px;"><SPAN style="border: 0px; font-weight: inherit;">Please tell me more about this content.</SPAN></P><P style="color: #727174; background-color: #ffffff; border: 0px;"></P><P style="color: #727174; background-color: #ffffff; border: 0px;"><SPAN style="border: 0px; font-weight: inherit;">&gt; Even if i use one 1 or 2 datasource, even if i change some settings.</SPAN></P><P style="color: #727174; background-color: #ffffff; border: 0px;"></P><P style="color: #727174; background-color: #ffffff; border: 0px;"><SPAN style="border: 0px; font-weight: inherit;">Does not the&nbsp;issue reproduce if the setting is the default?</SPAN></P></BODY></HTML> Sun, 28 Jan 2018 13:18:15 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-6-spring-boot-1-5/m-p/36270#M15292 Anonymous 2018-01-28T13:18:15Z