[MDEV-20078] When setting back the system time while mysqld is running, shutdown will hang Created: 2019-07-16  Updated: 2020-08-25  Resolved: 2019-07-21

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.2, 10.2.25, 10.3.16, 10.4.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-17481 mariadb service won't shutdown when i... Closed

 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



 Comments   
Comment by Elena Stepanova [ 2019-07-21 ]

It appears to be a duplicate of MDEV-17481.
hholzgra, is it okay with you to continue tracking it in MDEV-17481, or do you want to keep this one open?

Comment by Hartmut Holzgraefe [ 2019-07-21 ]

Ok to close as duplicate, I already updated the support issue information accordingly

Generated at Thu Feb 08 08:56:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.