You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "xy720 (via GitHub)" <gi...@apache.org> on 2026/01/24 18:53:24 UTC

[PR] [bug](cloud restore) Fix load failed after table restore [doris]

xy720 opened a new pull request, #60212:
URL: https://github.com/apache/doris/pull/60212

   ### What problem does this PR solve?
   
   How to reproduce:
   
   1、create a table with 3 replica and backup it to repo
   
   ```
   CREATE TABLE `test_tbl_3_replica` (
     `companyId` bigint NULL,
     `jobId` bigint NULL,
     `province` text NULL,
     `vCallerId` bigint NULL DEFAULT "0",
     `aCallerId` bigint NULL DEFAULT "-1"
   ) ENGINE=OLAP
   DUPLICATE KEY(`companyId`)
   DISTRIBUTED BY HASH(`companyId`) BUCKETS 8
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3"
   );
   ```
   
   2、set reserve_replica = true in restore command.
   
   ```
   RESTORE SNAPSHOT test.`snapshot_label` FROM `test_repo` PROPERTIES ( "backup_timestamp" = "2026-01-23-16-20-57", "reserve_replica" = "true");
   ```
   
   3、after restore finished, insert into the restored table.
   
   ```
   insert into test_tbl_3_replica values(100,100,'广东',3,3);
   Error1105:errCode=2,detailMessage=errCode=3,detailMessage=tablet1768908267608alivereplicanum1<loadrequiredreplicanum2,alivebackends:[1768462881465]
   ```
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795393168

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 30997 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 61d941c2f81066477e90df9685c5bcee80780525, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17655	4766	4586	4586
   q2	2077	301	194	194
   q3	10242	1286	704	704
   q4	10222	855	299	299
   q5	7559	2047	1826	1826
   q6	179	167	138	138
   q7	893	698	564	564
   q8	9262	1344	1085	1085
   q9	4853	4459	4588	4459
   q10	6769	1626	1223	1223
   q11	517	300	273	273
   q12	333	374	220	220
   q13	17785	3792	3115	3115
   q14	236	247	208	208
   q15	611	526	539	526
   q16	643	640	582	582
   q17	647	790	479	479
   q18	6455	6429	6574	6429
   q19	1393	1031	658	658
   q20	414	358	249	249
   q21	3013	2328	2158	2158
   q22	1164	1085	1022	1022
   Total cold run time: 102922 ms
   Total hot run time: 30997 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5007	4962	4964	4962
   q2	325	422	325	325
   q3	2372	2898	2590	2590
   q4	1391	1967	1466	1466
   q5	4692	4557	4471	4471
   q6	216	174	127	127
   q7	2147	1968	1824	1824
   q8	2509	2363	2453	2363
   q9	7270	7099	7010	7010
   q10	2449	2737	2089	2089
   q11	512	461	429	429
   q12	657	696	572	572
   q13	3322	3774	3070	3070
   q14	273	284	262	262
   q15	546	504	491	491
   q16	623	660	609	609
   q17	1123	1295	1327	1295
   q18	7213	7166	7088	7088
   q19	836	803	788	788
   q20	1901	1996	1820	1820
   q21	4430	4220	4058	4058
   q22	1060	1032	932	932
   Total cold run time: 50874 ms
   Total hot run time: 48641 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 merged PR #60212:
