Re: Deadlock information incomplete
Posted by:
Rick James
Date: August 29, 2015 11:53AM
True, I failed to 'explain' the deadlock. Instead, my answer was aimed at _avoiding_ the deadlock by (1) simplifying the sequence handling (as you did) and (2) moving it out of the transaction.
#2, I think, will guarantee that it will no longer be part of any deadlock. (Other things could cause deadlocks, but the 'sequence' seemed to be the villain this time.)
Subject
Views
Written By
Posted
2239
August 26, 2015 09:52AM
966
August 27, 2015 11:35AM
905
August 27, 2015 11:50AM
Re: Deadlock information incomplete
802
August 29, 2015 11:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.