使用dumpling时报create dumper failed: sql: SELECT version();: tls: server selected unsupported protocol version 302

🪐 TiDB 技术问题
1

【 TiDB 使用环境】测试/ Poc
【 TiDB 版本】
【复现路径】tiup dumpling -h 172.18.30.36 -P 3308 -u root -p *** -F 256MiB -B db -T ‘db.t1,db.t2’ -o /root/20240429/ --filetype csv
【遇到的问题：问题现象及影响】Starting component dumpling: /root/.tiup/components/dumpling/v8.0.0/dumpling -h 172.18.30.36 -P 3308 -u root -p *** -F 256MiB -B db -T db.t1,db.t2 -o /root/20240429/ --filetype csv
Release version: v8.0.0
Git commit hash: 8ba1fa452b1ccdbfb85879ea94b9254aabba2916
Git branch: HEAD
Build timestamp: 2024-03-28 02:22:15Z
Go version: go version go1.21.4 linux/amd64

[2024/04/29 15:07:25.374 +08:00] [INFO] [versions.go:54] [“Welcome to dumpling”] [“Release Version”=v8.0.0] [“Git Commit Hash”=8ba1fa452b1ccdbfb85879ea94b9254aabba2916] [“Git Branch”=HEAD] [“Build timestamp”=“2024-03-28 02:22:15”] [“Go Version”=“go version go1.21.4 linux/amd64”]
[2024/04/29 15:07:25.397 +08:00] [WARN] [version.go:333] [“select tidb_version() failed, will fallback to ‘select version();’”] [error=“tls: server selected unsupported protocol version 302”]

create dumper failed: sql: SELECT version();: tls: server selected unsupported protocol version 302
【资源配置】
【附件：截图/日志/监控】

2

看起来客户端与服务端TLS版本不匹配问题.
openssl ciphers -v | awk ‘{print $2}’ | sort | uniq

3

[root@EagleOS bin]# openssl ciphers -v | awk ‘{print $2}’ | sort | uniq
SSLv3
TLSv1
TLSv1.2
TLSv1.3

4

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1351737
Server version: 5.7.20-19-log Source distribution

Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

root@localhost:(none) 03:49:07> status

mysql Ver 14.14 Distrib 5.7.20-19, for Linux (x86_64) using 6.0

Connection id: 1351737
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ‘’
Using delimiter: ;
Server version: 5.7.20-19-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /data/mysql_data/mysql-3308/data/mysqld.sock
Uptime: 84 days 7 hours 10 min 23 sec

Threads: 89 Questions: 198242310 Slow queries: 71083 Opens: 1129360 Flush tables: 1 Open tables: 8192 Queries per second avg: 27.218

5

是不是 tidb 和dumping 版本不兼容？

6

都是v8.0的

7

是指的tidb的客户端跟服务端的版本不一致还是跟mysql端的不一致哈？

8

dumpling要怎么屏蔽掉tls呢？

9

有没有可能是你服务端的client配置里面配置了tls呢

10

看了下报错 应该是版本不匹配

11

配置路径默认是哪里哈？我安装完tidb后没有做额外的配置

12

哪两个版本不匹配？

13

别用dumpling 备份MySQL

14

为啥？官方不是说可以导出mysql吗？

15

都是什么版本哦