--source include/have_partition.inc

--source include/have_sequence.inc

--source include/have_innodb.inc

call mtr.add_suppression("is out of LIMIT, need more HISTORY partitions");

create table t (pk int primary key, a int) engine=InnoDB

  with system versioning partition by system_time limit 100 auto;

insert into t select seq, seq from seq_1_to_90;

replace into t select seq, seq from seq_1_to_90;

--connect (con1,localhost,root,,)

set lock_wait_timeout= 3;

begin;

update t set a = a + 100 where pk < 20;

--connect (con2,localhost,root,,)

set lock_wait_timeout= 3;

begin;

--send

  update t set a = a + 10 where pk = 30;

--connect (con3,localhost,root,,)

set lock_wait_timeout= 3;

begin;

--send

  update t set a = a + 10 where pk = 40;

--connection con1

select now();

update t set a = a + 100 where pk < 20;

select now();

--connection con2

--reap

commit;

--connection con3

--reap

commit;

--connection con1

commit;

# Cleanup

drop table t;

connection con1;

select now();

now()

2021-04-28 00:43:15

update t set a = a + 100 where pk < 20;

Warnings:

Error	1205	Lock wait timeout exceeded; try restarting transaction

Warning	4114	Versioned table `test`.`t`: last HISTORY partition (`p0`) is out of LIMIT, need more HISTORY partitions

select now();

now()

2021-04-28 00:43:24