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

'Stop slave' hangs on replication slave

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.10, 10.1.11, 10.1.13
    • 10.0.30, 10.1.22
    • Replication
    • CentOS release 6.7 (Final) x64 on Dell PowerEdge R510

    Description

      Since we switched from MariaDB 10.0.x to MariaDB 10.1 we are having trouble with the statement 'stop slave;' it just hangs and doesn't return even after hours. The 'show slave status\G' statement made with another connection is also blocking at this moment. It doesn't produce any output.
      This happens randomly, if there is low load on the server it is quite hard to reproduce the issue. Stopping and starting the slave in short intervals may succeed 30 times or more without problems.
      If the server is under heavy load it needs only very few tries to reproduce it. I can reproduce it very quickly when table checksums are created with pt-table-checksum.
      The only way to stop MariaDB when 'stop slave' is hanging is 'kill -9'.
      We are using parallel replication, as you can see in the my.cnf attached.
      Further there is a back trace attached, that has been created as described on mariadb.org. If necessary, I could repeat it with a DEBUG build.
      I also attached the running mysql processes in this moment.
      We never had this issue with MariaDB 10.0.x with the same configuration expect slave_run_triggers_for_rbr = 1 of course, since it is available in MariaDB 10.1 only.

      Please let me know, if I can provide any more details that might be helpful.

      Attachments

        1. my.cnf
          1.0 kB
          Markus Nägele
        2. myMaster.cnf
          0.8 kB
          Markus Nägele
        3. mysqld.log
          459 kB
          Markus Nägele
        4. mysqld-DEBUG.log
          343 kB
          Markus Nägele
        5. mysqlprocesslist.txt
          11 kB
          Markus Nägele
        6. processlistVerbose.txt
          96 kB
          Markus Nägele

        Issue Links

          Activity

            People

              monty Michael Widenius
              optonaegele Markus Nägele
              Votes:
              2 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.