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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.3.12
    • Fix Version/s: 10.2.4
    • Component/s: Replication
    • Labels:
      None
    • Environment:
      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. log.511405928
          2 kB
        2. master.err
          12 kB
        3. master.my.cnf
          0.9 kB
        4. master.tcpdump
          8 kB
        5. master.tcpdump
          8 kB
        6. mysql_bin_log.sql
          3 kB
        7. mysql-bin.000285
          0.3 kB
        8. only_one_master.err
          2 kB
        9. only_one_slave.err
          2 kB
        10. show_master_variables.txt
          18 kB
        11. show_slave_variables.txt
          18 kB
        12. slave.err
          9 kB
        13. slave.tcpdump
          7 kB
        14. slave.tcpdump
          7 kB

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration