In case of deadlock, transaction is re-tried and generally succeeds.
On 24-Mar-2016 5:25 pm, "Ippez Robert" <ippezrob...@gmail.com> wrote:
> Hi, Adi,
> Thanks for that quick shot. I recreated the user and things seem to have
> worked pretty fine. However when i checked the fineract.log file i found
> out the below error threads. Can this affect the overall aim and results of
> all jobs? Is there another configuration that i need to do further to avoid
> this error log?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *304958 [Scheduler1group3_Worker-1] WARN
> o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 1213, SQLState: 40001304989
> [Scheduler1group3_Worker-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper -
> Deadlock found when trying to get lock; try restarting transaction305099
> [Scheduler1group3_Worker-1] ERROR org.quartz.core.ErrorLogger - Unable to
> notify TriggerListener(s) while firing trigger (Trigger and Job will NOT be
> fired!). trigger= DEFAULT.MT_1absvk13dtavq job= DEFAULT.Add Accrual
> TransactionsJobDetail1org.quartz.SchedulerException: TriggerListener
> 'Global trigger Listner' threw exception: could not extract ResultSet; SQL
> [n/a]; nested exception is
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1836)
> ~[quartz-2.1.7.jar:na] at
> org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:317)
> [quartz-2.1.7.jar:na] at
> org.quartz.core.JobRunShell.run(JobRunShell.java:180)
> [quartz-2.1.7.jar:na] at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]Caused by:
> org.springframework.dao.CannotAcquireLockException: could not extract
> ResultSet; SQL [n/a]; nested exception is
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:180)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:155)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:111)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy198.findByJobKeyWithLock(Unknown Source) ~[na:na] at
> org.apache.fineract.infrastructure.jobs.service.SchedularWritePlatformServiceJpaRepositoryImpl.processJobDetailForExecution(SchedularWritePlatformServiceJpaRepositoryImpl.java:137)
> ~[SchedularWritePlatformServiceJpaRepositoryImpl.class:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy201.processJobDetailForExecution(Unknown Source)
> ~[na:na] at
> org.apache.fineract.infrastructure.jobs.service.SchedulerTriggerListener.vetoJobExecution(SchedulerTriggerListener.java:71)
> ~[SchedulerTriggerListener.class:na] at
> org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1832)
> ~[quartz-2.1.7.jar:na] ... 3 common frames omittedCaused by:
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:451)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doQuery(Loader.java:909)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doList(Loader.java:2553)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doList(Loader.java:2539)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.list(Loader.java:2364)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
> ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
> ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at
> org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:168)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:59)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:97)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:88)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:384)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na] at
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:344)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 26 common frames
> omittedCaused by: java.sql.SQLTransactionRollbackException: Deadlock found
> when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:101)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzlePreparedStatement.executeQuery(DrizzlePreparedStatement.java:105)
> ~[drizzle-jdbc-1.3.jar:na] at
> sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source) ~[na:na] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235)
> ~[tomcat-jdbc-7.0.55.jar:na] at
> com.sun.proxy.$Proxy202.executeQuery(Unknown Source) ~[na:na] at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] ... 54 common frames
> omittedCaused by: org.drizzle.jdbc.internal.common.QueryException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.createDrizzleQueryResult(MySQLProtocol.java:313)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:480)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzlePreparedStatement.executeQuery(DrizzlePreparedStatement.java:102)
> ~[drizzle-jdbc-1.3.jar:na] ... 60 common frames omitted305130
> [Scheduler1_Worker-7] INFO o.a.f.s.s.ScheduledJobRunnerServiceImpl -
> Default Demo Tenant: Deposit accounts affected by update: 0305834
> [Scheduler1_Worker-5] WARN o.a.t.j.p.i.SlowQueryReport - Failed Query
> Report SQL=select scheduledj0_.id as id1_12_, scheduledj0_.is_active as
> is_activ2_12_, scheduledj0_.create_time as create_t3_12_,
> scheduledj0_.cron_expression as cron_exp4_12_,
> scheduledj0_.currently_running as currentl5_12_,
> scheduledj0_.initializing_errorlog as initiali6_12_,
> scheduledj0_.group_name as group_na7_12_, scheduledj0_.display_name as
> display_8_12_, scheduledj0_.job_key as job_key9_12_, scheduledj0_.name as
> name10_12_, scheduledj0_.next_run_time as next_ru11_12_,
> scheduledj0_.previous_run_start_time as previou12_12_,
> scheduledj0_.scheduler_group as schedul13_12_, scheduledj0_.task_priority
> as task_pr14_12_, scheduledj0_.is_misfired as is_misf15_12_,
> scheduledj0_.updates_allowed as updates16_12_ from job scheduledj0_ where
> scheduledj0_.job_key=? for update; time=532 ms;305850 [Scheduler1_Worker-5]
> WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 1213, SQLState:
> 40001305850 [Scheduler1_Worker-5] ERROR o.h.e.jdbc.spi.SqlExceptionHelper -
> Deadlock found when trying to get lock; try restarting transaction305868
> [Scheduler1_Worker-5] ERROR org.quartz.core.ErrorLogger - Unable to notify
> TriggerListener(s) while firing trigger (Trigger and Job will NOT be
> fired!). trigger= DEFAULT.MT_27d6g0nfcmuof job= DEFAULT.Apply penalty to
> overdue loansJobDetail1org.quartz.SchedulerException: TriggerListener
> 'Global trigger Listner' threw exception: could not extract ResultSet; SQL
> [n/a]; nested exception is
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1836)
> ~[quartz-2.1.7.jar:na] at
> org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:317)
> [quartz-2.1.7.jar:na] at
> org.quartz.core.JobRunShell.run(JobRunShell.java:180)
> [quartz-2.1.7.jar:na] at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]Caused by:
> org.springframework.dao.CannotAcquireLockException: could not extract
> ResultSet; SQL [n/a]; nested exception is
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:180)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:155)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:111)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy198.findByJobKeyWithLock(Unknown Source) ~[na:na] at
> org.apache.fineract.infrastructure.jobs.service.SchedularWritePlatformServiceJpaRepositoryImpl.processJobDetailForExecution(SchedularWritePlatformServiceJpaRepositoryImpl.java:137)
> ~[SchedularWritePlatformServiceJpaRepositoryImpl.class:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy201.processJobDetailForExecution(Unknown Source)
> ~[na:na] at
> org.apache.fineract.infrastructure.jobs.service.SchedulerTriggerListener.vetoJobExecution(SchedulerTriggerListener.java:71)
> ~[SchedulerTriggerListener.class:na] at
> org.quartz.core.QuartzScheduler.notifyTriggerListenersFired(QuartzScheduler.java:1832)
> ~[quartz-2.1.7.jar:na] ... 3 common frames omittedCaused by:
> org.hibernate.exception.LockAcquisitionException: could not extract
> ResultSet at
> org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:451)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doQuery(Loader.java:909)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doList(Loader.java:2553)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.doList(Loader.java:2539)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.Loader.list(Loader.java:2364)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
> ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at
> org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
> ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at
> org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:168)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:59)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:97)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:88)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na] at
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:384)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na] at
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:344)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 26 common frames
> omittedCaused by: java.sql.SQLTransactionRollbackException: Deadlock found
> when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:101)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzlePreparedStatement.executeQuery(DrizzlePreparedStatement.java:105)
> ~[drizzle-jdbc-1.3.jar:na] at
> sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source) ~[na:na] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235)
> ~[tomcat-jdbc-7.0.55.jar:na] at
> com.sun.proxy.$Proxy202.executeQuery(Unknown Source) ~[na:na] at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
> ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final] ... 54 common frames
> omittedCaused by: org.drizzle.jdbc.internal.common.QueryException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.createDrizzleQueryResult(MySQLProtocol.java:313)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:480)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzlePreparedStatement.executeQuery(DrizzlePreparedStatement.java:102)
> ~[drizzle-jdbc-1.3.jar:na] ... 60 common frames omitted306949
> [Scheduler1_Worker-7] INFO o.a.f.s.s.ScheduledJobRunnerServiceImpl -
> Default Demo Tenant: Savings accounts affected by update: 0307558
> [Scheduler1_Worker-4] WARN o.a.t.j.p.i.SlowQueryReport - Slow Query Report
> SQL=select MIN(je.entry_date) as entityDate from acc_gl_journal_entry je
> where je.is_running_balance_calculated=0 ; time=2843 ms;307777
> [Scheduler1group1_Worker-1] WARN o.a.t.j.p.i.SlowQueryReport - Slow Query
> Report SQL=select savingsacc0_.id as id2_116_, savingsacc0_.account_no as
> account_3_116_, savingsacc0_.account_type_enum as account_4_116_,
> savingsacc0_.activatedon_userid as activat46_116_,
> savingsacc0_.activatedon_date as activate5_116_,
> savingsacc0_.allow_overdraft as allow_ov6_116_,
> savingsacc0_.approvedon_userid as approve47_116_,
> savingsacc0_.approvedon_date as approved7_116_, savingsacc0_.client_id as
> client_48_116_, savingsacc0_.closedon_userid as closedo49_116_,
> savingsacc0_.closedon_date as closedon8_116_, savingsacc0_.currency_code as
> currency9_116_, savingsacc0_.currency_digits as currenc10_116_,
> savingsacc0_.currency_multiplesof as currenc11_116_,
> savingsacc0_.deposit_type_enum as deposit_1_116_,
> savingsacc0_.enforce_min_required_balance as enforce12_116_,
> savingsacc0_.external_id as externa13_116_, savingsacc0_.group_id as
> group_i50_116_, savingsacc0_.interest_calculation_days_in_year_type_enum as
> interes14_116_, savingsacc0_.interest_calculation_type_enum as
> interes15_116_, savingsacc0_.interest_compounding_period_enum as
> interes16_116_, savingsacc0_.interest_posting_period_enum as
> interes17_116_, savingsacc0_.lockedin_until_date_derived as lockedi18_116_,
> savingsacc0_.lockin_period_frequency as lockin_19_116_,
> savingsacc0_.lockin_period_frequency_enum as lockin_20_116_,
> savingsacc0_.min_balance_for_interest_calculation as min_bal21_116_,
> savingsacc0_.min_overdraft_for_interest_calculation as min_ove22_116_,
> savingsacc0_.min_required_balance as min_req23_116_,
> savingsacc0_.min_required_opening_balance as min_req24_116_,
> savingsacc0_.nominal_annual_interest_rate as nominal25_116_,
> savingsacc0_.nominal_annual_interest_rate_overdraft as nominal26_116_,
> savingsacc0_.on_hold_funds_derived as on_hold27_116_,
> savingsacc0_.overdraft_limit as overdra28_116_, savingsacc0_.product_id as
> product51_116_, savingsacc0_.rejectedon_userid as rejecte52_116_,
> savingsacc0_.rejectedon_date as rejecte29_116_,
> savingsacc0_.field_officer_id as field_o53_116_,
> savingsacc0_.start_interest_calculation_date as start_i30_116_,
> savingsacc0_.status_enum as status_31_116_, savingsacc0_.submittedon_userid
> as submitt54_116_, savingsacc0_.submittedon_date as submitt32_116_,
> savingsacc0_.account_balance_derived as account33_116_,
> savingsacc0_.total_annual_fees_derived as total_a34_116_,
> savingsacc0_.total_deposits_derived as total_d35_116_,
> savingsacc0_.total_fees_charge_derived as total_f36_116_,
> savingsacc0_.total_interest_earned_derived as total_i37_116_,
> savingsacc0_.total_interest_posted_derived as total_i38_116_,
> savingsacc0_.total_overdraft_interest_derived as total_o39_116_,
> savingsacc0_.total_penalty_charge_derived as total_p40_116_,
> savingsacc0_.total_withdrawal_fees_derived as total_w41_116_,
> savingsacc0_.total_withdrawals_derived as total_w42_116_,
> savingsacc0_.version as version43_116_,
> savingsacc0_.withdrawal_fee_for_transfer as withdra44_116_,
> savingsacc0_.withdrawnon_userid as withdra55_116_,
> savingsacc0_.withdrawnon_date as withdra45_116_ from m_savings_account
> savingsacc0_ where savingsacc0_.status_enum=?; time=2971 ms;308386
> [Scheduler1_Worker-6] WARN o.a.t.j.p.i.SlowQueryReport - Slow Query Report
> SQL=truncate table m_loan_paid_in_advance; time=1516 ms;310056
> [Scheduler1_Worker-4] WARN o.a.t.j.p.i.SlowQueryReport - Slow Query Report
> SQL=select je.organization_running_balance as runningBalance,je.account_id
> as accountId from acc_gl_journal_entry je inner join (select max(id) as id
> from acc_gl_journal_entry where entry_date < ? group by
> account_id,entry_date) je2 inner join (select max(entry_date) as date from
> acc_gl_journal_entry where entry_date < ? group by account_id) je3 where
> je2.id <http://je2.id> = je.id <http://je.id> and je.entry_date = je3.date
> group by je.id <http://je.id> order by je.entry_date DESC limit 0, 10000;
> time=2498 ms;311681 [Scheduler1_Worker-2] WARN o.a.t.j.p.i.SlowQueryReport
> - Slow Query Report SQL=batch; time=6966 ms;311681 [Scheduler1_Worker-2]
> INFO o.a.f.s.s.ScheduledJobRunnerServiceImpl - Default Demo Tenant:
> Results affected by update: 1118311963 [Scheduler1group3_Worker-1] WARN
> o.d.j.internal.mysql.MySQLProtocol - Could not execute query
> org.drizzle.jdbc.internal.common.query.DrizzleQuery@266c110c: Deadlock
> found when trying to get lock; try restarting transaction311963
> [Scheduler1group3_Worker-1] WARN o.a.t.j.p.i.SlowQueryReport - Failed
> Query Report SQL=update m_loan loan left join m_loan_arrears_aging laa on
> laa.loan_id = loan.id <http://loan.id> inner join m_product_loan mpl on
> mpl.id <http://mpl.id> = loan.product_id and mpl.overdue_days_for_npa is
> not null set loan.is_npa = 0 where loan.loan_status_id = 300 and
> mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
> (mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
> laa.overdue_since_date_derived is null); time=5093 ms;311978
> [Scheduler1group3_Worker-1] INFO o.s.b.f.xml.XmlBeanDefinitionReader -
> Loading XML bean definitions from class path resource
> [org/springframework/jdbc/support/sql-error-codes.xml]312025
> [Scheduler1group3_Worker-1] INFO o.s.j.support.SQLErrorCodesFactory -
> SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL,
> Oracle, PostgreSQL, Sybase]312041 [Scheduler1group3_Worker-1] ERROR
> org.quartz.core.JobRunShell - Job DEFAULT.Update Non Performing
> AssetsJobDetail1 threw an unhandled Exception:
> org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
> Invocation of method 'updateNPA' on target class [class
> com.sun.proxy.$Proxy224] failed; nested exception is
> org.springframework.dao.DeadlockLoserDataAccessException:
> StatementCallback; SQL [update m_loan loan left join m_loan_arrears_aging
> laa on laa.loan_id = loan.id <http://loan.id> inner join m_product_loan mpl
> on mpl.id <http://mpl.id> = loan.product_id and mpl.overdue_days_for_npa is
> not null set loan.is_npa = 0 where loan.loan_status_id = 300 and
> mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
> (mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
> laa.overdue_since_date_derived is null)]; Deadlock found when trying to get
> lock; try restarting transaction; nested exception is
> java.sql.SQLTransactionRollbackException: Deadlock found when trying to get
> lock; try restarting transaction at
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:331)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.quartz.core.JobRunShell.run(JobRunShell.java:213)
> ~[quartz-2.1.7.jar:na] at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]Caused by:
> org.springframework.dao.DeadlockLoserDataAccessException:
> StatementCallback; SQL [update m_loan loan left join m_loan_arrears_aging
> laa on laa.loan_id = loan.id <http://loan.id> inner join m_product_loan mpl
> on mpl.id <http://mpl.id> = loan.product_id and mpl.overdue_days_for_npa is
> not null set loan.is_npa = 0 where loan.loan_status_id = 300 and
> mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
> (mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
> laa.overdue_since_date_derived is null)]; Deadlock found when trying to get
> lock; try restarting transaction; nested exception is
> java.sql.SQLTransactionRollbackException: Deadlock found when trying to get
> lock; try restarting transaction at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:263)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:413)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:546)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.apache.fineract.scheduledjobs.service.ScheduledJobRunnerServiceImpl.updateNPA(ScheduledJobRunnerServiceImpl.java:268)
> ~[ScheduledJobRunnerServiceImpl.class:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy224.updateNPA(Unknown Source) ~[na:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
> ~[spring-core-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:322)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 3 common
> frames omittedCaused by: java.sql.SQLTransactionRollbackException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:101)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzleStatement.executeUpdate(DrizzleStatement.java:178)
> ~[drizzle-jdbc-1.3.jar:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235)
> ~[tomcat-jdbc-7.0.55.jar:na] at
> com.sun.proxy.$Proxy329.executeUpdate(Unknown Source) ~[na:na] at
> org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:535)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 24 common frames
> omittedCaused by: org.drizzle.jdbc.internal.common.QueryException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:464)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzleStatement.executeUpdate(DrizzleStatement.java:173)
> ~[drizzle-jdbc-1.3.jar:na] ... 33 common frames omitted312056
> [Scheduler1group3_Worker-1] ERROR org.quartz.core.ErrorLogger - Job
> (DEFAULT.Update Non Performing AssetsJobDetail1 threw an
> exception.org.quartz.SchedulerException: Job threw an unhandled
> exception. at org.quartz.core.JobRunShell.run(JobRunShell.java:224)
> ~[quartz-2.1.7.jar:na] at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]Caused by:
> org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
> Invocation of method 'updateNPA' on target class [class
> com.sun.proxy.$Proxy224] failed; nested exception is
> org.springframework.dao.DeadlockLoserDataAccessException:
> StatementCallback; SQL [update m_loan loan left join m_loan_arrears_aging
> laa on laa.loan_id = loan.id <http://loan.id> inner join m_product_loan mpl
> on mpl.id <http://mpl.id> = loan.product_id and mpl.overdue_days_for_npa is
> not null set loan.is_npa = 0 where loan.loan_status_id = 300 and
> mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
> (mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
> laa.overdue_since_date_derived is null)]; Deadlock found when trying to get
> lock; try restarting transaction; nested exception is
> java.sql.SQLTransactionRollbackException: Deadlock found when trying to get
> lock; try restarting transaction at
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:331)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.quartz.core.JobRunShell.run(JobRunShell.java:213)
> ~[quartz-2.1.7.jar:na] ... 1 common frames omittedCaused by:
> org.springframework.dao.DeadlockLoserDataAccessException:
> StatementCallback; SQL [update m_loan loan left join m_loan_arrears_aging
> laa on laa.loan_id = loan.id <http://loan.id> inner join m_product_loan mpl
> on mpl.id <http://mpl.id> = loan.product_id and mpl.overdue_days_for_npa is
> not null set loan.is_npa = 0 where loan.loan_status_id = 300 and
> mpl.account_moves_out_of_npa_only_on_arrears_completion = 0 or
> (mpl.account_moves_out_of_npa_only_on_arrears_completion = 1 and
> laa.overdue_since_date_derived is null)]; Deadlock found when trying to get
> lock; try restarting transaction; nested exception is
> java.sql.SQLTransactionRollbackException: Deadlock found when trying to get
> lock; try restarting transaction at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:263)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:413)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:546)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.apache.fineract.scheduledjobs.service.ScheduledJobRunnerServiceImpl.updateNPA(ScheduledJobRunnerServiceImpl.java:268)
> ~[ScheduledJobRunnerServiceImpl.class:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> com.sun.proxy.$Proxy224.updateNPA(Unknown Source) ~[na:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
> ~[spring-core-4.0.8.RELEASE.jar:4.0.8.RELEASE] at
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:322)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 3 common
> frames omittedCaused by: java.sql.SQLTransactionRollbackException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:101)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzleStatement.executeUpdate(DrizzleStatement.java:178)
> ~[drizzle-jdbc-1.3.jar:na] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_74] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_74] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_74] at java.lang.reflect.Method.invoke(Method.java:498)
> ~[na:1.8.0_74] at
> org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235)
> ~[tomcat-jdbc-7.0.55.jar:na] at
> com.sun.proxy.$Proxy329.executeUpdate(Unknown Source) ~[na:na] at
> org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:535)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
> ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE] ... 24 common frames
> omittedCaused by: org.drizzle.jdbc.internal.common.QueryException: Deadlock
> found when trying to get lock; try restarting transaction at
> org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:464)
> ~[drizzle-jdbc-1.3.jar:na] at
> org.drizzle.jdbc.DrizzleStatement.executeUpdate(DrizzleStatement.java:173)
> ~[drizzle-jdbc-1.3.jar:na] ... 33 common frames omitted*Thanks
> Regards
> Ippez
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> Mifos-developer mailing list
> mifos-develo...@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
