innodb.temp_tablespace_freed fails with ER_WRONG_ARGUMENTS

innodb.temp_truncate_freed               w28 [ fail ]

        Test ended at 2024-07-06 14:27:53

CURRENT_TEST: innodb.temp_truncate_freed

mysqltest: At line 23: query 'set global innodb_buffer_pool_size = @old_innodb_buffer_pool_size' failed: ER_WRONG_ARGUMENTS (1210): Another buffer pool resize is already in progress.

The result from queries just before the failure was:

set @old_innodb_buffer_pool_size = @@innodb_buffer_pool_size;

set @old_immediate_scrub_data_val= @@innodb_immediate_scrub_data_uncompressed;

SET GLOBAL innodb_immediate_scrub_data_uncompressed=1;

SET GLOBAL innodb_buffer_pool_size= 16777216;

CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT) ENGINE=InnoDB;

INSERT INTO t1 VALUES (repeat(1,16777215));

DROP TEMPORARY TABLE t1;

SET GLOBAL innodb_truncate_temporary_tablespace_now=1;

SET GLOBAL innodb_buffer_pool_size=10485760;

set global innodb_buffer_pool_size = @old_innodb_buffer_pool_size;

SET GLOBAL innodb_buffer_pool_size= 16777216;

CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT) ENGINE=InnoDB;

INSERT INTO t1 VALUES (repeat(1,16777215));

DROP TEMPORARY TABLE t1;

SET GLOBAL innodb_truncate_temporary_tablespace_now=1;

let $wait_timeout = 180;

let $wait_condition =

  SELECT SUBSTR(variable_value, 1, 30) = 'Completed resizing buffer pool'

  FROM information_schema.global_status

  WHERE LOWER(variable_name) = 'innodb_buffer_pool_resize_status';

SET GLOBAL innodb_buffer_pool_size=10485760;

--source include/wait_condition.inc

let $wait_condition =

  SELECT SUBSTR(variable_value, 1, 45) = 'Completed resizing buffer pool from 10485760'

  FROM information_schema.global_status

  WHERE LOWER(variable_name) = 'innodb_buffer_pool_resize_status';