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

master binlog read slow causes slave connect fail.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3.11
    • 10.4
    • Replication
    • None
    • CentOS 7 as ESXi guest

    Description

      When slave connect to master, it send command to master query gtid for current binlog position (at lease when gtid replication is disabled).
      Master then scans binlog for result.
      When binlog is large, scan may take a long time.
      During scanning, the slave report "Slave_IO_State: checking master version" which will confuse user.
      The problem is: the slave (maybe) threat this long scanning time as network connect time, the default "slave-network-timeout" is insufficient for a large binlog scan. So the slave will timeout and try to reconnect. This will cause an event worse situation for master:new scanning will start while old scanning is on the way.

      Then the slave will infinitely connect to master without success and the master will stressed by scanning binlog repeatly.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            lvyou LvYou
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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