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

autocommit setting in .cnf file does not change global variable origin and path

    XMLWordPrintable

    Details

      Description

      I've added a custom config include file /etc/mysql/mariadb.conf.d/extra.cnf with contents

      [mysqld]
      autocommit=OFF
      bind_address=0.0.0.0
      

      Checking I_S.SYSTEM_VARIABLES for these two settings, I see that both values have been set as requested, but only for bind_address I see the correct origin and path information, while for autocommit it still claims to be using the complied-in default even though the current value is clearly different than the default:

      MariaDB [(none)]> select variable_name, default_value, global_value, global_value_origin, global_value_path from information_schema.system_variables where variable_name IN ('autocommit','bind_address')\G
      *************************** 1. row ***************************
            variable_name: BIND_ADDRESS
            default_value: 
             global_value: 0.0.0.0
      global_value_origin: CONFIG
        global_value_path: /etc/mysql/mariadb.conf.d/extra.cnf
      *************************** 2. row ***************************
            variable_name: AUTOCOMMIT
            default_value: ON
             global_value: OFF
      global_value_origin: COMPILE-TIME
        global_value_path: NULL
      

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration