Bug #108465 [NOTE] InnoDB: Waiting for purge thread to be suspended
Submitted: 13 Sep 2022 1:33 Modified: 14 Sep 2022 13:06
Reporter: liu chuming Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7.39 OS:Any
Assigned to: CPU Architecture:Any

[13 Sep 2022 1:33] liu chuming
InnoDB: Server shutdown would result in a hang with the following message written to the error log: “[NOTE] InnoDB: Waiting for purge thread to be suspended.” (Bug #16495065)

How to repeat:
set global innodb_fast_shutdown=0;

close databases instance.

Suggested fix:
set global innodb_fast_shutdown=1;
close databases instance.
[14 Sep 2022 13:06] MySQL Verification Team
Hello liu chuming,

Thank you for the report and feedback.
Imho better to mark this as a duplicate of Shane's FR Bug#76871, where feature is requested to print any useful information that can show what is being done that delays the shutdown.

Related - Bug #58868, Bug #60939