Issues Encountered with Full Backup Data in TiDB Lightning

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB Lightning 全量备份数据出现一下问题

| username: Alan

[“select tidb_version() failed, will fallback to ‘select version();’”] [error=“Error 1046: No database selected”]

2
| username: Alan | Original post link

It’s stuck here with no response and no error logs.

3
| username: Alan | Original post link

Seeking help from an expert.

4
| username: Meditator | Original post link

Is Lightning connected to MySQL or TiDB?

5
| username: Ming | Original post link

Could you please provide the environment/version, and if convenient, share the lightning configuration file?

6
| username: Alan | Original post link

MySQL

7
| username: Alan | Original post link

idb-test tidb v6.1.0

8
| username: Alan | Original post link

I can connect to the local kv test.

9
| username: Ming | Original post link

Those two parameters don’t seem quite reasonable there. Status port
I don’t think it’s quite right.
status-port = 10080
pd-addr = “172.16.243.243:2379”

10
| username: Ming | Original post link

These two are aimed at downstream. How to write it in MySQL? It should not be possible.

11
| username: Alan | Original post link

Thank you, it’s already resolved. The issue was caused by data insertion into my target MySQL, which led to a database deadlock when using the tiup dumpling command. As a result, I couldn’t read the database I needed to dump, hence the error occurred.

12
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.