[FINERACT-1936] StuckJob SQL is failing on Mysql & MariaDB

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Labels: PepperSoup
• Assignee: Norbert Táskai
• Reporter: Norbert Táskai
• Created: 05/Jun/23 15:34
• Updated: 07/Jan/24 10:53
• Resolved: 28/Jul/23 13:45

Description

{{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'}}
 

 

Acceptance criteria

• It should not fail with grammar error

Issue Links

• is a child of: FINERACT-1874 Release Apache Fineract 1.9.0
• links to: GitHub Pull Request #3228