drop table if exists t1;
Warnings:
Note	1051	Unknown table 'test.t1'
create table t1 (a int primary key);
insert into t1 values(42);
set global xengine_force_flush_memtable_now = 1;
show variables like 'autocommit';
Variable_name	Value
autocommit	ON
set global xengine_hotbackup = 'checkpoint';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'acquire';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'incremental';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'release';
ERROR HY000: XEngine: should begin a trx first
set autocommit = 0;
set global xengine_hotbackup = 'checkpoint';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'acquire';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'incremental';
ERROR HY000: XEngine: should begin a trx first
set global xengine_hotbackup = 'release';
ERROR HY000: XEngine: should begin a trx first
set autocommit = 1;
begin;
set global xengine_hotbackup = 'acquire';
ERROR HY000: XEngine: should execute command: checkpoint before this command

rollback;
begin;
set global xengine_hotbackup = 'incremental';
ERROR HY000: XEngine: should execute command: acquire before this command

rollback;
begin;
set global xengine_hotbackup = 'release';
ERROR HY000: XEngine: should execute command: incremental before this command

rollback;
begin;
set global xengine_hotbackup = 'checkpoint';
set global xengine_hotbackup = 'incremental';
ERROR HY000: XEngine: should execute command: acquire before this command

rollback;
begin;
set global xengine_hotbackup = 'checkpoint';
select * from t1;
a
42
set global xengine_hotbackup = 'release';
ERROR HY000: XEngine: should execute command: incremental before this command

rollback;
begin;
set global xengine_hotbackup = 'checkpoint';
select * from t1;
a
42
set global xengine_hotbackup = 'acquire';
set global xengine_hotbackup = 'release';
ERROR HY000: XEngine: should execute command: incremental before this command

rollback;
begin;
set global xengine_hotbackup = 'checkpoint';
begin;
set global xengine_hotbackup = 'checkpoint';
ERROR HY000: XEngine: there is another backup job running

rollback;
rollback;
drop table t1;