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

mariadb parallel slave server shutdown hang - v10.4.8

    XMLWordPrintable

Details

    Description

      During on-site engagement, I installed master-slave configuration with MaxScale v2.3 on top of master node.

      OS: CentOS 7.4.1708
      MariaDB: v10.4.8
      MaxScale: v2.3.11

      Customer is using GTID to utilize auto failover of MaxScale and HA test has been done successfully.

      But when I tried to shutdown mariadb server it failed with timeout.
      I tried
      $ systemctl stop mysql
      and
      $ mysqladmin shutdown and the result is the same.

      The last error log is follows..
      ...
      [Note] Slave I/O thread: connected to master 'xxx@xxxx:3306', replication starts at GTID position '0-1000-382'
      ----------------------------------------------

      So If I stop the slave with "mysql> stop slave;" and then tried to stop the mariadb server, it stops immediately.
      It looks like shutdown never stops "Slave I/O thread"... and got timeout.

      Is it a known issue of v10.4.8 or any OS setting dependancies ?

      FYI. innodb-thread-concurrency is set to 0.

      Thanks

      Attachments

        1. mariadb.service.log
          35 kB
          Devin Henderson
        2. mariadb.STATUS.log
          62 kB
          Devin Henderson
        3. mariadb.VARIABLES.log
          525 kB
          Devin Henderson
        4. show global variables and status.txt
          592 kB
          Volker Klasen

        Activity

          People

            Elkin Andrei Elkin
            kb Kwangbock Lee
            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.