[MDEV-6470] Restrict number of error messages about persistent statictic tables not found Created: 2014-07-22  Updated: 2014-07-22  Resolved: 2014-07-22

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12
Fix Version/s: 10.0.13

Type: Bug Priority: Minor
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: innodb, xtradb


 Description   

We should output the information that mysql.innodb_table_stats or mysql.innodb_index_stats not found only once and similarly only once the fact that persistent statictics can-t be fetched or recalculated. E.g:

2014-07-22 17:20:53 7f5ee72c1700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
 
2014-07-22 17:20:53 7f5ee72c1700 InnoDB: Error: Fetch of persistent statistics requested for table "new_db"."files_text" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
 
2014-07-22 17:21:03 7f5ebeffd700 InnoDB: Recalculation of persistent statistics requested for table "new_db"."files_text" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
 
2014-07-22 18:12:05 7f31be749700 InnoDB: Error: Table "mysql"."innodb_index_stats" not found.



 Comments   
Comment by Jan Lindström (Inactive) [ 2014-07-22 ]

revno: 4302
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.0-innodb
timestamp: Tue 2014-07-22 19:31:45 +0300
message:
MDEV-6470: Restrict number of error messages about persistent statictic tables not found

If mysql.innodb_table_stats or mysql.innodb_index_stats is not found or has
unexpected structure output that error only once and no other error for
every table trying to use them. If they do exists, then print fetch or
recalculation errors only once / table or index.

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