delete数据报错delete job timeout

Viewed 46

doris版本2.1.3
删除数据日志显示异常,执行时间特别慢,报错信息:delete job timeout, timeout(ms):30000, msg:unfinished replicas [BackendId=TabletId]: 10105=2875402, 10105=2875390, 10105=2875406, 10105=2875378, 10105=2875394
出现较多删除报错,执行生气了:DELETE FROM table_t WHERE (province_name = '广东' AND column_a = '10686111' AND column_b = '10686111212380'),其中province_name为分区列

2 Answers

导致未删除的脏数据无法清理,脏数据后续怎么处理呢,已经开启了批量提交了,提交模式设置是同步方式

解决了没?遇到相同的问题了,没办法解决,只有把对应TRUNCATE表数据重新跑了一遍

通过下面的命令把上面的tabletId都设置为bad=true,然后再查询bad列的值依然为false
ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "11032", "backend_id" = "10002", "status" = "bad");
参考的https://blog.csdn.net/ppfreedom/article/details/125021626

还是将此表清空后重新跑任务补全上来的。参考https://blog.csdn.net/k7gxn56/article/details/143177770