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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.2.2, 10.2.25, 10.3.16, 10.4.6
    • Fix Version/s: N/A
    • Labels:
      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

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration