[MDEV-25895] innodb.innodb_buffer_pool_resize tests fail on ARM Created: 2021-06-11  Updated: 2023-05-16  Resolved: 2021-06-11

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2, 10.3
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Relates

 Description   

10.2 152c83d49ca

innodb.innodb_buffer_pool_resize 'innodb' [ fail ]
        Test ended at 2021-06-11 08:17:56
 
CURRENT_TEST: innodb.innodb_buffer_pool_resize
--- /10.2/mysql-test/suite/innodb/r/innodb_buffer_pool_resize.result	2021-06-10 14:21:07.305545858 +0000
+++ /10.2/mysql-test/suite/innodb/r/innodb_buffer_pool_resize.reject	2021-06-11 08:17:56.114164033 +0000
@@ -7,7 +7,7 @@
 Warning	1292	Truncated incorrect innodb_buffer_pool_size value: '10485760'
 select @@innodb_buffer_pool_size;
 @@innodb_buffer_pool_size
-16777216
+25165824
 create table t1 (id int not null, val int not null default '0', primary key (id)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
 create or replace view view0 as select 1 union all select 1;
 set @`v_id` := 0;
@@ -18,7 +18,7 @@
 Warning	1292	Truncated incorrect innodb_buffer_pool_size value: '7340032'
 select @@innodb_buffer_pool_size;
 @@innodb_buffer_pool_size
-8388608
+16777216
 select count(val) from t1;
 count(val)
 262144
@@ -26,7 +26,7 @@
 set global innodb_buffer_pool_size = 25165824;
 select @@innodb_buffer_pool_size;
 @@innodb_buffer_pool_size
-25165824
+33554432
 select count(val) from t1;
 count(val)
 262144
 
mysqltest: Result length mismatch

innodb.innodb_buffer_pool_resize_with_chunks also fails.

It happens on some ARMs, not on all, apparently those with large pages, e.g.

Tc_log_page_size	65536

(to my understanding it is initialized from getpagesize()).



 Comments   
Comment by Elena Stepanova [ 2021-06-11 ]

The community server doesn't run big tests on ARM, and otherwise it is deemed unimportant for 10.2/10.3, and was fixed in 10.4+ apparently by this patch

commit de51acd03730311505677eb7212756e7126183b3
Author: Daniel Black <daniel@linux.ibm.com>
Date:   Wed Feb 27 13:52:37 2019 +1100
    MDEV-18726: innodb buffer pool size not consistent with large pages

Generated at Thu Feb 08 09:41:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.