Hi Flowable Team,
I have updated my application to Flowable 6.3.0 and Spring Boot 2.0. Getting the below exception.
Please help me resolve this issue.
2018-04-19 13:45:45.461 WARN [myapp,,,] 1 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean 'springProcessEngineConfiguration'; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?)
### Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
2018-04-19 13:45:45.465 INFO [myapp,,,] 1 --- [ main] o.s.s.c.ThreadPoolTaskScheduler : Shutting down ExecutorService 'taskScheduler'
2018-04-19 13:45:45.466 INFO [myapp,,,] 1 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Unregistering JMX-exposed beans on shutdown
2018-04-19 13:45:45.467 INFO [myapp,,,] 1 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Unregistering JMX-exposed beans
2018-04-19 13:45:45.471 INFO [myapp,,,] 1 --- [ main] o.f.j.s.i.a.AbstractAsyncExecutor : Shutting down the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].
2018-04-19 13:45:45.471 INFO [myapp,,,] 1 --- [uire-timer-jobs] o.f.j.s.i.a.AcquireTimerJobsRunnable : stopped async job due acquisition
2018-04-19 13:45:45.471 INFO [myapp,,,] 1 --- [uire-async-jobs] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable : stopped async job due acquisition
2018-04-19 13:45:45.474 INFO [myapp,,,] 1 --- [et-expired-jobs] o.f.j.s.i.a.ResetExpiredJobsRunnable : stopped resetting expired jobs
2018-04-19 13:45:45.996 INFO [myapp,,,] 1 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2018-04-19 13:45:46.005 WARN [myapp,,,] 1 --- [ost-startStop-1] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:43)
2018-04-19 13:45:46.005 WARN [myapp,,,] 1 --- [ost-startStop-1] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [AsyncReporter{URLConnectionSender{http://zipkin.manager.om.laptop.dmsuitecloud.com/}}] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
sun.misc.Unsafe.park(Native Method)
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
zipkin2.reporter.ByteBoundedQueue.drainTo(ByteBoundedQueue.java:81)
zipkin2.reporter.AsyncReporter$BoundedAsyncReporter.flush(AsyncReporter.java:243)
zipkin2.reporter.AsyncReporter$Builder$1.run(AsyncReporter.java:179)
2018-04-19 13:45:46.059 INFO [myapp,,,] 1 --- [ main] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2018-04-19 13:45:46.062 ERROR [myapp,,,] 1 --- [ main] o.s.boot.SpringApplication : Application run failed
org.springframework.context.ApplicationContextException: Failed to start bean 'springProcessEngineConfiguration'; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?)
### Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:184) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:157) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:121) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:161) ~[spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) [spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:388) [spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) [spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1246) [spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1234) [spring-boot-2.0.0.RELEASE.jar!/:2.0.0.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [myapp.jar:5.0-SNAPSHOT]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [myapp.jar:5.0-SNAPSHOT]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [myapp.jar:5.0-SNAPSHOT]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [myapp.jar:5.0-SNAPSHOT]
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
### The error may involve org.flowable.engine.impl.persistence.entity.ResourceEntityImpl.bulkInsertResource-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?)
### Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.flowable.engine.common.impl.db.DbSqlSession.flushBulkInsert(DbSqlSession.java:470) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:426) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:403) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.db.DbSqlSession.flush(DbSqlSession.java:288) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.interceptor.CommandContext.flushSessions(CommandContext.java:191) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.interceptor.CommandContext.close(CommandContext.java:61) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:80) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.idm.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:49) ~[flowable-idm-spring-6.3.0.jar!/:6.3.0]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
at org.flowable.idm.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:46) ~[flowable-idm-spring-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.common.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51) ~[flowable-engine-common-6.3.0.jar!/:6.3.0]
at org.flowable.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:94) ~[flowable-engine-6.3.0.jar!/:6.3.0]
at org.flowable.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:203) ~[flowable-engine-6.3.0.jar!/:6.3.0]
at org.flowable.spring.configurator.DefaultAutoDeploymentStrategy.deployResources(DefaultAutoDeploymentStrategy.java:61) ~[flowable-spring-6.3.0.jar!/:6.3.0]
at org.flowable.spring.SpringProcessEngineConfiguration.autoDeployResources(SpringProcessEngineConfiguration.java:118) ~[flowable-spring-6.3.0.jar!/:6.3.0]
at org.flowable.spring.SpringProcessEngineConfiguration.lambda$start$0(SpringProcessEngineConfiguration.java:197) ~[flowable-spring-6.3.0.jar!/:6.3.0]
at java.util.ArrayList.forEach(ArrayList.java:1249) ~[na:1.8.0_111]
at org.flowable.spring.SpringProcessEngineConfiguration.start(SpringProcessEngineConfiguration.java:197) ~[flowable-spring-6.3.0.jar!/:6.3.0]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:181) ~[spring-context-5.0.4.RELEASE.jar!/:5.0.4.RELEASE]
... 22 common frames omitted
Caused by: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (531,294 > 65,535). You can change this value on the server by setting the 'max_allowed_packet' variable.
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:100) ~[mysql-connector-java-6.0.6.jar!/:6.0.6]
at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) ~[mysql-connector-java-6.0.6.jar!/:6.0.6]
at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826) ~[mysql-connector-java-6.0.6.jar!/:6.0.6]
at com.mysql.cj.jdbc.PreparedStatement.execute(PreparedStatement.java:1153) ~[mysql-connector-java-6.0.6.jar!/:6.0.6]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.4.5.jar!/:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) ~[mybatis-3.4.5.jar!/:3.4.5]
... 44 common frames omitted