URL: https://github.com/apache/doris/pull/60212


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795444237

   # FE UT Coverage Report
   Increment line coverage `  0.00% (0/1)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/60212_61d941c2f81066477e90df9685c5bcee80780525/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/60212_61d941c2f81066477e90df9685c5bcee80780525/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795414609

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 26.89 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 61d941c2f81066477e90df9685c5bcee80780525, data reload: false
   
   query1	0.06	0.04	0.05
   query2	0.09	0.04	0.04
   query3	0.25	0.08	0.09
   query4	1.62	0.12	0.11
   query5	0.27	0.24	0.26
   query6	1.15	0.67	0.64
   query7	0.03	0.02	0.03
   query8	0.06	0.04	0.04
   query9	0.58	0.50	0.50
   query10	0.54	0.54	0.55
   query11	0.14	0.09	0.10
   query12	0.14	0.11	0.11
   query13	0.60	0.58	0.58
   query14	0.95	0.94	0.93
   query15	0.80	0.77	0.78
   query16	0.40	0.40	0.42
   query17	1.06	1.03	1.07
   query18	0.23	0.22	0.22
   query19	1.89	1.82	1.83
   query20	0.02	0.01	0.02
   query21	15.41	0.26	0.13
   query22	5.26	0.05	0.05
   query23	15.86	0.28	0.10
   query24	0.98	0.56	0.39
   query25	0.12	0.07	0.05
   query26	0.14	0.13	0.13
   query27	0.09	0.08	0.08
   query28	4.02	1.08	0.89
   query29	12.53	4.00	3.18
   query30	0.28	0.14	0.13
   query31	2.80	0.65	0.39
   query32	3.24	0.57	0.46
   query33	3.06	3.04	3.05
   query34	16.27	5.09	4.42
   query35	4.48	4.41	4.44
   query36	0.65	0.51	0.48
   query37	0.10	0.06	0.06
   query38	0.07	0.04	0.04
   query39	0.05	0.03	0.03
   query40	0.16	0.14	0.13
   query41	0.10	0.04	0.03
   query42	0.04	0.03	0.03
   query43	0.05	0.04	0.03
   Total cold run time: 96.64 s
   Total hot run time: 26.89 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795350569

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795407566

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 171357 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 61d941c2f81066477e90df9685c5bcee80780525, data reload: false
   
   query5	4435	617	489	489
   query6	320	208	186	186
   query7	4220	453	263	263
   query8	340	246	226	226
   query9	8708	2884	2845	2845
   query10	491	312	274	274
   query11	15170	15146	14766	14766
   query12	179	116	118	116
   query13	1286	466	379	379
   query14	6495	3009	2746	2746
   query14_1	2660	2636	2646	2636
   query15	205	193	170	170
   query16	976	485	451	451
   query17	1096	686	577	577
   query18	2661	440	339	339
   query19	199	178	151	151
   query20	138	122	114	114
   query21	221	146	120	120
   query22	3813	4138	3758	3758
   query23	16087	15427	15332	15332
   query23_1	15385	15361	15229	15229
   query24	7234	1513	1143	1143
   query24_1	1161	1173	1174	1173
   query25	535	468	426	426
   query26	1253	271	157	157
   query27	2722	446	278	278
   query28	4541	2172	2176	2172
   query29	826	525	418	418
   query30	305	225	204	204
   query31	771	616	547	547
   query32	85	75	71	71
   query33	522	330	295	295
   query34	880	877	525	525
   query35	731	767	658	658
   query36	885	885	830	830
   query37	146	99	86	86
   query38	2737	2710	2641	2641
   query39	765	756	736	736
   query39_1	694	698	716	698
   query40	221	132	115	115
   query41	66	63	64	63
   query42	90	89	94	89
   query43	459	471	412	412
   query44	1349	735	751	735
   query45	194	184	173	173
   query46	814	937	577	577
   query47	1370	1408	1421	1408
   query48	313	345	235	235
   query49	604	430	343	343
   query50	658	260	197	197
   query51	3779	3797	3761	3761
   query52	92	95	78	78
   query53	212	223	177	177
   query54	285	257	244	244
   query55	83	77	75	75
   query56	304	295	288	288
   query57	977	980	888	888
   query58	271	252	260	252
   query59	2155	2071	2146	2071
   query60	330	325	314	314
   query61	149	171	148	148
   query62	410	368	312	312
   query63	194	151	166	151
   query64	4828	1137	826	826
   query65	3754	3711	3726	3711
   query66	1394	415	316	316
   query67	15402	15506	15400	15400
   query68	2357	1046	737	737
   query69	407	313	264	264
   query70	1011	936	935	935
   query71	296	288	265	265
   query72	5243	3057	3236	3057
   query73	606	717	304	304
   query74	8649	8713	8533	8533
   query75	2247	2339	1893	1893
   query76	2293	1042	656	656
   query77	350	416	308	308
   query78	9590	9792	9003	9003
   query79	1054	948	587	587
   query80	622	508	444	444
   query81	463	261	233	233
   query82	1292	156	120	120
   query83	358	258	234	234
   query84	246	121	99	99
   query85	815	459	403	403
   query86	365	296	297	296
   query87	2874	2903	2745	2745
   query88	3513	2598	2555	2555
   query89	300	256	237	237
   query90	1867	174	163	163
   query91	176	160	129	129
   query92	72	71	65	65
   query93	1035	982	643	643
   query94	449	316	306	306
   query95	566	330	369	330
   query96	637	514	230	230
   query97	2326	2366	2327	2327
   query98	227	205	201	201
   query99	583	565	490	490
   Total cold run time: 244703 ms
   Total hot run time: 171357 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795345013

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3796042065

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3796042086

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [bug](cloud restore) Fix load failed after table restore [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60212:
URL: https://github.com/apache/doris/pull/60212#issuecomment-3795572264

   # FE Regression Coverage Report
   Increment line coverage `  0.00% (0/1)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/60212_61d941c2f81066477e90df9685c5bcee80780525_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/60212_61d941c2f81066477e90df9685c5bcee80780525_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org