[
https://issues.apache.org/jira/browse/FINERACT-1936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihaly Dallos resolved FINERACT-1936.
-------------------------------------
Resolution: Fixed
> StuckJob SQL is failing on Mysql & MariaDB
> ------------------------------------------
>
> Key: FINERACT-1936
> URL: https://issues.apache.org/jira/browse/FINERACT-1936
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Norbert Táskai
> Assignee: Norbert Táskai
> Priority: Major
>
> {{Exception in thread "SimpleAsyncTaskExecutor-10"
> org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
> bad SQL grammar [SELECT DISTINCT(bji.JOB_NAME) as STUCK_JOB_NAMEFROM
> BATCH_JOB_INSTANCE bji
> INNER JOIN BATCH_JOB_EXECUTION bje
> ON bji.JOB_INSTANCE_ID = bje.JOB_INSTANCE_ID
> WHERE
> bje.STATUS IN (?)
> AND
> bje.JOB_INSTANCE_ID NOT IN (
> SELECT bje.JOB_INSTANCE_ID
> FROM BATCH_JOB_INSTANCE bji
> INNER JOIN BATCH_JOB_EXECUTION bje
> ON bji.JOB_INSTANCE_ID = bje.JOB_INSTANCE_ID
> WHERE bje.STATUS IN (?, ?, ?)
> )
> GROUP BY BJI.JOB_INSTANCE_ID
> HAVING COUNT(BJI.JOB_INSTANCE_ID) <= ?
> ]; nested exception is java.sql.SQLSyntaxErrorException: (conn=112) Unknown
> column 'BJI.JOB_INSTANCE_ID' in 'group statement'}}
>
> {panel}
> {panel}
> {panel}
> *Acceptance criteria*
> * It should not fail with grammar error
> {panel}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
