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

[PR] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   


-- 
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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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


-- 
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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41401 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 e6fe9079f69ccefb6bfcdc19f03c70fe727e515e, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17607	4331	4271	4271
   q2	2022	201	192	192
   q3	10453	1252	1174	1174
   q4	10200	777	859	777
   q5	7466	2730	2654	2654
   q6	221	138	139	138
   q7	949	634	626	626
   q8	9220	2103	2085	2085
   q9	9308	6664	6704	6664
   q10	9420	3917	3912	3912
   q11	470	248	241	241
   q12	469	233	242	233
   q13	18747	3166	3123	3123
   q14	270	213	211	211
   q15	527	487	483	483
   q16	488	404	396	396
   q17	969	621	614	614
   q18	8265	7790	7723	7723
   q19	6723	1360	1355	1355
   q20	647	328	319	319
   q21	5164	3884	4086	3884
   q22	389	326	326	326
   Total cold run time: 119994 ms
   Total hot run time: 41401 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4604	4399	4463	4399
   q2	382	279	281	279
   q3	3150	2903	2959	2903
   q4	1856	1646	1649	1646
   q5	5496	5499	5514	5499
   q6	219	138	132	132
   q7	2259	1792	1818	1792
   q8	3258	3436	3459	3436
   q9	8703	8709	8802	8709
   q10	4135	3903	3837	3837
   q11	586	510	499	499
   q12	805	602	596	596
   q13	15926	3103	3203	3103
   q14	305	274	276	274
   q15	538	488	482	482
   q16	488	437	457	437
   q17	1793	1491	1499	1491
   q18	8106	8173	8350	8173
   q19	2449	1630	1517	1517
   q20	3157	1855	1881	1855
   q21	8321	5006	4791	4791
   q22	1041	524	540	524
   Total cold run time: 77577 ms
   Total hot run time: 56374 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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 171499 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 e6fe9079f69ccefb6bfcdc19f03c70fe727e515e, data reload: false
   
   query1	925	377	377	377
   query2	6437	2433	2211	2211
   query3	6652	203	206	203
   query4	21231	17274	17244	17244
   query5	4232	444	460	444
   query6	251	155	166	155
   query7	4587	297	284	284
   query8	309	276	274	274
   query9	8558	2428	2419	2419
   query10	433	292	266	266
   query11	10314	9980	9883	9883
   query12	146	92	87	87
   query13	1640	357	370	357
   query14	10386	7829	6444	6444
   query15	284	176	186	176
   query16	8084	265	258	258
   query17	1815	513	506	506
   query18	2083	292	265	265
   query19	279	147	147	147
   query20	91	84	80	80
   query21	215	130	134	130
   query22	4106	3932	3956	3932
   query23	33926	32844	33173	32844
   query24	10601	2843	2834	2834
   query25	583	356	357	356
   query26	821	155	157	155
   query27	2201	313	315	313
   query28	5960	2052	2039	2039
   query29	860	613	588	588
   query30	277	148	147	147
   query31	975	748	718	718
   query32	91	55	57	55
   query33	767	272	306	272
   query34	980	475	471	471
   query35	758	628	624	624
   query36	1078	926	921	921
   query37	138	68	69	68
   query38	2858	2784	2743	2743
   query39	846	788	782	782
   query40	220	127	121	121
   query41	52	50	43	43
   query42	119	95	98	95
   query43	549	555	526	526
   query44	1195	709	729	709
   query45	197	164	172	164
   query46	1089	732	729	729
   query47	1823	1785	1757	1757
   query48	364	292	288	288
   query49	1067	403	403	403
   query50	780	376	388	376
   query51	6714	6713	6555	6555
   query52	106	91	93	91
   query53	353	292	287	287
   query54	859	478	443	443
   query55	71	68	70	68
   query56	275	254	254	254
   query57	1114	1013	1022	1013
   query58	261	247	241	241
   query59	3420	3364	3232	3232
   query60	304	282	294	282
   query61	98	89	86	86
   query62	664	451	446	446
   query63	321	291	290	290
   query64	8901	2211	1745	1745
   query65	3199	3098	3096	3096
   query66	823	335	324	324
   query67	15339	14683	14906	14683
   query68	4484	530	529	529
   query69	548	385	367	367
   query70	1137	1137	1140	1137
   query71	384	280	285	280
   query72	6970	5526	5813	5526
   query73	743	327	321	321
   query74	5933	5655	5543	5543
   query75	3324	2637	2667	2637
   query76	2620	916	975	916
   query77	658	288	286	286
   query78	10492	9788	9759	9759
   query79	2343	507	512	507
   query80	838	461	455	455
   query81	592	213	220	213
   query82	775	106	104	104
   query83	261	172	166	166
   query84	245	90	84	84
   query85	1457	282	298	282
   query86	480	333	325	325
   query87	3359	3186	3218	3186
   query88	4059	2494	2397	2397
   query89	489	390	402	390
   query90	1799	189	187	187
   query91	126	97	96	96
   query92	60	46	47	46
   query93	1867	504	497	497
   query94	1156	202	194	194
   query95	405	313	312	312
   query96	603	263	263	263
   query97	3187	3016	3070	3016
   query98	236	216	221	216
   query99	1216	843	857	843
   Total cold run time: 269901 ms
   Total hot run time: 171499 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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.61 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 e6fe9079f69ccefb6bfcdc19f03c70fe727e515e, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.05	0.04
   query3	0.23	0.05	0.05
   query4	1.68	0.06	0.07
   query5	0.51	0.49	0.48
   query6	1.12	0.73	0.73
   query7	0.03	0.02	0.01
   query8	0.05	0.04	0.04
   query9	0.54	0.49	0.50
   query10	0.55	0.57	0.54
   query11	0.15	0.11	0.11
   query12	0.14	0.11	0.11
   query13	0.60	0.59	0.60
   query14	0.79	0.80	0.77
   query15	0.82	0.81	0.81
   query16	0.37	0.36	0.35
   query17	0.98	0.96	1.00
   query18	0.22	0.24	0.25
   query19	1.78	1.72	1.76
   query20	0.01	0.01	0.01
   query21	15.44	0.72	0.69
   query22	4.98	7.01	1.94
   query23	18.25	1.33	1.28
   query24	1.56	0.32	0.25
   query25	0.14	0.08	0.08
   query26	0.27	0.17	0.17
   query27	0.08	0.08	0.08
   query28	13.29	1.01	0.98
   query29	13.29	3.30	3.30
   query30	0.24	0.06	0.06
   query31	2.87	0.38	0.39
   query32	3.28	0.46	0.46
   query33	2.91	2.88	2.88
   query34	17.26	4.47	4.41
   query35	4.49	4.49	4.65
   query36	0.66	0.47	0.45
   query37	0.17	0.16	0.15
   query38	0.15	0.14	0.14
   query39	0.04	0.04	0.03
   query40	0.16	0.15	0.14
   query41	0.08	0.04	0.04
   query42	0.05	0.04	0.05
   query43	0.04	0.03	0.04
   Total cold run time: 110.39 s
   Total hot run time: 30.61 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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [fix](RecycleBin) fix race condition issue when do execute ShowCatalogRecycleBinStmt [doris]

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

   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