Re: deadlock: a row being locked by a query twice?

[Amit K]

>Unless I'm missing something in this query, it can be written more efficiently >and perhaps avoid the second lock ...
>
>SELECT *
>FROM `active_user`
>WHERE `user_id`=111111 AND `identifier`='[e-mail]' and type >in('1','11','18');
>FOR UPDATE ;

Well, this query was resulting in a lot of (gap lock related) deadlocks.

To fix that I had to switch to a query that uses primary key for locking rows (the query that I have posted in my first post). As given here https://dev.mysql.com/doc/refman/5.7/en/innodb-record-level-locks.html#idm139723103153008