MySQL Forums
Forum List  »  General

Re: Help for fixing update failure due to lock in a outer join table
Posted by: Tian Deng
Date: June 02, 2020 10:30PM

Thank you very much for your information, I'll re-check my code to see if I have any chance to make changes according to your reply.

About the workaround I'm doing now, do you think it's a usable/reasonable one?
I list the workaround here for your reference:
Currently to workaround this deadlock problem, a temporary table is created
to copy all data from TABLE_B within the stored function.

Options: ReplyQuote

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.