MySQL Forums
Forum List  »  General

Gap lock failure
Posted by: Eve Li
Date: November 26, 2025 12:33PM

Hello.

I learned that in MySQL, we could possibly insert multiple rows with the same id into a primary key field because of the gap lock failure.

I was trying to look for documentation about this, but I couldn't find any. Does anyone have any insights about this issue?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Gap lock failure
November 26, 2025 12:33PM


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.