MySQL Forums
Forum List  »  InnoDB

Re: deadlock issue. Why is transaction waiting for an S lock when it already has an X lock?
Posted by: Richard Cook
Date: January 03, 2005 10:32PM

I just reread my post, and have a lot of typos. I apologize. Please let me clarify.

Also, I'm using version 4.0.22. The log is from a redhat box...

I'm seeing a deadlock which is confusing when I look at the log. It says here that Transaction 2 is waiting for a shared lock on the primary index of a table, one that it already has an X lock on.

Why is it waiting for an S lock, when it already has an X lock? Does it not realize this, or am I interpreting this incorrectly?

I'm looking through the source code, and see a function call lock_mode_stronger_or_eq() which I think would be used for this scenario, but I still haven't traced my way through the code...

Thanks for any help,
Rich

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: deadlock issue. Why is transaction waiting for an S lock when it already has an X lock?
2423
January 03, 2005 10:32PM


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.