MySQL Bugs: #108465: [NOTE] InnoDB: Waiting for purge thread to be suspended

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:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.7.39	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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;
transaction-isolation=REPEATABLE-READ

close databases instance.

Suggested fix:
set global innodb_fast_shutdown=1;
close databases instance.

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

regards,
Umesh