GlobalTransactionRollback msg: Transaction collision: automatic transaction rollback.

hemanthsch
Padawan

Hello All,
We are facing an issue multiple times. Can anyone tell me the reason for the below error and the solution for it?
Error: "GlobalTransactionRollback msg: Transaction collision: automatic transaction rollback."

2 REPLIES 2

hemanthsch
Padawan

Thank You Jens for Your response

jens_areto
Contributor

Hello hemanthsch,

can you show some more details? For example inside the table EXA_DBA_TRANSACTION_CONFLICTS you can see which jobs are in a conflict. Maybe then with query profiling on you can show the two SQLs. For example an simultanous Update on a table which runs in parallel on the same datasets can create such a conflict. Or if you have multiple sessions open you can also see the sessions there via the session ID which you will get from the transactions_conflicts table.

Best Regards

Jens