Re: Deadlock issue and table lock frequently
Posted by:
Rick James
Date: August 18, 2015 09:23PM
I call this an application error: "UPDATEing attribute_id='85' at the same time that you are INSERTing that same record".
Look at the code that sets `attribute_id`; perhaps it is not transaction safe? Perhaps two different threads are grabbing 85, but don't get into trouble until the code you see?
Subject
Views
Written By
Posted
2344
August 07, 2015 02:57AM
914
August 07, 2015 10:09PM
1004
August 17, 2015 02:50AM
Re: Deadlock issue and table lock frequently
923
August 18, 2015 09:23PM
3022
August 20, 2015 12:06AM
1144
August 22, 2015 01:45PM
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.