[ https://issues.apache.org/jira/browse/FINERACT-1936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mihaly Dallos updated FINERACT-1936: ------------------------------------ Labels: PepperSoup (was: ) > 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 > Labels: PepperSoup > Fix For: 1.9.0 > > > {{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)