Memory Leak Alfresco Process Services v1.9.0

[axferreira]

We're facing an issue with Alfresco Activiti (Process Services v1.9.0) where the memory is reaching the JVM limit, CPU is usually below 10%. This is mostly happening when we make requests to the endpoint (/activiti-app/api/enterprise/tasks/query). Just wondering has anyone seen this issue before? Thanks in advance.

Config: -Xms8g -Xmx16g

References: hibernate-commons-annotations-4.0.2.Final hibernate-core-4.2.16.Final hibernate-entitymanager-4.2.16.Final hibernate-jpa-2.0-api-1.0.1.Final hibernate-jpa-2.0-api-1.0.1.Final hibernate-validator-5.3.6.Final

ndpoint: /activiti-app/api/enterprise/tasks/query Request Body: { "appDefinitionId": null, "sort": "created-desc", "size": 50, "start": 0, "text": "", "state": "completed" }

[afaust]

I have not seen such a behaviour per-se, but have had other/different issues with high memory usage in APS 1.6 through 1.9.

You specify that this happens when you make requests to that particular endpoint. Is the retained memory set in your screenshot from only that thread, i.e. on the path to the root scope of that thread? By using the memory analysis tool you are using, did you check which specific entities are maintained in the context, just so that you could identify their origin? (I.e. whether they are all tasks as I would expect if they originate from that task query)

How many completed tasks do you have in general in your database? Please check via direct SQL and compare the number with the number of entities. APS should pre-select the queried tasks to be in relation to the current user, but it also performs some access checking after entities have been loaded, so if you have many tasks in the DB, it could be that they are loaded en-masse before they would be filtered down again.

[axferreira]

Hi Axel,

Thanks for your reply.

Actually, that might not be necessarily directly related to the endpoint get tasks as I stated previously. There are scenarios where creating process instances also triggers the memory build-up. The number of completed tasks is around 300.000. Please, check the requested information below.

In relation to the query's performance, we did notice that the query below is taking too long to complete, sometimes it takes over 20 seconds.

