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

When setting back the system time while mysqld is running, shutdown will hang

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.2.2, 10.2.25, 10.3.16, 10.4.6
    • N/A
    • Storage Engine - InnoDB
    • None

    Description

      Since MariaDB 10.2.2, when setting the system clock back in time (I tested by setting it back by 24h+), mysqld shutdown does not complete quickly anymore, but hangs and repeatedly prints

      [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

      Jul 16 17:47:42 vagrant-ubuntu-trusty-64 mysqld: 2019-07-16 17:47:42 139866331920320 [Note] /usr/sbin/mysqld: ready for connections.
      		 
      [... setting back system time, then shutting down mariadb service ...]
      		 
      Jul 14 15:33:19 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:33:19 139866330493696 [Note] InnoDB: Starting shutdown...
      		 
      Jul 14 15:33:20 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:33:20 139865026950912 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
      		 
      Jul 14 15:33:20 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:33:20 139865026950912 [Note] InnoDB: Buffer pool(s) dump completed at 190714 15:33:20
      		 
      Jul 14 15:34:21 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:34:21 139866330493696 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      		 
      Jul 14 15:35:21 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:35:21 139866330493696 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      		 
      Jul 14 15:36:21 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:36:21 139866330493696 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      		 
      Jul 14 15:37:22 vagrant-ubuntu-trusty-64 mysqld: 2019-07-14 15:37:22 139866330493696 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

      Attachments

        Issue Links

          is duplicated by

          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

            People

              Unassigned Unassigned
              hholzgra Hartmut Holzgraefe
              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.