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

Original topic: Lightning:Restore:ErrSchemaNotExists

| username: TiDBer_SlmOyGbl

[Test Environment for TiDB] Testing
[TiDB Version] 5.3.3
[Encountered Issue: Phenomenon and Impact] When importing data using Lightning, the tidb mode works fine, but the local mode reports the error Lightning:Restore:ErrSchemaNotExists.
[Solution] 专栏 - 探索TiDB Lightning源码来解决发现的bug | TiDB 社区 The table list of the target database is obtained through the remote method provided by each Backend. For the local mode, it actually calls the status port of TiDB to get it (port 10080 in the configuration file): curl http://{tidb-server}:10080/schema/test. To achieve balanced use of TiDB-server resources, F5 is configured, and the IP in the [tidb] connection information is filled with the load balancer’s VIP, causing the local mode to report a table not found error. You need to change the [tidb] connection information to the IP of the tidb-server or expose port 10080 for the VIP, which corresponds to port 10080 of the tidb-server.

| username: Billmay表妹 | Original post link

  1. Check if it is a permissions issue.
  2. It was mentioned above that restarting seems to solve the error problem.
| username: TiDBer_SlmOyGbl | Original post link

The reason is that the load balancer is not configured with port 10080.

| username: system | Original post link

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