ORA-08177 can't serialize access for this transaction

[prasanthks81]

Getting below ORA-08177 issue when multiple Spring batch jobs are triggered at the same time.

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO BATCH_JOB_EXECUTION(JOB_EXECUTION_ID, JOB_INSTANCE_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, VERSION, CREATE_TIME, LAST_UPDATED)
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
]; SQL state [72000]; error code [8177]; ORA-08177: can't serialize access for this transaction

Property already added to set the Transaction isolation level as READ_COMMITTED

• spring.batch.jdbc.isolation-level-for-create=READ_COMMITTED
• spring.datasource.hikari.transaction-isolation=TRANSACTION_READ_COMMITTED

Versions used

• Spring Boot version: 3.3.2
• Spring Batch version: 5.1.0
• Oracle Database version: 19.14
• JDBC Driver: ojdbc11
• HikariCP version: 5.0.1

[prasanthks81]

Friendly reminder - Could you please provide an update on this?

[fmbenhassine]

Indeed, the issue should be resolved if you lower the transaction's isolation level.

However, the following is incorrect:

spring.batch.jdbc.isolation-level-for-create=READ_COMMITTED
spring.datasource.hikari.transaction-isolation=TRANSACTION_READ_COMMITTED

It should be:

spring.batch.jdbc.isolation-level-for-create=ISOLATION_READ_COMMITTED
spring.datasource.hikari.transaction-isolation=ISOLATION_READ_COMMITTED

There is a sample in the docs here: https://docs.spring.io/spring-batch/reference/job/configuring-repository.html#txConfigForJobRepository

Have you tried that?