mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
c9284ae6d1
Problem: ======== - innodb.temp_truncate_freed fails with ER_WRONG_ARGUMENTS and states that another buffer pool resize is already in progress. Test case has wait condition to ensure that buffer pool resize is completed. There is a possibility that wait condition check could get false impression that InnoDB buffer pool resize completed due to previous buffer pool resize. Fix: === Add more elaborate wait_condition to ensure the current buffer pool resize completed. buf_pool_t::resize(): Set the buffer pool resize status only after setting previous buffer pool size to current buffer pool size. This should help the test case to make reliable.
36 lines
1.4 KiB
Text
36 lines
1.4 KiB
Text
--source include/have_innodb.inc
|
|
|
|
set @old_innodb_buffer_pool_size = @@innodb_buffer_pool_size;
|
|
set @old_immediate_scrub_data_val= @@innodb_immediate_scrub_data_uncompressed;
|
|
|
|
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_immediate_scrub_data_uncompressed=1;
|
|
SET GLOBAL innodb_buffer_pool_size= 16777216;
|
|
--source include/wait_condition.inc
|
|
|
|
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, 45) = 'Completed resizing buffer pool from 16777216'
|
|
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
|
|
|
|
set global innodb_immediate_scrub_data_uncompressed = @old_immediate_scrub_data_val;
|
|
|
|
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';
|
|
set global innodb_buffer_pool_size = @old_innodb_buffer_pool_size;
|
|
--source include/wait_condition.inc
|