SQL Queries Getting Executed For The Transaction Marked For Rollback. (Doc ID 1365201.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

We have a scenario where WebLogic Server (WLS) is taking long time to rollback transaction after customers application is initiating transaction for rollback.

And after marking the "transaction for rollback", SQL is executed for that same transaction without a transaction marked for rollback failure.

We observe the following peculiar behavior in the stack :

1.) Firstly we see the transaction being marked for roll back at 4:25:02 PM:

In the above stack trace, we see that transaction manager takes 21 seconds to rollback this transaction and why SQL queries are executed for the same transaction ID if that was marked rollback.

The application executed many SQL statements using this transaction without any errors, this is unexpected from customer perspective as they expect transactions marked for rollback to be essentially in an error/inactive state and any attempt to execute further SQL within that transaction should fail with a "transaction marked for rollback" type of error/exception.

Instead the transaction allowed the SQL to be executed and remained apparently active for 21 seconds and only then did it throw a RollbackException due to the transaction being marked for rollback.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.