[go: up one dir, main page]

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-08177 can't serialize access for this transaction #4725

Open
prasanthks81 opened this issue Nov 29, 2024 · 0 comments
Open

ORA-08177 can't serialize access for this transaction #4725

prasanthks81 opened this issue Nov 29, 2024 · 0 comments
Labels
status: waiting-for-triage Issues that we did not analyse yet type: bug

Comments

@prasanthks81
Copy link

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 prasanthks81 added status: waiting-for-triage Issues that we did not analyse yet type: bug labels Nov 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: waiting-for-triage Issues that we did not analyse yet type: bug
Projects
None yet
Development

No branches or pull requests

1 participant