CREATE TABLE $TTT ( name varchar(50) CHARACTER SET ascii NOT NULL, value bigint UNSIGNED NOT NULL, PRIMARY KEY (name) ) ENGINE=InnoDB;

insert into $TTT values ('a', 100), ('b', 100);

connA: start transaction;

connB: start transaction;

connA: update $TTT set value = 703 where name = 'b';

connB: SET SESSION innodb_lock_wait_timeout = 1;
# only to repro manually faster

connB: update $TTT set value = 703 where name = 'b';
# result is blocked by update on connA, but that is not the issue

# wait until connB finishes, ie. waiting for lock timeouts

connB: SHOW WARNINGS;
# errors is emit twice <-- here is the problem, 2 same errors!