| 1 |
# Bug #31329634 ASSERTION FAILURE: |
| 2 |
# LOCK0LATCHES.CC:42:LOCK_SYS->REC_HASH->N_CELLS == LOCK_SYS->P |
| 3 |
SELECT @@innodb_buffer_pool_size; |
| 4 |
@@innodb_buffer_pool_size |
| 5 |
17825792 |
| 6 |
SELECT @@innodb_buffer_pool_chunk_size; |
| 7 |
@@innodb_buffer_pool_chunk_size |
| 8 |
1048576 |
| 9 |
CREATE TABLE t1 (id INT PRIMARY KEY, val VARCHAR(1000)) ENGINE=INNODB; |
| 10 |
INSERT INTO t1 (id,val) VALUES (1,''),(2,''),(3,''),(4,''),(5,''); |
| 11 |
SET DEBUG_SYNC='lock_rec_restore_from_page_infimum_will_latch |
| 12 |
SIGNAL con1_will_latch |
| 13 |
WAIT_FOR con1_can_go'; |
| 14 |
UPDATE t1 SET val='aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'; |
| 15 |
SET DEBUG_SYNC='now WAIT_FOR con1_will_latch'; |
| 16 |
SET GLOBAL DEBUG='+d,syncpoint_after_lock_sys_resize_rec_hash'; |
| 17 |
SET GLOBAL innodb_buffer_pool_size= |
| 18 |
@@innodb_buffer_pool_size * 2 + @@innodb_buffer_pool_chunk_size; |
| 19 |
SET DEBUG_SYNC='now WAIT_FOR reached_after_lock_sys_resize_rec_hash'; |
| 20 |
SET DEBUG_SYNC='now SIGNAL con1_can_go'; |
| 21 |
SET GLOBAL DEBUG='-d,syncpoint_after_lock_sys_resize_rec_hash'; |
| 22 |
SET DEBUG_SYNC='now SIGNAL continue_after_lock_sys_resize_rec_hash'; |
| 23 |
DROP TABLE t1; |
| 24 |
SELECT @@innodb_buffer_pool_size; |
| 25 |
@@innodb_buffer_pool_size |
| 26 |
36700160 |
| 27 |
SET GLOBAL innodb_buffer_pool_size= |
| 28 |
(@@innodb_buffer_pool_size - @@innodb_buffer_pool_chunk_size) div 2; |
| 29 |
SELECT @@innodb_buffer_pool_size; |
| 30 |
@@innodb_buffer_pool_size |
| 31 |
17825792 |