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

slave hung at shutdown

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.17, 10.4.18, 10.4.19, 10.4.20, 10.4.21, 10.4.22
    • 10.4(EOL)
    • Replication
    • Oracle Linux 8.4
      Mariadb binary distribution x86_64 for systemd

    Description

      Mariadb stuck(hang) at shutdown approximately 1/3 times with active slave connection, execuiting STOP ALL SLAVES before shutdown helps.

      Configuration and strace added to attachment.

      Shutdown from error_log (i eventually killed with -9, nothing else works, you can wait for hours)
      Nov 26 13:49:34 x1 systemd[1]: Stopping MariaDB 10.4.x database server...
      Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] /usr/local/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
      Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] Event Scheduler: Purging the queue. 0 events
      Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary index table `d_8nkc96648k3uln`.`jos_vm_product_param_xref`
      Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] InnoDB: FTS optimize thread exiting.
      Nov 26 13:54:34 x1 systemd[1]: mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.
      Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [ERROR] Master 'x5': Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
      Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [Note] Master 'x5': Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binary_log.010514' at position 97604371; GTID position '1-13-2385195623,2-14-212>
      Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [ERROR] Master 'x5': Slave I/O: error reconnecting to master 'replicator@10.1.1.25:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on>
      Nov 26 13:57:24 x1 systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
      Nov 26 13:57:24 x1 systemd[1]: mariadb.service: Failed with result 'timeout'.

      Attachments

        1. mariadb_broken_shutdown.log
          15 kB
          Jozef Kováč
        2. mariadb_shutdown_gdb.log
          75 kB
          Jozef Kováč
        3. my.cnf
          2 kB
          Jozef Kováč

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              lathander Jozef Kováč
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.