Error "Message": "[Lightning:Restore:ErrSchemaNotExists] table `ailearn_yace`.`intell_third_poll_data` schema not found" reported during DM load

Translated
1

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

Original topic: DM load 的时候报 “Message”: “[Lightning:Restore:ErrSchemaNotExists]table ailearn_yace.intell_third_poll_data schema not found”,

| username: Johnpan

DM version 6.1.0, TiDB version 5.4.0

When DM is loading, it reports that the target table does not exist, but upon checking, the table is present in the target schema.
“Message”: “[Lightning:Restore:ErrSchemaNotExists]table ailearn_yace.intell_third_poll_data schema not found”

image
image1184×342 8.52 KB

TiDB Usage Environment: Testing Environment
TiDB Version
Encountered Issue
Reproduction Path: What operations were performed to encounter the issue
Issue Phenomenon and Impact
Attachments

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: tidb狂热爱好者 | Original post link

For tables without primary keys, the performance is not good.

3
| username: Johnpan | Original post link

What do you mean, this table has a primary key?

4
| username: wuxiangdong | Original post link

Is it possible that the database name is written incorrectly? The one above uses a hyphen, but the error message shows an underscore.

5
| username: wuxiangdong | Original post link

ailearn-yace, ailearn_yace

6
| username: Johnpan | Original post link

That’s right, ailearn-yace is the task name, and ailearn_yace is the library name.

7
| username: guominghao | Original post link

Could you please upload the dm worker logs, stdout.log/dm-worker.log?

8
| username: Johnpan | Original post link

Problem solved. The issue was insufficient permissions because the user was created by someone else previously. I didn’t check carefully and made a rookie mistake.

9
| username: guominghao | Original post link

Did the pre-check not detect it?

10
| username: Johnpan | Original post link

The libraries they added later.

11
| username: system | Original post link

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