Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6470

Restrict number of error messages about persistent statictic tables not found

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.12
    • 10.0.13
    • None

    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.

      Attachments

        Activity

          jplindst Jan Lindström (Inactive) created issue -
          jplindst Jan Lindström (Inactive) made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          Comment [ 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:

          {noformat}
          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.
          {noformat} ]
          jplindst Jan Lindström (Inactive) made changes -
          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:

          {noformat}
          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.
          {noformat}
          jplindst Jan Lindström (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 50602 ] MariaDB v3 [ 62240 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62240 ] MariaDB v4 [ 148052 ]

          People

            jplindst Jan Lindström (Inactive)
            jplindst Jan Lindström (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.