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
    • Storage Engine - InnoDB
    • 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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17481 mariadb service won't shutdown when it's running and the OS datetime updated backwards

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            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 -
            shunkica Ivan Novak added a comment - - edited

            I see now that this is actually a duplicate of MDEV-17481.
            When my VPS starts it is always 2 hours ahead of actual time (I have talked to my provider multiple times about this but it seems they don't know how to fix it), and then NTP client kicks in and sets the actual time.

            shunkica Ivan Novak added a comment - - edited I see now that this is actually a duplicate of MDEV-17481 . When my VPS starts it is always 2 hours ahead of actual time (I have talked to my provider multiple times about this but it seems they don't know how to fix it), and then NTP client kicks in and sets the actual time.
            elenst Elena Stepanova added a comment -

            In this case, let's keep tracking it under MDEV-17481.

            elenst Elena Stepanova added a comment - In this case, let's keep tracking it under MDEV-17481 .
            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.