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

SlaveStatus Master_Server_Id does not reset with CHANGE MASTER

    XMLWordPrintable

Details

    Description

      The Master_Server_Id show by SHOW ALL SLAVES STATUS keeps its old value after a CHANGE MASTER TO-command. It seems the value is only updated once the slave connects to the new master. This can be confusing if the history of the slave is not known and the IO Thread is "Connecting". In that case it's not immediately obvious if the Master_Server_Id shown is the ID of the current master server (temporarily disconnected) or of a previous master. It would be clearer if a CHANGE MASTER automatically assigned -1 or 0 to Master_Server_Id.

      Attachments

        Activity

          People

            Unassigned Unassigned
            esa.korhonen Esa Korhonen
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: