Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4.13
-
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
-
MDEV-17481 mariadb service won't shutdown when it's running and the OS datetime updated backwards
-
- Closed
-
Activity
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} |
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 |
Link |
This issue duplicates |
Fix Version/s | N/A [ 14700 ] | |
Resolution | Duplicate [ 3 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 109460 ] | MariaDB v4 [ 157903 ] |