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

mysqlcheck: --auto-repair runs REPAIR TABLE instead of REPAIR VIEW on views

    Details

    • Sprint:
      5.5.44

      Description

      $ client/mysqlcheck  --protocol=tcp --port=3306 -uroot --process-views --check-upgrade --auto-repair views_mysql55
      views_mysql55.t1                                   OK
      views_mysql55.t2                                   OK
      views_mysql55.t3                                   OK
      views_mysql55.v1m
      error    : Upgrade required. Please do "REPAIR VIEW `v1m`" or dump/reload to fix it!
      views_mysql55.v1t
      error    : Upgrade required. Please do "REPAIR VIEW `v1t`" or dump/reload to fix it!
      views_mysql55.v1u
      error    : Upgrade required. Please do "REPAIR VIEW `v1u`" or dump/reload to fix it!
      views_mysql55.v2m
      error    : Upgrade required. Please do "REPAIR VIEW `v2m`" or dump/reload to fix it!
      views_mysql55.v2t
      error    : Upgrade required. Please do "REPAIR VIEW `v2t`" or dump/reload to fix it!
      views_mysql55.v2u
      error    : Upgrade required. Please do "REPAIR VIEW `v2u`" or dump/reload to fix it!
      views_mysql55.v3m
      error    : Upgrade required. Please do "REPAIR VIEW `v3m`" or dump/reload to fix it!
      views_mysql55.v3t
      error    : Upgrade required. Please do "REPAIR VIEW `v3t`" or dump/reload to fix it!
      views_mysql55.v3u
      error    : Upgrade required. Please do "REPAIR VIEW `v3u`" or dump/reload to fix it!
       
      Repairing tables
      views_mysql55.v1m
      Error    : 'views_mysql55.v1m' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v1t
      Error    : 'views_mysql55.v1t' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v1u
      Error    : 'views_mysql55.v1u' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v2m
      Error    : 'views_mysql55.v2m' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v2t
      Error    : 'views_mysql55.v2t' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v2u
      Error    : 'views_mysql55.v2u' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v3m
      Error    : 'views_mysql55.v3m' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v3t
      Error    : 'views_mysql55.v3t' is not BASE TABLE
      error    : Corrupt
      views_mysql55.v3u
      Error    : 'views_mysql55.v3u' is not BASE TABLE
      error    : Corrupt

      General log

                         8 Init DB   views_mysql55
                          8 Query     SHOW /*!50002 FULL*/ TABLES
                          8 Query     CHECK TABLE `t1`  FOR UPGRADE
                          8 Query     CHECK TABLE `t2`  FOR UPGRADE
                          8 Query     CHECK TABLE `t3`  FOR UPGRADE
                          8 Query     CHECK VIEW `v1m`  FOR UPGRADE
                          8 Query     CHECK VIEW `v1t`  FOR UPGRADE
                          8 Query     CHECK VIEW `v1u`  FOR UPGRADE
                          8 Query     CHECK VIEW `v2m`  FOR UPGRADE
                          8 Query     CHECK VIEW `v2t`  FOR UPGRADE
                          8 Query     CHECK VIEW `v2u`  FOR UPGRADE
                          8 Query     CHECK VIEW `v3m`  FOR UPGRADE
                          8 Query     CHECK VIEW `v3t`  FOR UPGRADE
                          8 Query     CHECK VIEW `v3u`  FOR UPGRADE
                          8 Query     REPAIR TABLE `v1m`
                          8 Query     REPAIR TABLE `v1t`
                          8 Query     REPAIR TABLE `v1u`
                          8 Query     REPAIR TABLE `v2m`
                          8 Query     REPAIR TABLE `v2t`
                          8 Query     REPAIR TABLE `v2u`
                          8 Query     REPAIR TABLE `v3m`
                          8 Query     REPAIR TABLE `v3t`
                          8 Query     REPAIR TABLE `v3u`

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: