--source include/have_debug.inc --echo # --echo # Bug #21348684 SIGABRT DURING RESIZING THE INNODB BUFFER POOL --echo # ONLINE WITH MEMORY FULL CONDITION --echo # --disable_query_log call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Cannot allocate .*"); call mtr.add_suppression(".* failed to allocate the chunk array"); call mtr.add_suppression(".* failed to allocate new memory"); call mtr.add_suppression(".* failed; errno 12"); set @before_innodb_buffer_pool_size = @@innodb_buffer_pool_size; --enable_query_log SET GLOBAL DEBUG='+d,buf_pool_resize_chunk_null'; --echo # Setting innodb buffer pool size 10MB more than before SET GLOBAL innodb_buffer_pool_size=@before_innodb_buffer_pool_size + 10485760; let $wait_timeout = 60; let $wait_condition = SELECT SUBSTR(variable_value, 1, 27) = 'Resizing buffer pool failed' FROM performance_schema.global_status WHERE LOWER(variable_name) = 'innodb_buffer_pool_resize_status'; --source include/wait_condition.inc SET GLOBAL DEBUG='-d,buf_pool_resize_chunk_null'; SET GLOBAL innodb_buffer_pool_size=@before_innodb_buffer_pool_size; # SELECT SUBSTR(variable_value, 1, 9) = 'Completed' # SELECT SUBSTR(variable_value, 1, 19) = 'Size did not change' let $wait_timeout = 60; let $wait_condition = SELECT SUBSTR(variable_value, 1, 9) = 'Completed' FROM performance_schema.global_status WHERE LOWER(variable_name) = 'innodb_buffer_pool_resize_status'; --source include/wait_condition.inc # The state is not reverting back to original somehow, restart is needed if this # case is to be tested again. --source include/force_restart.inc