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

MariaDB fails to stop on OS shutdown

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.13
    • N/A
    • None
    • CentOS 7, kernel 3.10.0-1127.el7.x86_64, systemd-219-73.el7_8.6.x86_64

    Description

      When restarting or shutting down Centos 7, MariaDB fails to stop, and hangs the system for 15 minutes with a stop job.

      Here is the error log from maria:

      2020-06-03 18:00:04 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
      2020-06-03 18:00:04 0 [Note] Event Scheduler: Purging the queue. 0 events
      2020-06-03 18:00:04 0 [Note] InnoDB: FTS optimize thread exiting.
      2020-06-03 18:00:04 0 [Note] InnoDB: Starting shutdown...
      2020-06-03 18:00:04 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
      2020-06-03 18:00:04 0 [Note] InnoDB: Instance 0, restricted to 2003 pages due to innodb_buf_pool_dump_pct=25
      2020-06-03 18:00:04 0 [Note] InnoDB: Buffer pool(s) dump completed at 200603 18:00:04
      2020-06-03 18:01:05 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:02:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:03:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:04:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:05:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:06:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:07:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2020-06-03 18:08:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      ...

      Attachments

        Issue Links

          Activity

            shunkica Ivan Novak created issue -
            shunkica Ivan Novak made changes -
            Field Original Value New Value
            Description When restarting or shutting down Centos 7, MariaDB fails to stop, and hangs the system for 15 minutes with a stop job.

            Here is the error log from maria:

            ??
            2020-06-03 18:00:04 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
            2020-06-03 18:00:04 0 [Note] Event Scheduler: Purging the queue. 0 events
            2020-06-03 18:00:04 0 [Note] InnoDB: FTS optimize thread exiting.
            2020-06-03 18:00:04 0 [Note] InnoDB: Starting shutdown...
            2020-06-03 18:00:04 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
            2020-06-03 18:00:04 0 [Note] InnoDB: Instance 0, restricted to 2003 pages due to innodb_buf_pool_dump_pct=25
            2020-06-03 18:00:04 0 [Note] InnoDB: Buffer pool(s) dump completed at 200603 18:00:04
            2020-06-03 18:01:05 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:02:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:03:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:04:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:05:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:06:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:07:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:08:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            ...
            ??
            When restarting or shutting down Centos 7, MariaDB fails to stop, and hangs the system for 15 minutes with a stop job.

            Here is the error log from maria:

            {quote}
            2020-06-03 18:00:04 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
            2020-06-03 18:00:04 0 [Note] Event Scheduler: Purging the queue. 0 events
            2020-06-03 18:00:04 0 [Note] InnoDB: FTS optimize thread exiting.
            2020-06-03 18:00:04 0 [Note] InnoDB: Starting shutdown...
            2020-06-03 18:00:04 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
            2020-06-03 18:00:04 0 [Note] InnoDB: Instance 0, restricted to 2003 pages due to innodb_buf_pool_dump_pct=25
            2020-06-03 18:00:04 0 [Note] InnoDB: Buffer pool(s) dump completed at 200603 18:00:04
            2020-06-03 18:01:05 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:02:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:03:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:04:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:05:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:06:06 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:07:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            2020-06-03 18:08:07 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
            ...
            {quote}
            shunkica Ivan Novak made changes -
            Environment CentOS 7, kernel 3.10.0-1127.el7.x86_64 CentOS 7, kernel 3.10.0-1127.el7.x86_64, systemd-219-73.el7_8.6.x86_64
            shunkica Ivan Novak made changes -
            elenst Elena Stepanova made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 109460 ] MariaDB v4 [ 157903 ]

            People

              Unassigned Unassigned
              shunkica Ivan Novak
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.