本页为增量迁移/同步阶段报插入数据字段不存在(unknown column 'xxx' in field list)错误的场景、关键词、可能原因和修复方法建议。 场景描述 包含增量迁移/同步的任务,在进行增量同步时任务异常,错误日志信息提示包含“unknown column 'xxx' in field list'”。 关键词 unknown column 'xxx' in field list 可能原因 任务未勾选DDL同步,但是源库新增了字段,导致最新的DML携带了新增字段。
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#