MySQL Forums
Forum List  »  General

Re: Unexpected Innodb table lock
Posted by: Scott Krise
Date: February 15, 2019 02:21PM

Its C++ used in coordination with QT.

It will evaluate to the users name..."kathy" if you are looking at the error log messages I posted.

Again, this is a shared temp table and the records in the table tagged with your user name are yours. The delete query is simply going in, deleting all the records that belong to you, then putting updated records based on the report parameters for this run.

I think its a file lock (or maybe a deadlock?) since no two users would ever be deleting the same records at the same time...they would be deleting records tagged with their name in the user field only.

It makes no sense to me why deleting one record would stop you from deleting a different one.

Options: ReplyQuote

Written By
February 15, 2019 09:13AM
February 15, 2019 10:09AM
Re: Unexpected Innodb table lock
February 15, 2019 02:21PM
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.