[YSQL] [Pessimistic Locking]: Serialization error in lock lock conflict with wait-on-conflict enabled

Jira Link: DB-5195

Version: 2.17.1.0-b433

Steps to repro:

Create universe with flags enable_wait_queues=true and enable_deadlock_detection=true
Create database
Open 4 shells
create table tb_test(k int primary key, v int);
insert into tb_test values(1, 11);
insert into tb_test values(2, 12);
insert into tb_test values(3, 13);
T1, T2, T3, T4: begin transaction isolation level repeatable read;
T1, T2, T3, T4: select * from tb_test;
T1: select v from tb_test where k=1 for share;
T2: select v from tb_test where k=1 for key share;
T3: select v from tb_test where k=1 for share;
T4: select v from tb_test where k=1 for update;
T1: rollback;
T3: rollback;
T2: commit;

Notice that T4 fails with ERROR: could not serialize access due to concurrent update even when there is no update happening concurrently.