53 lines
1.3 KiB
Plaintext
53 lines
1.3 KiB
Plaintext
--echo #
|
|
--echo # InnoDB supports CREATE/ALTER/DROP UNDO TABLESPACE
|
|
--echo # Show that up to 125 explicit undo tablespaces can be created.
|
|
--echo #
|
|
|
|
--source include/big_test.inc
|
|
--source include/have_innodb_default_undo_tablespaces.inc
|
|
|
|
let $cnt = 3;
|
|
while ($cnt <= 127)
|
|
{
|
|
let $undo_space_name = undo_$cnt;
|
|
let $datafile = undo_$cnt.ibu;
|
|
eval CREATE UNDO TABLESPACE $undo_space_name ADD DATAFILE '$datafile';
|
|
inc $cnt;
|
|
}
|
|
|
|
--error ER_CREATE_FILEGROUP_FAILED
|
|
CREATE UNDO TABLESPACE undo_128 ADD DATAFILE 'undo_128.ibu';
|
|
SHOW WARNINGS;
|
|
|
|
let $cnt = 3;
|
|
while ($cnt <= 127)
|
|
{
|
|
let $undo_space_name = undo_$cnt;
|
|
eval ALTER UNDO TABLESPACE $undo_space_name SET INACTIVE;
|
|
inc $cnt;
|
|
}
|
|
|
|
--echo # Wait for all explicit undo tablespaces to become empty.
|
|
let $cnt = 3;
|
|
while ($cnt <= 127)
|
|
{
|
|
let $inactive_undo_space = undo_$cnt;
|
|
source include/wait_until_undo_space_is_empty.inc;
|
|
inc $cnt;
|
|
}
|
|
|
|
--echo # Drop all explicit undo tablespaces.
|
|
let $cnt = 3;
|
|
while ($cnt <= 127)
|
|
{
|
|
let $undo_space_name = undo_$cnt;
|
|
eval DROP UNDO TABLESPACE $undo_space_name;
|
|
inc $cnt;
|
|
}
|
|
|
|
--disable_query_log
|
|
call mtr.add_suppression("\\[Warning\\] .* Log writer is waiting for checkpointer to to catch up lag");
|
|
call mtr.add_suppression("\\[ERROR\\] .* Cannot create undo tablespace undo_128 at undo_128.ibu because 127 undo tablespaces already exist");
|
|
--enable_query_log
|
|
|