【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
drainer启动失败,看日志是TSO慢,但看了监控面板,没发现什么问题。日志:
[2023/09/18 13:44:23.097 +08:00] [INFO] [version.go:50] [“Welcome to Drainer”] [“Release Version”=v5.0.0] [“Git Commit Hash”=d2dfe95e502ea2bb83d0ff6be3f2059bd2c43dce] [“Build TS”=“2021-04-06 04:38:50”] [“Go Version”=go1.13] [“Go OS/Arch”=linux/amd64]
[2023/09/18 13:44:23.097 +08:00] [INFO] [main.go:46] [“start drainer…”] [config=“{"log-level":"info","node-id":"192.168.1.6:8249","addr":"http://192.168.1.6:8249","advertise-addr":"http://192.168.1.6:8249","data-dir":"/data_back/drainer_data-8249","detect-interval":5,"pd-urls":"http://192.168.1.1:2379,http://192.168.1.4:2379,http://192.168.1.5:2379","log-file":"/data_back/drainer_deploy-8249/log/drainer.log","initial-commit-ts":428691487294750737,"sycner":{"sql-mode":null,"ignore-txn-commit-ts":null,"ignore-schemas":.…]
[2023/09/18 13:44:23.098 +08:00] [INFO] [client.go:193] [”[pd] create pd client with endpoints"] [pd-address=“[http://192.168.1.1:2379,http://192.168.1.4:2379,http://192.168.1.5:2379]”]
[2023/09/18 13:44:23.103 +08:00] [INFO] [base_client.go:308] [“[pd] switch leader”] [new-leader=http://192.168.1.5:2379] [old-leader=]
[2023/09/18 13:44:23.104 +08:00] [INFO] [base_client.go:112] [“[pd] init cluster id”] [cluster-id=6835126175440185974]
[2023/09/18 13:44:23.104 +08:00] [INFO] [server.go:121] [“get cluster id from pd”] [id=6835126175440185974]
[2023/09/18 13:44:23.104 +08:00] [INFO] [client.go:577] [“[pd] tso dispatcher is not ready, wait for a while”]
[2023/09/18 13:44:23.155 +08:00] [WARN] [ts.go:50] [“get timestamp too slow”] [take=50.977852ms]
【资源配置】
【附件:截图/日志/监控】
看日志没报错啊,仔细看看日志有报错信息吗?
这个是报从库delete执行报错,你手动执行下看看
报错从库连不上啊。。。
手动连了是可以连上的
你手工执行下报错的sql呢?
连不上拉,检查下啊
用同步用户去下游库执行报错语句,确认下权限问题