Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20112

Test sys_vars.host_cache_size_auto fails

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4.6
    • 10.4(EOL)
    • Tests, MTR
    • None
    • 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.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            EGuesnet Etienne Guesnet
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.