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

After START SLAVE UNTIL master_gtid_pos = ... the IO thread also stops, needs to be documented

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.1, 10.0
    • Fix Version/s: N/A
    • Component/s: Documentation, Replication
    • Labels:
      None

      Description

      In the traditional START SLAVE UNTIL, after the desired position is reached, the SQL thread stops, but the IO thread does not. With START SLAVE UNTIL MASTER_GTID_POS = ... both threads stop. It's apparently expected, but it needs to be documented in the KB (https://mariadb.com/kb/en/mariadb/global-transaction-id/#start-slave-until-master_gtid_posxxx), I couldn't find it there.

      More generally, as I understand, this flavor of UNTIL actually applies to the IO thread, while the traditional one only affects the SQL thread. It reads between the lines in the abovementioned KB article, but it would be nice to emphasize it i it's true.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            knielsen Kristian Nielsen added a comment -

            I've updated the knowledge base page. START SLAVE UNTIL master_gtid_pos=xxx actually affects both the IO and the SQL thread, as well as the binlog dump thread on the master server.

            Show
            knielsen Kristian Nielsen added a comment - I've updated the knowledge base page. START SLAVE UNTIL master_gtid_pos=xxx actually affects both the IO and the SQL thread, as well as the binlog dump thread on the master server.

              People

              • Assignee:
                knielsen Kristian Nielsen
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: