Doris 版本
- 2.1.8
fe.log 异常日志
2025-09-10 09:29:13,099 WARN (Auto Analysis Job Executor-0|644) [OlapInsertExecutor.onFail():229] insert [label_be02d56b4a054691_bd5c5bc292041824] with query id be02d56b4a054691-bd5c5bc292041824 failed
org.apache.doris.nereids.exceptions.AnalysisException: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029]
at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:176) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:205) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:134) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.runInternal(InsertIntoTableCommand.java:315) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.run(InsertIntoTableCommand.java:124) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:729) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:561) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:537) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.executeWithExceptionOnFail(AnalysisJob.java:151) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.writeBuf(AnalysisJob.java:133) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.markOneTaskDone(AnalysisJob.java:87) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.appendBuf(AnalysisJob.java:75) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.runQuery(BaseAnalysisTask.java:311) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doSample(OlapAnalysisTask.java:178) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doExecute(OlapAnalysisTask.java:84) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.execute(BaseAnalysisTask.java:175) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisTaskWrapper.lambda$new$0(AnalysisTaskWrapper.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at org.apache.doris.statistics.AnalysisTaskWrapper.run(AnalysisTaskWrapper.java:66) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_362]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_362]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_362]
Caused by: org.apache.doris.common.UserException: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029]
at org.apache.doris.planner.OlapTableSink.createLocation(OlapTableSink.java:660) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OlapTableSink.complete(OlapTableSink.java:232) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:132) ~[doris-fe.jar:1.2-SNAPSHOT]
... 23 more
2025-09-10 09:29:13,106 INFO (Auto Analysis Job Executor-0|644) [DatabaseTransactionMgr.abortTransaction():1644] abort transaction: TransactionState. transaction id: 225061457, label: label_be02d56b4a054691_bd5c5bc292041824, db id: 10002, table id list: 13250, callback id: -1, coordinator: FE: 10.11.59.162, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1757467753098, commit time: -1, finish time: 1757467753099, reason: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029] successfully
2025-09-10 09:29:13,111 INFO (Auto Analysis Job Executor-0|644) [DatabaseTransactionMgr.beginTransaction():396] begin transaction: txn id 225061458 with label insert_be02d56b4a054691_bd5c5bc292041824 from coordinator FE: 10.11.59.162, listener id: -1
2025-09-10 09:29:13,112 WARN (Auto Analysis Job Executor-0|644) [StmtExecutor.executeByLegacy():1025] execute Exception. stmt[3552554, be02d56b4a054691-bd5c5bc292041824]
org.apache.doris.common.UserException: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029]
at org.apache.doris.planner.OlapTableSink.createLocation(OlapTableSink.java:660) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OlapTableSink.complete(OlapTableSink.java:232) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.analysis.NativeInsertStmt.complete(NativeInsertStmt.java:1091) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.createPlanFragments(OriginalPlanner.java:244) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.plan(OriginalPlanner.java:97) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1463) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1268) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:900) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:613) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:537) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.executeWithExceptionOnFail(AnalysisJob.java:151) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.writeBuf(AnalysisJob.java:133) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.markOneTaskDone(AnalysisJob.java:87) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.appendBuf(AnalysisJob.java:75) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.runQuery(BaseAnalysisTask.java:311) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doSample(OlapAnalysisTask.java:178) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doExecute(OlapAnalysisTask.java:84) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.execute(BaseAnalysisTask.java:175) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisTaskWrapper.lambda$new$0(AnalysisTaskWrapper.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at org.apache.doris.statistics.AnalysisTaskWrapper.run(AnalysisTaskWrapper.java:66) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_362]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_362]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_362]
2025-09-10 09:29:13,117 INFO (Auto Analysis Job Executor-0|644) [DatabaseTransactionMgr.abortTransaction():1644] abort transaction: TransactionState. transaction id: 225061458, label: insert_be02d56b4a054691_bd5c5bc292041824, db id: 10002, table id list: 13250, callback id: -1, coordinator: FE: 10.11.59.162, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1757467753111, commit time: -1, finish time: 1757467753113, reason: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029] successfully
2025-09-10 09:29:13,118 WARN (Auto Analysis Job Executor-0|644) [BaseAnalysisTask.runQuery():313] Failed to execute sql SELECT CONCAT('62771272', '-', '-1', '-', 'finish_rule') AS `id`, 0 AS `catalog_id`, 14115 AS `db_id`, 62771272 AS `tbl_id`, -1 AS `idx_id`, 'finish_rule' AS `col_id`, NULL AS `part_id`, 1587221 AS `row_count`, SUM(`t1`.`count`) * COUNT(1) / (SUM(`t1`.`count`) - SUM(IF(`t1`.`count` = 1, 1, 0)) + SUM(IF(`t1`.`count` = 1, 1, 0)) * SUM(`t1`.`count`) / 1587221) as `ndv`, IFNULL(SUM(IF(`t1`.`column_key` IS NULL, `t1`.`count`, 0)), 0) * 1.0 as `null_count`, SUBSTRING(CAST('"关于付款周期与比例的约定： 中期计量结算时，承包人将逐期扣劳务分包人结算款作为保证金，其中：工程质量保证金 3% ，农民工工资保证金 5% 。工程质量保证金须待项目总体缺陷责任期满后，如无工程缺陷，全部无息返还；如出现工程质量缺陷，返修费用由劳务分包人承担，劳务分包人的工程质量保证金内支付，不足部分由劳务分包人另行承担。农民工工资保证金在该项工程交工�' AS STRING), 1, 1024) AS `min`, SUBSTRING(CAST('：（1）整体封闭母线工程完工，验收达到合格后，付至已结算金额的55%；（3）工程竣工验收达到合格、完成竣工验收备案、竣工审计结束、资料及竣工验收后三个月无农民工工资争议支付至已结算金额的97%，余款3%质保期满后无息支付。具体支付周期及支付比例视分包人施工相应工程发包人计量支付款到位情况进行支付。如出现因发包人原因造成对承包人工程款拔付不及时情况，承包�' AS STRING), 1, 1024) AS `max`, SUM(`column_length`) * 1.0 AS `data_size`, NOW() FROM ( SELECT t0.`colValue` as `column_key`, COUNT(1) as `count`, SUM(`len`) as `column_length` FROM (SELECT xxhash_64(SUBSTRING(CAST(`finish_rule` AS STRING), 1, 1024)) AS `colValue`, LENGTH(`finish_rule`) as `len` FROM `internal`.`ods`.`ods_cccc_dwd_cdm_con_spec_i_d` limit 1587221) as `t0` GROUP BY `t0`.`colValue` ) as `t1`
2025-09-10 09:29:13,118 WARN (Expired Analysis Task Killer|44) [AnalysisTaskWrapper.cancel():85] Job id [349349060], Task id [349349133], catalog [internal], db [ods], table [ods_cccc_dwd_cdm_con_spec_i_d], column [finish_rule] cancelled, cost time:300
2025-09-10 09:29:13,118 WARN (Auto Analysis Job Executor-0|644) [AnalysisTaskWrapper.run():76] Analyze Job id [349349060], Task id [349349133], catalog [internal], db [ods], table [ods_cccc_dwd_cdm_con_spec_i_d], column [finish_rule] failed.
java.util.concurrent.ExecutionException: java.lang.RuntimeException: Failed to analyze: Failed to insert : INSERT INTO internal.__internal_schema.column_statistics VALUES ('62771272--1-pay_rule',0,14115,62771272,-1,'pay_rule',null,1587221,5547,1210029,'"1.合同签订后支付预付款 40％，2）生产完成发货前支付到合同金额的 80％，3）模具现场组装完成验收合格支付到合同额的 95％，4）剩余款项验收合格 3 个月后支付到100％。','：工程完工后，乙方将实际爆破方量上报甲方技术员、测量组、工程部、监理以及建设单位进行审核，并签订工程数量签认单，经审核无误后上报甲方经营部，经营部按照乙方实际完成并不超设计量进行结算。',8642913,'2025-09-10 09:28:52'),('62771272--1-interest_rate',0,14115,62771272,-1,'interest_rate',null,1587221,110,1585109,'0','7.03',5515,'2025-09-10 09:28:53'),('62771272--1-register_amt',0,14115,62771272,-1,'register_amt',null,1587221,23,1587026,'0','90000000',1254,'2025-09-10 09:28:53'),('62771272--1-borrower_name',0,14115,62771272,-1,'borrower_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:53'),('62771272--1-parties_unit_id',0,14115,62771272,-1,'parties_unit_id',null,1587221,5193,85704,'101094838','1331161',13501291,'2025-09-10 09:28:53'),('62771272--1-kxxz',0,14115,62771272,-1,'kxxz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:54'),('62771272--1-register_amt_currency',0,14115,62771272,-1,'register_amt_currency',null,1587221,2,1587006,'156','156',645,'2025-09-10 09:28:55'),('62771272--1-rate_method',0,14115,62771272,-1,'rate_method',null,1587221,6,169225,'01','99',2835932,'2025-09-10 09:28:55'),('62771272--1-contract_payment_terms',0,14115,62771272,-1,'contract_payment_terms',null,1587221,77816,67205,'"(三)燃油约定履行
1.燃油由承租方负责并承担费用，并单独使用中国石油柴油加注2.其它油料由_承租方 负责并承担费用
(四)结算办理、租金、调遣费支付方式:
(1)结算方式:按月办理租赁费用。承租方在取得出租方合规的增值税发票后，租金每月5日办理结算一次
(2)付款方式为现金支付。次月20日前，承租方需向出租方支付上个月租金。
(3)因承租方原因未按照约定每月5办理结算，超过15�','？',240554721,'2025-09-10 09:28:56'),('62771272--1-period',0,14115,62771272,-1,'period',null,1587221,1771,1017314,'0','999',1225230,'2025-09-10 09:28:57'),('62771272--1-payment_method',0,14115,62771272,-1,'payment_method',null,1587221,4,1124408,'01','03',925626,'2025-09-10 09:28:57'),('62771272--1-bank_account',0,14115,62771272,-1,'bank_account',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:57'),('62771272--1-paymentcurrency',0,14115,62771272,-1,'paymentcurrency',null,1587221,67,266,'050','CNY',4772569,'2025-09-10 09:28:58'),('62771272--1-finish_ratio',0,14115,62771272,-1,'finish_ratio',null,1587221,85,1014535,'0','99.7',1265189,'2025-09-10 09:28:58'),('62771272--1-pay_amt',0,14115,62771272,-1,'pay_amt',null,1587221,2381,1014535,'0','9999995',689846,'2025-09-10 09:28:59'),('62771272--1-rent_bgamt',0,14115,62771272,-1,'rent_bgamt',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:59'),('62771272--1-con_main_code',0,14115,62771272,-1,'con_main_code',null,1587221,336133,0,'CT199911577549','CT202516549006',22996012,'2025-09-10 09:28:59'),('62771272--1-interest_rate_zl',0,14115,62771272,-1,'interest_rate_zl',null,1587221,3,1585154,'01','02',4134,'2025-09-10 09:29:00'),('62771272--1-aitt',0,14115,62771272,-1,'aitt',null,1587221,6,1582944,'01','99',8554,'2025-09-10 09:29:00'),('62771272--1-defects_liability_period',0,14115,62771272,-1,'defects_liability_period',null,1587221,447,1049093,'0','999',1356397,'2025-09-10 09:29:00'),('62771272--1-lender_name',0,14115,62771272,-1,'lender_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:01'),('62771272--1-loan_purpose',0,14115,62771272,-1,'loan_purpose',null,1587221,198,1585142,'/','首都地区环线高速公路（通州-大兴段）项目建设需要',70199,'2025-09-10 09:29:01'),('62771272--1-change_period',0,14115,62771272,-1,'change_period',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:01'),('62771272--1-entrust_lender_id',0,14115,62771272,-1,'entrust_lender_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:02'),('62771272--1-iszsq',0,14115,62771272,-1,'iszsq',null,1587221,3,1587086,'0','1',135,'2025-09-10 09:29:02'),('62771272--1-sec_org',0,14115,62771272,-1,'sec_org',null,1587221,1,0,'101140128','101140128',14284989,'2025-09-10 09:29:02'),('62771272--1-pay_ratio',0,14115,62771272,-1,'pay_ratio',null,1587221,100,1014543,'0','98',589467,'2025-09-10 09:29:02'),('62771272--1-pay_cycle',0,14115,62771272,-1,'pay_cycle',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-borrower_id',0,14115,62771272,-1,'borrower_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-is_sfyyfk',0,14115,62771272,-1,'is_sfyyfk',null,1587221,3,5149,'0','1',1582072,'2025-09-10 09:29:03'),('62771272--1-lender_id',0,14115,62771272,-1,'lender_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-valid_type',0,14115,62771272,-1,'valid_type',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:04'),('62771272--1-delivery_method',0,14115,62771272,-1,'delivery_method',null,1587221,5,1123692,'01','04',927058,'2025-09-10 09:29:04'),('62771272--1-source_frame_ptlstutas',0,14115,62771272,-1,'source_frame_ptlstutas',null,1587221,3,1051283,'0','1',535938,'2025-09-10 09:29:04'),('62771272--1-load_time',0,14115,62771272,-1,'load_time',null,1587221,618,0,'2023-09-18','2025-09-08',15872210,'2025-09-10 09:29:04'),('62771272--1-from_sys_code',0,14115,62771272,-1,'from_sys_code',null,1587221,11,220692,'CDC-MDM','ZY-PMS',5592630,'2025-09-10 09:29:04'),('62771272--1-bank_name',0,14115,62771272,-1,'bank_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:05'),('62771272--1-pay_xz',0,14115,62771272,-1,'pay_xz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:05'),('62771272--1-business_type',0,14115,62771272,-1,'business_type',null,1587221,82,85704,'0101','0899',6006068,'2025-09-10 09:29:05'),('62771272--1-place',0,14115,62771272,-1,'place',null,1587221,22401,1107779,' G109贡那一分部指定地点','龙港项目部',27290739,'2025-09-10 09:29:05'),('62771272--1-start_date',0,14115,62771272,-1,'start_date',null,1587221,3110,1326821,'2003-05-10','2027-08-08',6348884,'2025-09-10 09:29:05'),('62771272--1-corporate_name',0,14115,62771272,-1,'corporate_name',null,1587221,39,1587010,'一公局_九江宏源八里湖项目管理有限公司','阳江市世通绿色建材有限责任公司',10012,'2025-09-10 09:29:06'),('62771272--1-invoice_type',0,14115,62771272,-1,'invoice_type',null,1587221,197,4199,',01','99',3886404,'2025-09-10 09:29:06'),('62771272--1-etl_part',0,14115,62771272,-1,'etl_part',null,1587221,247,0,'2024-10-22','2025-09-09',15872210,'2025-09-10 09:29:06'),('62771272--1-now_register_amt',0,14115,62771272,-1,'now_register_amt',null,1587221,23,1587026,'0','90000000',1254,'2025-09-10 09:29:06'),('62771272--1-third_org',0,14115,62771272,-1,'third_org',null,1587221,300,279095,'101094838','1329317',11773094,'2025-09-10 09:29:06'),('62771272--1-purchase_method',0,14115,62771272,-1,'purchase_method',null,1587221,6,1160848,'01','05',852746,'2025-09-10 09:29:07'),('62771272--1-progress_ratio',0,14115,62771272,-1,'progress_ratio',null,1587221,121,1014535,'0','99.75',865310,'2025-09-10 09:29:07'),('62771272--1-trust_fund_currency',0,14115,62771272,-1,'trust_fund_currency',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:07'),('62771272--1-is_gqxxbg',0,14115,62771272,-1,'is_gqxxbg',null,1587221,2,1587026,'0','0',195,'2025-09-10 09:29:07'),('62771272--1-entrust_lender_name',0,14115,62771272,-1,'entrust_lender_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:07'),('62771272--1-end_date',0,14115,62771272,-1,'end_date',null,1587221,3491,1327327,'2003-07-01','2093-05-25',6348884,'2025-09-10 09:29:08'),('62771272--1-pay_date',0,14115,62771272,-1,'pay_date',null,1587221,1,1587221,'null','null',6348884,'2025-09-10 09:29:08'),('62771272--1-business_main_code',0,14115,62771272,-1,'business_main_code',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:08'),('62771272--1-progress_rule',0,14115,62771272,-1,'progress_rule',null,1587221,13220,1129117,'"1.1 在该批次电梯安装进场后的60天内，发包人经总承包人支付该批次电梯安装合同价款的30%的进度款； 1.2 电梯安装调试完成并经发包人、总承包人、监理及电梯主管部门（项目所在地）质量技术监督局验收合格，取得电梯《安全检验合格证》后30天内， 发包人经总承包人向分包人支付该批次电梯安装合同价款的60%； 中交海南总部','：（1）整体封闭母线工程完工，验收达到合格后，付至已结算金额的55%；（3）工程竣工验收达到合格、完成竣工验收备案、竣工审计结束、资料及竣工验收后三个月无农民工工资争议支付至已结算金额的97%，余款3%质保期满后无息支付。具体支付周期及支付比例视分包人施工相应工程发包人计量支付款到位情况进行支付。如出现因发包人原因造成对承包人工程款拔付不及时情况，承包�',61700327,'2025-09-10 09:29:09'),('62771272--1-is_zysx',0,14115,62771272,-1,'is_zysx',null,1587221,3,1585142,'0','1',2079,'2025-09-10 09:29:09'),('62771272--1-register_amt_rate',0,14115,62771272,-1,'register_amt_rate',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-bank_kind',0,14115,62771272,-1,'bank_kind',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-sxfs',0,14115,62771272,-1,'sxfs',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-now_payment_rules',0,14115,62771272,-1,'now_payment_rules',null,1587221,25,1587093,'135670000.00','首期注册资本到位时间为申请领取营业执照后60日内，金额为：人民币_60000000 元（大写陆仟万元整）；其中政府出资方出资人民币_6000000 元（大写陆佰万元整），中交一公局集团出资人民币_54000000 元（大写伍仟肆佰',17132,'2025-09-10 09:29:10'),('62771272--1-is_zfbz',0,14115,62771272,-1,'is_zfbz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:10'),('62771272--1-capitalpaymentrules',0,14115,62771272,-1,'capitalpaymentrules',null,1587221,31,1587026,'0','首期出资甲乙双方的出资比例达到各自认缴出资额的 50%，应于中标通知书发出之日起 100日内出资到位',17232,'2025-09-10 09:29:10'),('62771272--1-credit_main_code',0,14115,62771272,-1,'credit_main_code',null,1587221,11,1587177,'0','SXGT-0702-20220513153011773',524,'2025-09-10 09:29:10'),('62771272--1-interest_rate_type',0,14115,62771272,-1,'interest_rate_type',null,1587221,4,1585154,'01','03',4134,'2025-09-10 09:29:10'),('62771272--1-rent_free_period',0,14115,62771272,-1,'rent_free_period',null,1587221,40,1546217,'0','90',42365,'2025-09-10 09:29:11'),('62771272--1-pay_method',0,14115,62771272,-1,'pay_method',null,1587221,7,6544,'0','99',2827651,'2025-09-10 09:29:11'),('62771272--1-interest_rate_tzzq',0,14115,62771272,-1,'interest_rate_tzzq',null,1587221,4,1587143,'01','03',156,'2025-09-10 09:29:11'),('62771272--1-exit_date',0,14115,62771272,-1,'exit_date',null,1587221,2291,1539440,'0216-08-25','2028-08-20',6348884,'2025-09-10 09:29:11'),('62771272--1-lease_type',0,14115,62771272,-1,'lease_type',null,1587221,6,1551634,'01','99',71174,'2025-09-10 09:29:11'),('62771272--1-corporate_id',0,14115,62771272,-1,'corporate_id',null,1587221,39,1587010,'BP00110997','BP01339433',2110,'2025-09-10 09:29:12'),('62771272--1-compensate_rule',0,14115,62771272,-1,'compensate_rule',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:12'),('62771272--1-pricing_method',0,14115,62771272,-1,'pricing_method',null,1587221,2,1587205,'01','01',32,'2025-09-10 09:29:12'),('62771272--1-push_sink_time',0,14115,62771272,-1,'push_sink_time',null,1587221,11305,0,'2024-09-23 15:01:07','2025-09-09 08:45:08',12697768,'2025-09-10 09:29:12'),('62771272--1-finish_rule',0,14115,62771272,-1,'finish_rule',null,1587221,12150,1126310,'"关于付款周期与比例的约定： 中期计量结算时，承包人将逐期扣劳务分包人结算款作为保证金，其中：工程质量保证金 3% ，农民工工资保证金 5% 。工程质量保证金须待项目总体缺陷责任期满后，如无工程缺陷，全部无息返还；如出现工程质量缺陷，返修费用由劳务分包人承担，劳务分包人的工程质量保证金内支付，不足部分由劳务分包人另行承担。农民工工资保证金在该项工程交工�','：（1）整体封闭母线工程完工，验收达到合格后，付至已结算金额的55%；（3）工程竣工验收达到合格、完成竣工验收备案、竣工审计结束、资料及竣工验收后三个月无农民工工资争议支付至已结算金额的97%，余款3%质保期满后无息支付。具体支付周期及支付比例视分包人施工相应工程发包人计量支付款到位情况进行支付。如出现因发包人原因造成对承包人工程款拔付不及时情况，承包�',51298996,'2025-09-10 09:29:12')Error msg: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029]
at java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:1.8.0_362]
at java.util.concurrent.FutureTask.get(FutureTask.java:192) ~[?:1.8.0_362]
at org.apache.doris.statistics.AnalysisTaskWrapper.run(AnalysisTaskWrapper.java:67) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_362]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_362]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_362]
Caused by: java.lang.RuntimeException: Failed to analyze: Failed to insert : INSERT INTO internal.__internal_schema.column_statistics VALUES ('62771272--1-pay_rule',0,14115,62771272,-1,'pay_rule',null,1587221,5547,1210029,'"1.合同签订后支付预付款 40％，2）生产完成发货前支付到合同金额的 80％，3）模具现场组装完成验收合格支付到合同额的 95％，4）剩余款项验收合格 3 个月后支付到100％。','：工程完工后，乙方将实际爆破方量上报甲方技术员、测量组、工程部、监理以及建设单位进行审核，并签订工程数量签认单，经审核无误后上报甲方经营部，经营部按照乙方实际完成并不超设计量进行结算。',8642913,'2025-09-10 09:28:52'),('62771272--1-interest_rate',0,14115,62771272,-1,'interest_rate',null,1587221,110,1585109,'0','7.03',5515,'2025-09-10 09:28:53'),('62771272--1-register_amt',0,14115,62771272,-1,'register_amt',null,1587221,23,1587026,'0','90000000',1254,'2025-09-10 09:28:53'),('62771272--1-borrower_name',0,14115,62771272,-1,'borrower_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:53'),('62771272--1-parties_unit_id',0,14115,62771272,-1,'parties_unit_id',null,1587221,5193,85704,'101094838','1331161',13501291,'2025-09-10 09:28:53'),('62771272--1-kxxz',0,14115,62771272,-1,'kxxz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:54'),('62771272--1-register_amt_currency',0,14115,62771272,-1,'register_amt_currency',null,1587221,2,1587006,'156','156',645,'2025-09-10 09:28:55'),('62771272--1-rate_method',0,14115,62771272,-1,'rate_method',null,1587221,6,169225,'01','99',2835932,'2025-09-10 09:28:55'),('62771272--1-contract_payment_terms',0,14115,62771272,-1,'contract_payment_terms',null,1587221,77816,67205,'"(三)燃油约定履行
1.燃油由承租方负责并承担费用，并单独使用中国石油柴油加注2.其它油料由_承租方 负责并承担费用
(四)结算办理、租金、调遣费支付方式:
(1)结算方式:按月办理租赁费用。承租方在取得出租方合规的增值税发票后，租金每月5日办理结算一次
(2)付款方式为现金支付。次月20日前，承租方需向出租方支付上个月租金。
(3)因承租方原因未按照约定每月5办理结算，超过15�','？',240554721,'2025-09-10 09:28:56'),('62771272--1-period',0,14115,62771272,-1,'period',null,1587221,1771,1017314,'0','999',1225230,'2025-09-10 09:28:57'),('62771272--1-payment_method',0,14115,62771272,-1,'payment_method',null,1587221,4,1124408,'01','03',925626,'2025-09-10 09:28:57'),('62771272--1-bank_account',0,14115,62771272,-1,'bank_account',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:57'),('62771272--1-paymentcurrency',0,14115,62771272,-1,'paymentcurrency',null,1587221,67,266,'050','CNY',4772569,'2025-09-10 09:28:58'),('62771272--1-finish_ratio',0,14115,62771272,-1,'finish_ratio',null,1587221,85,1014535,'0','99.7',1265189,'2025-09-10 09:28:58'),('62771272--1-pay_amt',0,14115,62771272,-1,'pay_amt',null,1587221,2381,1014535,'0','9999995',689846,'2025-09-10 09:28:59'),('62771272--1-rent_bgamt',0,14115,62771272,-1,'rent_bgamt',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:28:59'),('62771272--1-con_main_code',0,14115,62771272,-1,'con_main_code',null,1587221,336133,0,'CT199911577549','CT202516549006',22996012,'2025-09-10 09:28:59'),('62771272--1-interest_rate_zl',0,14115,62771272,-1,'interest_rate_zl',null,1587221,3,1585154,'01','02',4134,'2025-09-10 09:29:00'),('62771272--1-aitt',0,14115,62771272,-1,'aitt',null,1587221,6,1582944,'01','99',8554,'2025-09-10 09:29:00'),('62771272--1-defects_liability_period',0,14115,62771272,-1,'defects_liability_period',null,1587221,447,1049093,'0','999',1356397,'2025-09-10 09:29:00'),('62771272--1-lender_name',0,14115,62771272,-1,'lender_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:01'),('62771272--1-loan_purpose',0,14115,62771272,-1,'loan_purpose',null,1587221,198,1585142,'/','首都地区环线高速公路（通州-大兴段）项目建设需要',70199,'2025-09-10 09:29:01'),('62771272--1-change_period',0,14115,62771272,-1,'change_period',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:01'),('62771272--1-entrust_lender_id',0,14115,62771272,-1,'entrust_lender_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:02'),('62771272--1-iszsq',0,14115,62771272,-1,'iszsq',null,1587221,3,1587086,'0','1',135,'2025-09-10 09:29:02'),('62771272--1-sec_org',0,14115,62771272,-1,'sec_org',null,1587221,1,0,'101140128','101140128',14284989,'2025-09-10 09:29:02'),('62771272--1-pay_ratio',0,14115,62771272,-1,'pay_ratio',null,1587221,100,1014543,'0','98',589467,'2025-09-10 09:29:02'),('62771272--1-pay_cycle',0,14115,62771272,-1,'pay_cycle',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-borrower_id',0,14115,62771272,-1,'borrower_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-is_sfyyfk',0,14115,62771272,-1,'is_sfyyfk',null,1587221,3,5149,'0','1',1582072,'2025-09-10 09:29:03'),('62771272--1-lender_id',0,14115,62771272,-1,'lender_id',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:03'),('62771272--1-valid_type',0,14115,62771272,-1,'valid_type',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:04'),('62771272--1-delivery_method',0,14115,62771272,-1,'delivery_method',null,1587221,5,1123692,'01','04',927058,'2025-09-10 09:29:04'),('62771272--1-source_frame_ptlstutas',0,14115,62771272,-1,'source_frame_ptlstutas',null,1587221,3,1051283,'0','1',535938,'2025-09-10 09:29:04'),('62771272--1-load_time',0,14115,62771272,-1,'load_time',null,1587221,618,0,'2023-09-18','2025-09-08',15872210,'2025-09-10 09:29:04'),('62771272--1-from_sys_code',0,14115,62771272,-1,'from_sys_code',null,1587221,11,220692,'CDC-MDM','ZY-PMS',5592630,'2025-09-10 09:29:04'),('62771272--1-bank_name',0,14115,62771272,-1,'bank_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:05'),('62771272--1-pay_xz',0,14115,62771272,-1,'pay_xz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:05'),('62771272--1-business_type',0,14115,62771272,-1,'business_type',null,1587221,82,85704,'0101','0899',6006068,'2025-09-10 09:29:05'),('62771272--1-place',0,14115,62771272,-1,'place',null,1587221,22401,1107779,' G109贡那一分部指定地点','龙港项目部',27290739,'2025-09-10 09:29:05'),('62771272--1-start_date',0,14115,62771272,-1,'start_date',null,1587221,3110,1326821,'2003-05-10','2027-08-08',6348884,'2025-09-10 09:29:05'),('62771272--1-corporate_name',0,14115,62771272,-1,'corporate_name',null,1587221,39,1587010,'一公局_九江宏源八里湖项目管理有限公司','阳江市世通绿色建材有限责任公司',10012,'2025-09-10 09:29:06'),('62771272--1-invoice_type',0,14115,62771272,-1,'invoice_type',null,1587221,197,4199,',01','99',3886404,'2025-09-10 09:29:06'),('62771272--1-etl_part',0,14115,62771272,-1,'etl_part',null,1587221,247,0,'2024-10-22','2025-09-09',15872210,'2025-09-10 09:29:06'),('62771272--1-now_register_amt',0,14115,62771272,-1,'now_register_amt',null,1587221,23,1587026,'0','90000000',1254,'2025-09-10 09:29:06'),('62771272--1-third_org',0,14115,62771272,-1,'third_org',null,1587221,300,279095,'101094838','1329317',11773094,'2025-09-10 09:29:06'),('62771272--1-purchase_method',0,14115,62771272,-1,'purchase_method',null,1587221,6,1160848,'01','05',852746,'2025-09-10 09:29:07'),('62771272--1-progress_ratio',0,14115,62771272,-1,'progress_ratio',null,1587221,121,1014535,'0','99.75',865310,'2025-09-10 09:29:07'),('62771272--1-trust_fund_currency',0,14115,62771272,-1,'trust_fund_currency',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:07'),('62771272--1-is_gqxxbg',0,14115,62771272,-1,'is_gqxxbg',null,1587221,2,1587026,'0','0',195,'2025-09-10 09:29:07'),('62771272--1-entrust_lender_name',0,14115,62771272,-1,'entrust_lender_name',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:07'),('62771272--1-end_date',0,14115,62771272,-1,'end_date',null,1587221,3491,1327327,'2003-07-01','2093-05-25',6348884,'2025-09-10 09:29:08'),('62771272--1-pay_date',0,14115,62771272,-1,'pay_date',null,1587221,1,1587221,'null','null',6348884,'2025-09-10 09:29:08'),('62771272--1-business_main_code',0,14115,62771272,-1,'business_main_code',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:08'),('62771272--1-progress_rule',0,14115,62771272,-1,'progress_rule',null,1587221,13220,1129117,'"1.1 在该批次电梯安装进场后的60天内，发包人经总承包人支付该批次电梯安装合同价款的30%的进度款； 1.2 电梯安装调试完成并经发包人、总承包人、监理及电梯主管部门（项目所在地）质量技术监督局验收合格，取得电梯《安全检验合格证》后30天内， 发包人经总承包人向分包人支付该批次电梯安装合同价款的60%； 中交海南总部','：（1）整体封闭母线工程完工，验收达到合格后，付至已结算金额的55%；（3）工程竣工验收达到合格、完成竣工验收备案、竣工审计结束、资料及竣工验收后三个月无农民工工资争议支付至已结算金额的97%，余款3%质保期满后无息支付。具体支付周期及支付比例视分包人施工相应工程发包人计量支付款到位情况进行支付。如出现因发包人原因造成对承包人工程款拔付不及时情况，承包�',61700327,'2025-09-10 09:29:09'),('62771272--1-is_zysx',0,14115,62771272,-1,'is_zysx',null,1587221,3,1585142,'0','1',2079,'2025-09-10 09:29:09'),('62771272--1-register_amt_rate',0,14115,62771272,-1,'register_amt_rate',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-bank_kind',0,14115,62771272,-1,'bank_kind',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-sxfs',0,14115,62771272,-1,'sxfs',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:09'),('62771272--1-now_payment_rules',0,14115,62771272,-1,'now_payment_rules',null,1587221,25,1587093,'135670000.00','首期注册资本到位时间为申请领取营业执照后60日内，金额为：人民币_60000000 元（大写陆仟万元整）；其中政府出资方出资人民币_6000000 元（大写陆佰万元整），中交一公局集团出资人民币_54000000 元（大写伍仟肆佰',17132,'2025-09-10 09:29:10'),('62771272--1-is_zfbz',0,14115,62771272,-1,'is_zfbz',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:10'),('62771272--1-capitalpaymentrules',0,14115,62771272,-1,'capitalpaymentrules',null,1587221,31,1587026,'0','首期出资甲乙双方的出资比例达到各自认缴出资额的 50%，应于中标通知书发出之日起 100日内出资到位',17232,'2025-09-10 09:29:10'),('62771272--1-credit_main_code',0,14115,62771272,-1,'credit_main_code',null,1587221,11,1587177,'0','SXGT-0702-20220513153011773',524,'2025-09-10 09:29:10'),('62771272--1-interest_rate_type',0,14115,62771272,-1,'interest_rate_type',null,1587221,4,1585154,'01','03',4134,'2025-09-10 09:29:10'),('62771272--1-rent_free_period',0,14115,62771272,-1,'rent_free_period',null,1587221,40,1546217,'0','90',42365,'2025-09-10 09:29:11'),('62771272--1-pay_method',0,14115,62771272,-1,'pay_method',null,1587221,7,6544,'0','99',2827651,'2025-09-10 09:29:11'),('62771272--1-interest_rate_tzzq',0,14115,62771272,-1,'interest_rate_tzzq',null,1587221,4,1587143,'01','03',156,'2025-09-10 09:29:11'),('62771272--1-exit_date',0,14115,62771272,-1,'exit_date',null,1587221,2291,1539440,'0216-08-25','2028-08-20',6348884,'2025-09-10 09:29:11'),('62771272--1-lease_type',0,14115,62771272,-1,'lease_type',null,1587221,6,1551634,'01','99',71174,'2025-09-10 09:29:11'),('62771272--1-corporate_id',0,14115,62771272,-1,'corporate_id',null,1587221,39,1587010,'BP00110997','BP01339433',2110,'2025-09-10 09:29:12'),('62771272--1-compensate_rule',0,14115,62771272,-1,'compensate_rule',null,1587221,1,1587221,'null','null',0,'2025-09-10 09:29:12'),('62771272--1-pricing_method',0,14115,62771272,-1,'pricing_method',null,1587221,2,1587205,'01','01',32,'2025-09-10 09:29:12'),('62771272--1-push_sink_time',0,14115,62771272,-1,'push_sink_time',null,1587221,11305,0,'2024-09-23 15:01:07','2025-09-09 08:45:08',12697768,'2025-09-10 09:29:12'),('62771272--1-finish_rule',0,14115,62771272,-1,'finish_rule',null,1587221,12150,1126310,'"关于付款周期与比例的约定： 中期计量结算时，承包人将逐期扣劳务分包人结算款作为保证金，其中：工程质量保证金 3% ，农民工工资保证金 5% 。工程质量保证金须待项目总体缺陷责任期满后，如无工程缺陷，全部无息返还；如出现工程质量缺陷，返修费用由劳务分包人承担，劳务分包人的工程质量保证金内支付，不足部分由劳务分包人另行承担。农民工工资保证金在该项工程交工�','：（1）整体封闭母线工程完工，验收达到合格后，付至已结算金额的55%；（3）工程竣工验收达到合格、完成竣工验收备案、竣工审计结束、资料及竣工验收后三个月无农民工工资争议支付至已结算金额的97%，余款3%质保期满后无息支付。具体支付周期及支付比例视分包人施工相应工程发包人计量支付款到位情况进行支付。如出现因发包人原因造成对承包人工程款拔付不及时情况，承包�',51298996,'2025-09-10 09:29:12')Error msg: errCode = 3, detailMessage = tablet 13252 alive replica num 1 < load required replica num 2, alive backends: [13029]
at org.apache.doris.statistics.AnalysisJob.writeBuf(AnalysisJob.java:135) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.markOneTaskDone(AnalysisJob.java:87) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisJob.appendBuf(AnalysisJob.java:75) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.runQuery(BaseAnalysisTask.java:311) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doSample(OlapAnalysisTask.java:178) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doExecute(OlapAnalysisTask.java:84) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.execute(BaseAnalysisTask.java:175) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisTaskWrapper.lambda$new$0(AnalysisTaskWrapper.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
at org.apache.doris.statistics.AnalysisTaskWrapper.run(AnalysisTaskWrapper.java:66) ~[doris-fe.jar:1.2-SNAPSHOT]
... 5 more
2025-09-10 09:29:13,142 INFO (Auto Analysis Job Executor-0|644) [OlapAnalysisTask.doSample():100] Number of tablets selected 72, rows in tablets 4300039
2025-09-10 09:29:13,144 INFO (Auto Analysis Job Executor-0|644) [CollectRelation.collectFromUnboundRelation():180] collect table [ods, ods_cccc_dwd_cdm_con_oppo_i_d] from QUERY
2025-09-10 09:29:13,159 INFO (Auto Analysis Job Executor-0|644) [Coordinator.execInternal():752] dispatch result sink of query ff56e8abded1418e-aed196123cb41b3d to TNetworkAddress(hostname:10.11.59.165, port:9060)
2025-09-10 09:29:13,863 INFO (Auto Analysis Job Executor-0|644) [StmtExecutor.executeInternalQuery():3224] Result rows for query ff56e8abded1418e-aed196123cb41b3d is 1
2025-09-10 09:29:13,863 INFO (Auto Analysis Job Executor-0|644) [OlapAnalysisTask.doSample():172] Sample for column [org_unit_name]. Total rows [32371062], rows to sample [4194304], scale factor [7.717862606048584], limited [true], distribute column [false], partition column [false], key column [false], is single unique key [false]
2025-09-10 09:29:13,866 INFO (Auto Analysis Job Executor-0|644) [CollectRelation.collectFromUnboundRelation():180] collect table [internal, ods, ods_cccc_dwd_cdm_con_oppo_i_d] from QUERY
2025-09-10 09:29:13,872 INFO (Auto Analysis Job Executor-0|644) [Coordinator.execInternal():752] dispatch result sink of query be1a32d48e4842ac-992779f0d1da7eb2 to TNetworkAddress(hostname:10.11.59.167, port:9060)
2025-09-10 09:29:14,774 INFO (tablet scheduler|30) [TabletSchedCtx.createCloneReplicaAndTask():1043] create clone task to repair replica, tabletId=13252, replica=[replicaId=349349170, BackendId=13028, version=-1, dataSize=-1, rowCount=-1, lastFailedVersion=518307, lastSuccessVersion=-1, lastFailedTimestamp=1757467754774, schemaHash=2019636417, state=CLONE, isBad=false], visible version 518303, tablet status REPLICA_MISSING
2025-09-10 09:29:14,774 INFO (tablet scheduler|30) [TabletScheduler.schedulePendingTablets():471] add clone task to agent task queue: tablet id: 13252, replica id: 349349170, schema hash: 2019636417, storageMedium: HDD, visible version: 518303, src backend: 10.11.59.166, src path hash: -6867905841292606838, dest backend id: 13028, dest backend: 10.11.59.165, dest path hash: -6719799705875426089
2025-09-10 09:29:14,777 WARN (thrift-server-pool-1486|36699) [MasterImpl.finishTask():97] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.11.59.165, be_port:9060, http_port:8040, brpc_port:8060, id:13028), task_type:CLONE, signature:13252, task_status:TStatus(status_code:OLAP_ERR_VERSION_ALREADY_MERGED, error_msgs:[(10.11.59.165)[OLAP_ERR_VERSION_ALREADY_MERGED]TStatus: (10.11.59.166)[E-230]missed_versions is empty, spec_version 518303, max_version 518307, tablet_id 13252]))
2025-09-10 09:29:14,950 INFO (Auto Analysis Job Executor-0|644) [StmtExecutor.executeInternalQuery():3224] Result rows for query be1a32d48e4842ac-992779f0d1da7eb2 is 1
2025-09-10 09:29:14,952 INFO (Auto Analysis Job Executor-0|644) [OlapAnalysisTask.doSample():100] Number of tablets selected 72, rows in tablets 4286595
2025-09-10 09:29:14,953 INFO (Auto Analysis Job Executor-0|644) [CollectRelation.collectFromUnboundRelation():180] collect table [ods, ods_cccc_dwd_cdm_con_oppo_i_d] from QUERY
2025-09-10 09:29:14,961 INFO (Auto Analysis Job Executor-0|644) [Coordinator.execInternal():752] dispatch result sink of query 31eb279b075f4aa5-8d26fcb42be46eae to TNetworkAddress(hostname:10.11.59.168, port:9060)
2025-09-10 09:29:15,102 INFO (Auto Analysis Job Executor-0|644) [StmtExecutor.executeInternalQuery():3224] Result rows for query 31eb279b075f4aa5-8d26fcb42be46eae is 1
2025-09-10 09:29:15,103 INFO (Auto Analysis Job Executor-0|644) [OlapAnalysisTask.doSample():172] Sample for column [authorized_card_id]. Total rows [32371062], rows to sample [4194304], scale factor [7.717862606048584], limited [true], distribute column [false], partition column [false], key column [false], is single unique key [false]
2025-09-10 09:29:15,105 INFO (Auto Analysis Job Executor-0|644) [CollectRelation.collectFromUnboundRelation():180] collect table [internal, ods, ods_cccc_dwd_cdm_con_oppo_i_d] from QUERY
尝试方法
方法1
/**
* 方法1: 按照下面的步骤操作就行
*/
SHOW tablet 13252; -- 执行返回结果中的 DetailCmd
SHOW PROC '/dbs/10002/13250/partitions/13249/13251/13252';
/* 删除损坏副本 */
ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "13252", "backend_id" = "13026", "status" = "bad");
-- 此时，再次通过 show proc 语句可以看到对应的副本的 IsBad 列值为 true。
-- 被标记为 bad 的副本不会再参与导入和查询。同时副本修复逻辑会自动补充一个新的副本。
SHOW PROC '/dbs/10002/13250/partitions/13249/13251/13252';
/* ADMIN REPAIR TABLE tbl1 修复整个表的副本 */
ADMIN REPAIR TABLE `__internal_schema`.column_statistics;
/* SHOW REPLICA STATUS FROM tbl1 查看修复进度 */
SHOW REPLICA STATUS FROM `__internal_schema`.column_statistics;
方法2
/**
* 方法2: 按照下面的方法操作
*/
SHOW tablet 13252; -- 执行返回结果中的 DetailCmd
SHOW PROC '/dbs/10002/13250/partitions/13249/13251/13252'; -- 找到 CompactionStatus 列中的内容, 分别在浏览器执行URL
/**
* detailMessage = Failed to get scan range, no queryable replica found in tablet: 13254.
* Reason: Visible Replicas:Visible version: 518303,
* Replicas: [replicaId=13255, backendId=13027, backendAlive=true, version=518303, lastFailedVersion=518304, lastSuccessVersion=518303, lastFailedTimestamp=0, state=NORMAL],
* [replicaId=13335, backendId=13030, backendAlive=true, version=518303, lastFailedVersion=518304, lastSuccessVersion=518303, lastFailedTimestamp=0, state=NORMAL].
*
* 在浏览器执行URL, 在返回结果中, 查看 rowsets, missing_rowsets 中的游标, 然后使用下面的命令进行"填充坏副本"
* 在 rowsets 找到最大的游标, 作为 start_version, lastFailedVersion 作为 end_version
*/
/**
* BE_IP: Backend节点的IP地址
* BE_HTTP_PORT: Backend的HTTP端口（默认为8040）
* tablet_id: 需要修复的tablet ID（案例中是13252）
* start_version: 起始版本号(通常使用lastSuccessVersion)
* end_version: 结束版本号(通常使用lastFailedVersion)
*/
curl -X POST "http://BE_IP:8040/api/pad_rowset?tablet_id=123456&start_version=1111111&end_version=1111112"
方法3
/**
* 方法3: 重建统计信息表
*/
-- 如果问题持续存在，可以考虑重建统计信息表：
-- 1. 禁用统计信息收集(临时)
SET GLOBAL enable_stats = false;
-- 2. 清空统计信息缓存
DROP STATS __internal_schema.column_statistics;
-- 3. 重新启用统计信息收集
SET GLOBAL enable_stats = true;
ANALYZE TABLE __internal_schema.column_statistics;
最后观察日志
-
在fe.log中还是有问题
-
还是无法查询 select * from __internal_schema.column_statistics; -- 还是报错 Failed to get scan range, no queryable replica found in tablet
