Norbert Táskai created FINERACT-1936:
----------------------------------------
Summary: 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
{{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)