SELECT SUB.*
FROM (select distinct RES.*, row_number() over (ORDER BY RES.START_TIME_ desc) rnk
FROM(select distinct RES.*
from ACT_HI_TASKINST RES
left join ACT_HI_IDENTITYLINK HI_OR0 on HI_OR0.TASK_ID_ = RES.ID_
WHERE
lower(RES.NAME_) like '%task%'
and RES.END_TIME_ is not null
and ((exists(select
LINK.USER_ID_
from
ACT_HI_IDENTITYLINK LINK
where
USER_ID_ = ?
and LINK.TASK_ID_ = RES.ID_)
or RES.ASSIGNEE_ = ?
or RES.OWNER_

[axferreira]

02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,533 DEBUG [pool-12-thread-4] o.h.e.j.i.JdbcCoordinatorImpl [JdbcCoordinatorImpl.java:512] - Exception clearing maxRows/queryTimeout [You can't operate on a closed Statement!!!]
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.l.Loader [Loader.java:2133] - Loading entity: [com.activiti.domain.runtime.ProcessedActivitiEvent#80958422]
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.SQL [SqlStatementLogger.java:104] - select processeda0_.LOG_NR_ as LOG_NR_1_27_0_, processeda0_.DATA_ as DATA_2_27_0_, processeda0_.EXECUTION_ID_ as EXECUTIO3_27_0_, processeda0_.PROC_DEF_ID_ as PROC_DEF4_27_0_, processeda0_.PROC_INST_ID_ as PROC_INS5_27_0_, processeda0_.TASK_ID_ as TASK_ID_6_27_0_, processeda0_.TIME_STAMP_ as TIME_STA7_27_0_, processeda0_.TYPE_ as TYPE_8_27_0_, processeda0_.USER_ID_ as USER_ID_9_27_0_ from PROCESSED_ACTIVITI_EVENTS processeda0_ where processeda0_.LOG_NR_=?
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.l.Loader [Loader.java:2157] - Done entity load
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.i.AbstractSaveEventListener [AbstractSaveEventListener.java:130] - Generated identifier: 80958422, using strategy: org.hibernate.id.Assigned
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.i.AbstractFlushingEventListener [AbstractFlushingEventListener.java:147] - Processing flush-time cascades
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.i.AbstractFlushingEventListener [AbstractFlushingEventListener.java:188] - Dirty checking collections
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.i.AbstractFlushingEventListener [AbstractFlushingEventListener.java:121] - Flushed: 1 insertions, 0 updates, 0 deletions to 133 objects
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.i.AbstractFlushingEventListener [AbstractFlushingEventListener.java:128] - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:114] - Listing entities:
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@5d9938ab, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=80958478, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:47:36.517, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@2d4bf39a, lockTime=null, isProcessed=1, lockOwner=null, type=TASK_ASSIGNED, logNr=80958477, userId=xxxx, taskId=xxxx}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:47:29.33, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@23c43f6a, lockTime=null, isProcessed=1, lockOwner=null, type=TASK_ASSIGNED, logNr=xxxx, userId=xxxx, taskId=xxxx}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:47:24.3, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@7884e91a, lockTime=null, isProcessed=1, lockOwner=null, type=TASK_CREATED, logNr=xxxx, userId=null, taskId=xxxx}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@6ccccac1, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@1ee923e1, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@1cd47039, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_UPDATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@43c78680, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@49d7c6fb, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@1e76120b, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@219cfc44, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@5e909d71, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@29876846, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@7cfd137, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:48:24.223, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@41f77356, lockTime=null, isProcessed=1, lockOwner=null, type=VARIABLE_CREATED, logNr=xxxx, userId=xxxx, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@1b56150c, lockTime=null, isProcessed=1, lockOwner=null, type=HISTORIC_ACTIVITY_INSTANCE_ENDED, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@9019b78, lockTime=null, isProcessed=1, lockOwner=null, type=HISTORIC_ACTIVITY_INSTANCE_CREATED, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@703eb506, lockTime=null, isProcessed=1, lockOwner=null, type=SEQUENCEFLOW_TAKEN, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxx, data=[B@aa91594, lockTime=null, isProcessed=1, lockOwner=null, type=HISTORIC_ACTIVITY_INSTANCE_ENDED, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=xxxxxxxxxxxxxxxxxxxxxx, processInstanceId=xxxxxxxxx, data=[B@217c8fb8, lockTime=null, isProcessed=1, lockOwner=null, type=HISTORIC_ACTIVITY_INSTANCE_ENDED, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:121] - com.activiti.domain.runtime.ActivitiEvent{timeStamp=2022-06-29 14:46:44.097, executionId=xxxxxxxx, processDefinitionId=XXXXXXXX, processInstanceId=11111111, data=[B@24111111, lockTime=null, isProcessed=1, lockOwner=null, type=HISTORIC_ACTIVITY_INSTANCE_CREATED, logNr=xxxx, userId=null, taskId=null}
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.i.u.EntityPrinter [EntityPrinter.java:118] - More......
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.SQL [SqlStatementLogger.java:104] - insert into PROCESSED_ACTIVITI_EVENTS (DATA_, EXECUTION_ID_, PROC_DEF_ID_, PROC_INST_ID_, TASK_ID_, TIME_STAMP_, TYPE_, USER_ID_, LOG_NR_) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
02:25:54 [pool-12-thread-4] 2022-06-29 14:25:54,549 DEBUG [pool-12-thread-4] o.h.e.j.s.SqlExceptionHelper [SqlExceptionHelper.java:294] - could not log warnings
java.sql.SQLException: You can't operate on a closed Statement!!!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getWarnings(NewProxyPreparedStatement.java:1812)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.handleAndClearWarnings(SqlExceptionHelper.java:291)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logAndClearWarnings(SqlExceptionHelper.java:250)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:489)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.release(JdbcCoordinatorImpl.java:381)
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.releaseStatements(AbstractBatchImpl.java:171)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:73)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1159)
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996)
at sun.reflect.GeneratedMethodAccessor3033.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298)
at com.sun.proxy.$Proxy610.flush(Unknown Source)
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.flush(SimpleJpaRepository.java:555)
at sun.reflect.GeneratedMethodAccessor3036.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:513)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:498)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:475)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy767.flush(Unknown Source)
at sun.reflect.GeneratedMethodAccessor3035.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)