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

[PATCH] mysqldump --dump-slave always starts stopped slave

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0, 5.5
        • Fix Version/s: 10.0, 5.5
        • Component/s: OTHER
        • Labels:

          Description

          When making a dump with --dump-slave option, upon completion mysqldump starts slave threads even if they were not stopped by mysqldump itself. This behavior breaks delayed/manually synchronized slaves which have not to be running all the time. Please consider implementing additional check(s) for that, like in the attached patch.

          P.S. The comment /* if SLAVE SQL is not running, we don't start it */ in do_start_slave_sql() is opposite and misleading.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #64390 - mysqldump should not restart slave automatically

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Max Samoilenko,

                  Thanks for the report and the patch.

                  Sergei Golubchik,

                  Technically it's an upstream bug, but it's been in 'verified' for 3 years with no progress, maybe it makes sense not to wait and just to apply the patch?

                  Show
                  elenst Elena Stepanova added a comment - Max Samoilenko , Thanks for the report and the patch. Sergei Golubchik , Technically it's an upstream bug, but it's been in 'verified' for 3 years with no progress, maybe it makes sense not to wait and just to apply the patch?

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      smax Max Samoilenko
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: