MySQL Forums
Forum List  »  General

Re: Unexpected Innodb table lock
Posted by: Scott Krise
Date: February 19, 2019 08:28AM

Hello Peter,

Yes we are running 5.7.

No, we never use the "for update" clause.

We use...

UPDATE wo_weekly_rel....
INSERT INTO wo_weekly_rel....

to update our tables.

Also, we do not use transactions, rollbacks etc.

So, I guess I don't understand your last comment about breaking up the transaction into smaller pieces? The strange part is that the program deadlocks at the same place in the program every time. Its when all processing is done and its simply transferring the collected data into a temporary table to send to the report writing software. (Crystal).

The deadlock is occurring when it is deleting the old user records from the table in preparation to insert new records, and that is the very first time the table is referenced in the entire program.

Options: ReplyQuote

Written By
February 15, 2019 09:13AM
February 15, 2019 10:09AM
February 15, 2019 02:21PM
Re: Unexpected Innodb table lock
February 19, 2019 08:28AM
February 22, 2019 08:04AM
February 19, 2019 09:01AM
February 15, 2019 10:20AM

Sorry, only registered users may post in this forum.

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.