Results 1 to 6 of 6

Thread: Spring Batch Admin - Job fails with 'Can't Serialize access for this transaction'

  1. #1

    Default Spring Batch Admin - Job fails with 'Can't Serialize access for this transaction'

    I see from forum posting that this is as a result of running two jobs simultaneously
    http://forum.springsource.org/showth...ith-Oracle-11G

    Edit: Checked the document and the default transaction Isolation is 'Serializable'. Not sure what else needs to be configured.
    Code:
    The Job failed  org.springframework.dao.CannotSerializeTransactionException: PreparedStatementCallback; SQL [INSERT into BATCH_JOB_INSTANCE(JOB_INSTANCE_ID, JOB_NAME, JOB_KEY, VERSION) values (?, ?, ?, ?)]; ORA-08177: can't serialize access for this transaction
    ; nested exception is java.sql.SQLException: ORA-08177: can't serialize access for this transaction
    I checked the logs and I did not see any other job running/executed at that time.
    Also, I am not able to resubmit the Job with the same name once this error occurs.
    This is happening very frequently. Need help in preventing this from happening again.
    Thanks

    Edit: after another attempt, the Job Ran
    Last edited by patb23@gmail.com; Mar 21st, 2013 at 06:20 AM. Reason: Adding more detail

  2. #2
    Join Date
    Sep 2008
    Location
    Chicagoland, IL
    Posts
    351

    Default

    I assume this is occurring on startup?
    Michael Minella
    Spring Batch Lead
    Author - Pro Spring Batch
    http://www.michaelminella.com
    Twitter: @MichaelMinella

  3. #3

    Default

    It happened few times but not at the start up. We have configured 12 jobs but when the exception start happening, only a restart seems to be of help. Please note that the Job params are unique. Are there any other reasons other than mentioned in the link above?
    Thanks

  4. #4

    Default

    Hi,
    It happened again. I could not find a solution for this yet.
    Thanks

  5. #5

    Default

    If lowering the isolation level would help?

  6. #6
    Join Date
    Sep 2008
    Location
    Chicagoland, IL
    Posts
    351

    Default

    How are you launching your jobs?
    Michael Minella
    Spring Batch Lead
    Author - Pro Spring Batch
    http://www.michaelminella.com
    Twitter: @MichaelMinella

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •