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

mysql.proc -> "The table is probably corrupted" is an excessive error

    XMLWordPrintable

Details

    Description

      The likehood of mysql.proc being corrupted because of the errors it gets are unlikely. Its usually got a fixable structure with mariadb-upgrade.

      mysq.proc in overriding the function "Table_check_intact_log_error::report_error" creates the excessive potential corruption warnings.

      The calls to report_error in sql/table.cc, verifing the system table structures, call report error with

      • ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE
      • ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2 (when the versions of table and server are the same)
      • 0 - for when datatypes in table don't match
      • 0 - for missing /incorrect primary or secondary keys

      For the mysql.proc table everything non-0 is mapped to ER_CANNOT_LOAD_FROM_TABLE_V2

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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