[MDEV-8124] mysqlcheck: --auto-repair runs REPAIR TABLE instead of REPAIR VIEW on views Created: 2015-05-08  Updated: 2015-06-03  Resolved: 2015-06-03

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 5.5, 10.0
Fix Version/s: 5.5.44, 10.0.20

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
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`


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