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

service stop with parallel replication failing

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.1.12
    • 10.1.13
    • Platform RedHat, Replication
    • None
    • CentOS 7
      MariaDB 10.1.12
      Parallel Replication with 16 threads

    Description

      I'm using a MariaDB with replication parallel.
      Whenever I need to stop the MySQL service, it does not stop effectively.
      It seems that a zombie is still up process, but I can not aCesar MySQL.
      But if I stop replication before stopping the MySQL service, the MySQL service is stoped successfully.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          danblack Daniel Black added a comment -

          How are you stopping the service?

          Can you use gdb to grab a backtrace while it is in its zombie status?

          gdb --batch --eval-command="thread apply all bt" program $(pgrep -xn mysqld)

          What also are the last messages written to the error log?

          If you do a STOP SLAVE SQL_THREAD; does this complete ok?

          What are your replication settings? What version is the master? Are you replicating in gtid mode? Are you using any aggressive mode replication?

          danblack Daniel Black added a comment - How are you stopping the service? Can you use gdb to grab a backtrace while it is in its zombie status? gdb --batch --eval-command="thread apply all bt" program $(pgrep -xn mysqld) What also are the last messages written to the error log? If you do a STOP SLAVE SQL_THREAD; does this complete ok? What are your replication settings? What version is the master? Are you replicating in gtid mode? Are you using any aggressive mode replication?
          knielsen Kristian Nielsen added a comment -

          It sounds like it could be the same problem as MDEV-9595, which should be fixed in 10.1.13.

          Maybe you can test if the patch for MDEV-9595 also fixes your issue? Either by installing 10.1.13, or by applying the patch from here:

          http://lists.askmonty.org/pipermail/commits/2016-March/009069.html

          knielsen Kristian Nielsen added a comment - It sounds like it could be the same problem as MDEV-9595 , which should be fixed in 10.1.13. Maybe you can test if the patch for MDEV-9595 also fixes your issue? Either by installing 10.1.13, or by applying the patch from here: http://lists.askmonty.org/pipermail/commits/2016-March/009069.html
          diegohellas Diego Hellas added a comment -

          @Daniel, look the attachment.

          diegohellas Diego Hellas added a comment - @Daniel, look the attachment.
          elenst Elena Stepanova added a comment -

          diegohellas, have you had a chance to upgrade to 10.1.13 as Kristian suggested above? If you had, have you experienced the problem since then?

          elenst Elena Stepanova added a comment - diegohellas , have you had a chance to upgrade to 10.1.13 as Kristian suggested above? If you had, have you experienced the problem since then?
          diegohellas Diego Hellas added a comment -

          @Elena, in MariaDB 10.1.13 works.
          I'll upgrade.
          Thanks!

          diegohellas Diego Hellas added a comment - @Elena, in MariaDB 10.1.13 works. I'll upgrade. Thanks!
          knielsen Kristian Nielsen added a comment -

          Ok, closing then as duplicate of MDEV-9595, thanks for your time looking into this!

          • Kristian.
          knielsen Kristian Nielsen added a comment - Ok, closing then as duplicate of MDEV-9595 , thanks for your time looking into this! Kristian.

          People

            Unassigned Unassigned
            diegohellas Diego Hellas
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.