[MDEV-20112] Test sys_vars.host_cache_size_auto fails Created: 2019-07-22  Updated: 2022-04-05

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.4.6
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Etienne Guesnet Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Linux Fedora 30 on PPC64
AIX 7.1 on PPC64



 Description   

Hi,
Test sys_vars.host_cache_size_auto fails on Linux and AIX with the following error:

 select @@global.host_cache_size;
 @@global.host_cache_size
-632
+653

Default cache size is defined in file mysqld.cc, line ~4271. Comments and code said cache size is 128 + min(connection, 500) + max(connection-500, 0)/20, capped at 2000. With 1000 connection (defined in mysql-test/suite/sys_vars/t/host_cache_size_auto-master.opt), we reach 653. We obtain the right value according to comment and code. Value wanted by the test is different.

Value wanted by the test was changed one year ago by a merge (https://github.com/MariaDB/server/blame/10.5/mysql-test/suite/sys_vars/r/host_cache_size_auto.result).

Can you confirm the old (653) value is the right one? Can you reproduce in a non-ppc architecture?

Thanks,
Étienne.



 Comments   
Comment by Etienne Guesnet [ 2019-07-22 ]

New information: test fails only on root. It works with a "mysql" (non root) user.
Reproduced on both Linux and AIX.
For your information, it is the same for the following tests :

sys_vars.table_open_cache_basic
csv.read_only
main.flush_logs_not_windows

Comment by Oleksandr Byelkin [ 2019-10-11 ]

test should be fixed (or removed) before testing it should be set to defeult, otherwise test depend on host settings

Comment by Etienne Guesnet [ 2019-10-30 ]

We can add "--source include/not_as_root.inc" in the beginning of the tests file. So, tests will be skipped if one tries to execute it as root.

Do you want I create an associated pull request?

Generated at Thu Feb 08 08:56:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.