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

Replication filters configured in my.cnf are ignored if slave reset and reconfigured

Details

    • 10.1.22

    Description

      This MariaDB instance is using multi source replication and has 4 masters.
      We have separate replication filters on each of the master connections, configured in my.cnf.
      When we issue a RESET SLAVE ALL for one of the connections, where replication filters are in effect, and then we create the connection again with CHANGE MASTER 'connection name' TO.... , the replication filters are now ignored and we need to restart the server to bring them back in effect.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          leopardus2 Rick Pizzi created issue -
          leopardus2 Rick Pizzi made changes -
          Field Original Value New Value
          Description This MariaDB instance is using multi source replication and has 4 masters.
          We have separate replication filters on each of the master connections, configured in my.cnf.
          When we issue a RESET SLAVE ALL for one of the connections, where replication filters are in effect, and then we create the connection again with CHANGE MASTER 'connection name' TO.... , the replication filters are now ignored and we need to restart the server to bring them back in effect.
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          elenst Elena Stepanova added a comment - - edited

          Thanks for the report.

          Only affects named slaves.

          elenst Elena Stepanova added a comment - - edited Thanks for the report. Only affects named slaves.
          elenst Elena Stepanova made changes -
          Labels multisource
          elenst Elena Stepanova made changes -
          Affects Version/s 10.1 [ 16100 ]
          Affects Version/s 10.0 [ 16000 ]
          Affects Version/s 10.0.20 [ 19201 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.1 [ 16100 ]
          Fix Version/s 10.0 [ 16000 ]
          elenst Elena Stepanova made changes -
          Assignee Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Assignee Michael Widenius [ monty ] Sachin Setiya [ sachin.setiya.007 ]
          serg Sergei Golubchik made changes -
          Sprint 10.0.30 [ 140 ]
          sachin.setiya.007 Sachin Setiya (Inactive) made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          sachin.setiya.007 Sachin Setiya (Inactive) made changes -
          Assignee Sachin Setiya [ sachin.setiya.007 ] Lixun Peng [ plinux ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.0.30 [ 140 ] 10.1.22 [ 143 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked lower
          plinux Lixun Peng added a comment -

          leopardus2
          If we save the filter options, and you create a new connection but the host/port is different, do you consider that we should still keep the fitler options?

          plinux Lixun Peng added a comment - leopardus2 If we save the filter options, and you create a new connection but the host/port is different, do you consider that we should still keep the fitler options?
          Elkin Andrei Elkin added a comment -

          ralf.gebhardt@mariadb.com, hallo! Sure I can substitute plinux to finish off reviewing. Let's first to hear his OK to that.

          Cheers, Andrei.

          Elkin Andrei Elkin added a comment - ralf.gebhardt@mariadb.com , hallo! Sure I can substitute plinux to finish off reviewing. Let's first to hear his OK to that. Cheers, Andrei.
          Elkin Andrei Elkin made changes -
          Assignee Lixun Peng [ plinux ] Sachin Setiya [ sachin.setiya.007 ]
          sachin.setiya.007 Sachin Setiya (Inactive) made changes -
          Assignee Sachin Setiya [ sachin.setiya.007 ] Andrei Elkin [ elkin ]
          sachin.setiya.007 Sachin Setiya (Inactive) added a comment - - edited

          Hi Elkin, Patch is in commit list.

          sachin.setiya.007 Sachin Setiya (Inactive) added a comment - - edited Hi Elkin , Patch is in commit list.
          Elkin Andrei Elkin added a comment -

          Review notes are sent out.

          Elkin Andrei Elkin added a comment - Review notes are sent out.
          Elkin Andrei Elkin made changes -
          Assignee Andrei Elkin [ elkin ] Sachin Setiya [ sachin.setiya.007 ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          sachin.setiya.007 Sachin Setiya (Inactive) made changes -
          Fix Version/s 10.1.41 [ 23406 ]
          Fix Version/s 10.2.26 [ 23409 ]
          Fix Version/s 10.3.17 [ 23411 ]
          Fix Version/s 10.4.7 [ 23720 ]
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 71844 ] MariaDB v4 [ 149669 ]

          People

            sachin.setiya.007 Sachin Setiya (Inactive)
            leopardus2 Rick Pizzi
            Votes:
            1 Vote for this issue
            Watchers:
            8 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.