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

replication issue, disconnection every minute with error : "A slave with the same server_uuid/server_id as this slave has co', with different server-id.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.12
    • 10.2.4
    • Replication
    • None
    • debian stretch

    Description

      After upgrading mariadb master/slave cluster from 10.0.33 to 10.3.12, I have a replication issue. on each cluster that I have upgraded, every minute, all slaves connections are closed with the message :
      2019-02-12 19:41:20 77017 [Warning] Aborted connection 77017 to db: 'unconnected' user: 'sa' host: 'logarchiverpl2.artprice.bil' (A slave with the same server_uuid/server_id as this slave has co)

      I have checked the server-id of all the stack, non are the same.
      show slave hosts;
      Server_id Host Port Master_id
      29 3306 31
      30 3306 31
      27 3306 31
      22 3311 31
      25 3311 31

      The replication was working fine with 10.0.33. All the slaves have been created via cloning the full data set via rsync, and then restarting changing the server-id.
      For the upgrade process, I have started and run myql_upgrade, in 10.1,10.2,10.3 with the last current stable. No upgrade errors.

      I have read MDEV-15660, mentioning the same error message, and trying to raise table_open_cache, but it doesn't help.

      Attachments

        1. master.err
          12 kB
        2. show_master_variables.txt
          18 kB
        3. show_slave_variables.txt
          18 kB
        4. slave.err
          9 kB
        5. master.my.cnf
          0.9 kB
        6. mysql_bin_log.sql
          3 kB
        7. log.511405928
          2 kB
        8. only_one_master.err
          2 kB
        9. only_one_slave.err
          2 kB
        10. mysql-bin.000285
          0.3 kB
        11. master.tcpdump
          8 kB
        12. slave.tcpdump
          7 kB
        13. master.tcpdump
          8 kB
        14. slave.tcpdump
          7 kB

        Activity

          People

            Elkin Andrei Elkin
            tophe Christophe Vigny
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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