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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0, 5.5
    • Fix Version/s: 10.0.20, 5.5.44
    • Component/s: Admin statements
    • Labels:
      None
    • 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`
      

        Gliffy Diagrams

          Attachments

            Activity

            There are no comments yet on this issue.

              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:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h

                    Agile