'DB' is not a valid floating point value

[xieyuhua]

Navicat链接报错，什么情况呀

[xiyangxixian]

可以看一下日志信息吗，在 log 目录下面

[xieyuhua]

[2021-11-22 17:16:47] [gaea_proxy] [iZ2vc4fcja0fjd7ljf2a9cZ] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Manager).RecordSessionSQLMetrics:manager.go:324] session slow SQL, namespace: test_namespace_1, sql: SHOW VARIABLES LIKE 'lower_case_%', cost: 4 ms [2021-11-22 17:16:47] [gaea_proxy] [iZ2vc4fcja0fjd7ljf2a9cZ] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Manager).RecordSessionSQLMetrics:manager.go:324] session slow SQL, namespace: test_namespace_1, sql: SHOW VARIABLES LIKE 'profiling', cost: 3 ms [2021-11-22 17:16:54] [gaea_proxy] [iZ2vc4fcja0fjd7ljf2a9cZ] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Manager).RecordSessionSQLMetrics:manager.go:324] session slow SQL, namespace: test_namespace_1, sql: SHOW VARIABLES LIKE 'lower_case_%', cost: 3 ms [2021-11-22 17:16:54] [gaea_proxy] [iZ2vc4fcja0fjd7ljf2a9cZ] [WARN] [900000001] [github.com/XiaoMi/Gaea/proxy/server.(*Manager).RecordSessionSQLMetrics:manager.go:324] session slow SQL, namespace: test_namespace_1, sql: SHOW VARIABLES LIKE 'profiling', cost: 2 ms

[xieyuhua]

{ "name": "test_namespace_1", "online": true, "read_only": false, "allowed_dbs": { "DB": true }, "slow_sql_time": "1", "black_sql": [ "" ], "allowed_ip": null, "slices": [ { "name": "slice-0", "user_name": "root", "password": "ef08ef776c21a44", "master": "127.0.0.1:3306", "slaves": null, "statistic_slaves": null, "capacity": 12, "max_capacity": 24, "idle_timeout": 60 } ], "shard_rules": null, "users": [ { "user_name": "root", "password": "root", "namespace": "test_namespace_1", "rw_flag": 2, "rw_split": 0, "other_property": 0 } ], "default_slice": "slice-0", "open_general_log": true, "global_sequences": null, "max_sql_execute_time": 0 }

[xiyangxixian]

gaea 缺少 infomation_schema 库，图形化工具连使用的话，都会有点问题，命令行客户端是可以正常使用的

[xieyuhua]

配置修改重启之后， 还是这个错误

[xieyuhua]

HeidiSQL 我换成这个工具是可以的

[xiyangxixian]

嗯嗯，我的意思是，直连 MySQL 的时候，都会有一个默认的 infomation_schema 库，里面可以查到库表信息，navicat 在展示库表的时候会依赖这个库。之前用 navicat 试了一下连接 gaea，可以登录成功，但是无法获取数据库列表。