[MDEV-22789] MariaDB fails to stop on OS shutdown Created: 2020-06-03  Updated: 2020-07-08  Resolved: 2020-07-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ivan Novak Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS 7, kernel 3.10.0-1127.el7.x86_64, systemd-219-73.el7_8.6.x86_64


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

 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
...



 Comments   
Comment by Ivan Novak [ 2020-06-03 ]

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.

Comment by Elena Stepanova [ 2020-07-08 ]

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

Generated at Thu Feb 08 09:17:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.