【 TiDB 使用环境】测试
【 TiDB 版本】 v8.1.0
从mysql.tidb_mdl_view表查询的时候报错
root@192.168.3.114:4000 17:14: [mysql] >select * from tidb_mdl_view ;
ERROR 1356 (HY000): View 'mysql.tidb_mdl_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
使用的账号是root账号，具有所有权
root@192.168.3.114:4000 17:14: [mysql] >select user,host from mysql.user where user='root';
+------+------+
| user | host |
+------+------+
| root | % |
+------+------+
1 row in set (0.01 sec)
root@192.168.3.114:4000 17:16: [mysql] >show grants for root@'%';
+-------------------------------------------------------------+
| Grants for root@% |
+-------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION |
+-------------------------------------------------------------+
1 row in set (0.00 sec)
使用的TIDB版本信息及 tidb_mdl_view 结构如下
root@192.168.3.114:4000 17:13: [mysql] >select tidb_version();
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v8.1.0
Edition: Community
Git Commit Hash: 945d07c5d5c7a1ae212f6013adfb187f2de24b23
Git Branch: HEAD
UTC Build Time: 2024-05-21 03:51:57
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: tikv |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
root@192.168.3.114:4000 17:14: [mysql] >show create table tidb_mdl_view ;
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View | Create View | character_set_client | collation_connection |
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| tidb_mdl_view | CREATE ALGORITHM=UNDEFINED DEFINER=``@`` SQL SECURITY DEFINER VIEW `tidb_mdl_view` (`job_id`, `db_name`, `table_name`, `query`, `session_id`, `start_time`, `SQL_DIGESTS`) AS (SELECT `tidb_mdl_info`.`job_id` AS `job_id`,JSON_UNQUOTE(JSON_EXTRACT(CAST(CAST(`job_meta` AS CHAR) AS JSON), _UTF8MB4'$.schema_name')) AS `db_name`,JSON_UNQUOTE(JSON_EXTRACT(CAST(CAST(`job_meta` AS CHAR) AS JSON), _UTF8MB4'$.table_name')) AS `table_name`,JSON_UNQUOTE(JSON_EXTRACT(CAST(CAST(`job_meta` AS CHAR) AS JSON), _UTF8MB4'$.query')) AS `query`,`session_id` AS `session_id`,`cluster_tidb_trx`.`start_time` AS `start_time`,TIDB_DECODE_SQL_DIGESTS(`all_sql_digests`, 4096) AS `SQL_DIGESTS` FROM ((`mysql`.`tidb_ddl_job`) JOIN `mysql`.`tidb_mdl_info`) JOIN `information_schema`.`cluster_tidb_trx` WHERE `tidb_ddl_job`.`job_id`=`tidb_mdl_info`.`job_id` AND CONCAT(_UTF8MB4',', `tidb_mdl_info`.`table_ids`, _UTF8MB4',') REGEXP CONCAT(_UTF8MB4',(', REPLACE(`cluster_tidb_trx`.`related_table_ids`, _UTF8MB4',', _UTF8MB4'|'), _UTF8MB4'),')!=0) | utf8mb4 | utf8mb4_bin |
+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set (0.01 sec)
创建view的语句中看到 DEFINER=``@`` ，
这是系统问题了吗？ 如何确认当前之前的ddl操作是否被锁，有没有其他办法？
