CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu'; ALTER UNDO TABLESPACE undo_003 SET INACTIVE; let $inactive_undo_space = undo_003; source include/wait_until_undo_space_is_empty.inc; SELECT ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='undo_003'; SET DEBUG_SYNC = 'drop_undo SIGNAL drop_started WAIT_FOR rotate_started'; --send DROP UNDO TABLESPACE undo_003; connect (con1,localhost,root,,); --connection con1 SET DEBUG_SYNC = 'now WAIT_FOR drop_started'; SET DEBUG_SYNC = 'undo_rotate SIGNAL rotate_started'; --send ALTER INSTANCE ROTATE INNODB MASTER KEY; --connection default --reap --connection con1 --reap --connection default --disconnect con1 SET DEBUG_SYNC='RESET';