The log information in the full dump phase of DM is missing a table

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

Original topic: DM全量dump阶段日志信息少一个表

| username: chenhanneu

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
Check the DM synchronization task log:
[dumpling.go:299] [“progress status of dumpling”] [task=task_231121_01] [unit=dump] [total_tables=235] [finished_tables=234] [estimated_total_rows=4880299538] [finished_rows=5033309689] [estimated_progress=100.00%] [“new progress”=“100.00 %”] [bps=12889740]

There are a total of 235 tables, it shows that 234 tables have been completed, but the completion rate is still 100%.

| username: TiDBer_小阿飞 | Original post link

First, check the tables on both sides, compare them, and see which table is missing.

| username: chenhanneu | Original post link

I checked the exported *schema.sql, and indeed there are 235 of them.

| username: 大飞哥online | Original post link

Which table is missing?

| username: Kongdom | Original post link

Could it be that there is table filtering? The prompt information indeed shows total_tables 235, finished_tables 234. However, the rows have actually increased. :joy:

| username: WalterWj | Original post link

Is there any DDL during the backup? Check it with admin show.

| username: zhanggame1 | Original post link

Check which tables are missing, whether they have been filtered out or are temporary tables or something like that.

| username: dba远航 | Original post link

Check if there are any special types of tables.

| username: oceanzhang | Original post link

Temporary table???

| username: chenhanneu | Original post link

The full database export did not filter, so if there are tables that do not meet the criteria, they should not be displayed in the total stage, right?
The export file contains the table creation statements for 235 tables. Now, looking at the target end, there are also 235 tables, but since over 100 tables were manually created in advance on the target end, it’s not easy to check if there are any issues.

| username: 有猫万事足 | Original post link

Try using this tool.

| username: 小龙虾爱大龙虾 | Original post link

First, find out the table name and see if there is anything special about that table.

| username: system | Original post link

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