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

Global variables should only contain configuration settings not state (gtid_current_pos / gtid_slave_pos)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.14
    • N/A
    • OTHER

    Description

      On a server I notice:

      root@myserver [(none)]> show global variables like 'gtid%';
      +------------------------+----------------------+
      | Variable_name          | Value                |
      +------------------------+----------------------+
      | gtid_binlog_pos        |                      |
      | gtid_binlog_state      |                      |
      | gtid_current_pos       | 0-187204017-44995072 |
      | gtid_domain_id         | 0                    |
      | gtid_ignore_duplicates | OFF                  |
      | gtid_slave_pos         | 0-187204017-44995072 |
      | gtid_strict_mode       | OFF                  |
      +------------------------+----------------------+
      7 rows in set (0.00 sec)

      The 2 "variables" gtid_current_pos and gtid_slave_pos do not have configuration settings but state. Configuration state should be stored somewhere else. SHOW GLOBAL STATUS has traditionally been used for this.

      See an upstream equivalent ticket I wrote some time ago (not resolved either).

      As stated in the original ticket I care because I collect this configuration information and have to explicitly filter out settings like this which change continually to be able to compare settings from one server to another or one moment in time to another.

      So please remove these variables from global_variables and put the information somewhere else.

      Attachments

        Activity

          People

            Unassigned Unassigned
            simon.mudd Simon J Mudd
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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