Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.0
-
None
-
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` |