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

Replication IO_Thread Connecting Primary server handshake call "SELECT GTID_BINLOG_POS" even when MASTER_USE_GITD=NO and GTID is disabled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Review (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.4, 10.5
    • Fix Version/s: 10.2, 10.3, 10.4, 10.5
    • Component/s: Replication
    • Labels:
      None

      Description

      Replication IO_Thread call SELECT GTID_BINLOG_POS even when MASTER_USE_GTID=NO and GTID is disabled.

      Id: 49525
      User: replica
      Host: XXXXX.XXXX.XXXX.XXXXX
      db: NULL
      Command: Query
      Time: 61
      State: executing
      Info: SELECT binlog_gtid_pos('mysql-binlog.XXXXX',XXXXXXXX)
      Progress: 0.000
      
      

      ..
      ...
      ......
      Using_Gtid: No
      Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
      Replicate_Ignore_Domain_Ids:
      Parallel_Mode: conservative
      SQL_Delay: 0
      SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
      
      

      This unnecessary query execution can hang IO thread for significant time, Causing slave lag (MDEV-25764)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration