Bug #119922 Contribution: Fix excessive generation of histogram background update erro ...
Submitted: 18 Feb 16:34 Modified: 22 Apr 21:21
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[18 Feb 16:34] OCA Admin 
Description:
This bug tracks a contribution by Tony Chen (Github user: tonychen2001), as described in http://github.com/mysql/mysql-server/pull/646

How to repeat:
See description

Suggested fix:
See contribution code attached
[18 Feb 16:34] OCA Admin 
Contribution submitted via Github -  Fix excessive generation of histogram background update errors  
(*) Contribution by Tony Chen (Github tonychen2001, mysql-server/pull/646#issuecomment-3917503337): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_3295593458.txt (text/plain), 8.19 KiB.
[19 Feb 4:45] Chaithra Marsur Gopala Reddy 
Hi,

Thank you for the report and contribution.
[22 Apr 21:21] Edward Gilmore 
Posted by developer:
 
Added the following note to the MySQL Server 8.4.9 and 9.7.0 release notes:
		

When errors and warnings occured during background histogram updates, the
conditions in the diagnostic area were not cleared, leading to future
background histogram updates emitted the same stale conditions to the
error log.

Our thanks to Tony Chen and the team at Amazon for the contribution.