创建数据源报错，Error 1682: Native table 'performance_schema'.'global_variables' has the wrong structure

[Hacker_ucTLLuZl]

./tiup dmctl --master-addr 10.3.19.6:8261 operate-source create /root/.tiup/bin/source.yaml

Starting component dmctl: /root/.tiup/components/dmctl/v2.0.5/dmctl/dmctl --master-addr 10.3.19.6:8261 operate-source create /root/.tiup/bin/source.yaml
{
“result”: false,
“msg”: “[code=10001:class=database:scope=upstream:level=high], Message: database driver error, RawCause: Error 1682: Native table ‘performance_schema’.‘global_variables’ has the wrong structure, Workaround: Please check the database connection and the database config in configuration file.”,
“sources”: [
]
}

source.yaml文件内容：

MySQL1 Configuration.

source-id: “traffic”

DM-worker 是否使用全局事务标识符 (GTID) 拉取 binlog。使用前提是在上游 MySQL 已开启 GTID 模式。

enable-gtid: false

from:
host: “10.3.19.5”
user: “test”
password: “xxxxxxx”
port: 3306

[hey-hoho]

麻烦打印上游mysql的版本信息，然后desc看一下performance_schema.global_variables

[Hacker_ucTLLuZl]

Server version: 5.7.25-TiDB-v5.1.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

没有这张表performance_schema.global_variables，
show tables;
±------------------------------------+
| Tables_in_performance_schema |
±------------------------------------+
| events_stages_current |
| events_stages_history |
| events_stages_history_long |
| events_statements_current |
| events_statements_history |
| events_statements_history_long |
| events_statements_summary_by_digest |
| events_transactions_current |
| events_transactions_history |
| events_transactions_history_long |
| global_status |
| pd_profile_allocs |
| pd_profile_block |
| pd_profile_cpu |
| pd_profile_goroutines |
| pd_profile_memory |
| pd_profile_mutex |
| prepared_statements_instances |
| session_status |
| setup_actors |
| setup_consumers |
| setup_instruments |
| setup_objects |
| tidb_profile_allocs |
| tidb_profile_block |
| tidb_profile_cpu |
| tidb_profile_goroutines |
| tidb_profile_memory |
| tidb_profile_mutex |
| tikv_profile_cpu

[hey-hoho]

是看上游MySQL的信息，不是TiDB

[Hacker_ucTLLuZl]

上游数据源里面的那个mysql信息：
version 5.7.32，

show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |

没有performance_schema这个库

[hey-hoho]

是用的开源的标准MySQL吗，怎么会没有performance_schema呢，手动删除了还是别的原因？

[Hacker_ucTLLuZl]

应该是被删除了，是不是把库和表重建好就可以了

[hey-hoho]

是的，系统库不要随便删除。

[Hacker_ucTLLuZl]

好的，感谢！

[hey-hoho]

有结果了麻烦继续在这里反馈一下。

[Hacker_ucTLLuZl]

好的