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

Make RESET MASTER throw GTID-related warning if gtid_slave_pos is set

    XMLWordPrintable

    Details

      Description

      RESET MASTER resets gtid_binlog_pos, but not gtid_slave_pos. This means that gtid_current_pos can still contain GTIDs after RESET MASTER. This can result in some confusing behavior. See MDEV-17156 and MDEV-17853.

      To try to make this more clear, what if RESET MASTER threw a warning if gtid_slave_pos was set? Maybe something like:

      RESET MASTER successfully reset gtid_binlog_pos, but gtid_slave_pos is non-empty. If you want to reset system's GTID state, then you must also manually reset gtid_slave_pos with "SET GLOBAL gtid_slave_pos = ''"
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: