DM Synchronization Data Error: "Message": "[Lightning:Restore:ErrSchemaNotExists] table... schema not found"

Translated
1

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

Original topic: DM同步数据报错：“Message”: “[Lightning:Restore:ErrSchemaNotExists]table…schema not found”,

| username: 飞天小菜狗

【TiDB Usage Environment】Testing Environment
【TiDB Version】

image
image1380×544 113 KB

image
image1380×328 104 KB

【Encountered Issues】
tiup dmctl --master-addr 127.0.0.1:8261 start-task task-ailearn-test.yaml
tiup dmctl --master-addr 127.0.0.1:8261 query-status ailearn-test

image
image1380×788 53.4 KB

【Reproduction Path】
【Issue Phenomenon and Impact】
① When the target table structure does not exist, DM will automatically create this table. Error reported: “Message”: “[Lightning:Restore:ErrSchemaNotExists]table ailearn_test.intell_multi_solution_log schema not found”.
② After stopping the task, cleaning up the dm-meta database information, and manually creating the table structure, the error still occurs: “Message”: “[Lightning:Restore:ErrSchemaNotExists]table ailearn_test.intell_multi_solution_log schema not found”.
【Attachments】
Configuration File:

Logs:
dm-worker_stderr.log (20.6 KB) dm-worker_stderr.log

2
| username: lance6716 | Original post link

Hi, what is needed here is another log file under the stderr directory.

3
| username: 飞天小菜狗 | Original post link

Which one?

4
| username: lance6716 | Original post link

dm_worker.log

5
| username: 飞天小菜狗 | Original post link

It’s over 100 MB, so I compressed it using gzip. Remember to decompress it.
dm-worker.log.gz (7.0 MB) dm-worker.log.gz

6
| username: lance6716 | Original post link

The table you are having issues with is global_id. Can you check the files related to this table in the dump directory (dumped_data.ailearn-test)?

ls -l *global_id*
7
| username: 飞天小菜狗 | Original post link

Thank you, teacher. Restarting it solved the problem.

8
| username: system | Original post link

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