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

[PR] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   ## Proposed changes
   
   When cache is not used, a new `com.aliyun.oss.ClientConfiguration` is created each time, causing OOM
   


-- 
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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41636 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 b19b13209f5b13937ba509e31a3a2fea24506d0b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17597	4134	4100	4100
   q2	2022	202	206	202
   q3	10452	1250	1375	1250
   q4	10168	830	936	830
   q5	7663	2997	2991	2991
   q6	216	137	134	134
   q7	1032	613	605	605
   q8	9432	1894	1978	1894
   q9	8564	6624	6582	6582
   q10	8787	3861	3834	3834
   q11	430	252	247	247
   q12	432	229	225	225
   q13	17760	2934	2959	2934
   q14	277	236	251	236
   q15	520	486	474	474
   q16	515	397	395	395
   q17	980	923	886	886
   q18	8149	7296	7236	7236
   q19	1469	1217	1219	1217
   q20	558	323	336	323
   q21	5352	4752	4751	4751
   q22	350	299	290	290
   Total cold run time: 112725 ms
   Total hot run time: 41636 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4039	4023	4016	4016
   q2	335	226	221	221
   q3	2975	3037	3139	3037
   q4	2031	2068	1983	1983
   q5	5615	5477	5456	5456
   q6	232	136	128	128
   q7	2111	1787	1824	1787
   q8	3343	3399	3352	3352
   q9	8726	8709	8792	8709
   q10	3965	4005	4022	4005
   q11	546	440	449	440
   q12	733	561	600	561
   q13	16404	3156	3113	3113
   q14	311	290	270	270
   q15	537	486	514	486
   q16	462	423	423	423
   q17	1761	1708	1709	1708
   q18	8283	7828	7670	7670
   q19	1976	1750	1740	1740
   q20	2066	1858	1877	1858
   q21	5694	5491	5350	5350
   q22	518	477	467	467
   Total cold run time: 72663 ms
   Total hot run time: 56780 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.86 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 5a59de963d62b2f16d01261eb044487150597d03, data reload: false
   
   query1	0.05	0.04	0.04
   query2	0.08	0.04	0.04
   query3	0.22	0.05	0.05
   query4	1.65	0.09	0.08
   query5	0.50	0.49	0.50
   query6	1.13	0.74	0.74
   query7	0.02	0.02	0.01
   query8	0.05	0.04	0.05
   query9	0.56	0.48	0.49
   query10	0.55	0.56	0.54
   query11	0.16	0.12	0.11
   query12	0.16	0.13	0.13
   query13	0.62	0.60	0.59
   query14	2.10	2.05	2.04
   query15	0.93	0.86	0.84
   query16	0.39	0.38	0.38
   query17	1.02	1.08	1.00
   query18	0.21	0.20	0.20
   query19	1.92	1.80	1.80
   query20	0.01	0.01	0.01
   query21	15.40	0.66	0.67
   query22	3.94	7.63	2.38
   query23	18.29	1.38	1.43
   query24	2.20	0.22	0.22
   query25	0.15	0.08	0.09
   query26	0.26	0.18	0.18
   query27	0.08	0.08	0.08
   query28	13.20	1.05	1.04
   query29	12.65	3.38	3.29
   query30	0.24	0.06	0.05
   query31	2.86	0.42	0.41
   query32	3.23	0.50	0.50
   query33	3.01	3.00	2.99
   query34	17.02	4.48	4.42
   query35	4.45	4.48	4.54
   query36	0.66	0.48	0.49
   query37	0.19	0.16	0.17
   query38	0.17	0.15	0.16
   query39	0.05	0.04	0.04
   query40	0.16	0.13	0.12
   query41	0.09	0.06	0.05
   query42	0.06	0.05	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 110.73 s
   Total hot run time: 32.86 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38452 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 5a59de963d62b2f16d01261eb044487150597d03, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18216	4499	4375	4375
   q2	2823	184	185	184
   q3	11725	1148	1141	1141
   q4	10736	807	765	765
   q5	7994	2918	2835	2835
   q6	234	163	139	139
   q7	961	615	605	605
   q8	9330	2082	2036	2036
   q9	7158	6556	6557	6556
   q10	7019	2200	2225	2200
   q11	473	239	247	239
   q12	406	228	228	228
   q13	18494	3045	3056	3045
   q14	293	238	229	229
   q15	525	481	494	481
   q16	585	514	499	499
   q17	991	739	680	680
   q18	7374	6917	6832	6832
   q19	1383	1016	1096	1016
   q20	675	333	338	333
   q21	4040	3212	3004	3004
   q22	1126	1030	1049	1030
   Total cold run time: 112561 ms
   Total hot run time: 38452 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4335	4296	4311	4296
   q2	377	290	274	274
   q3	2911	2648	2830	2648
   q4	1956	1667	1620	1620
   q5	5367	5438	5393	5393
   q6	220	132	132	132
   q7	2085	1741	1758	1741
   q8	3163	3340	3418	3340
   q9	8455	8455	8491	8455
   q10	3490	3216	3169	3169
   q11	604	524	500	500
   q12	773	604	598	598
   q13	12781	3093	3049	3049
   q14	329	268	281	268
   q15	535	493	480	480
   q16	598	568	564	564
   q17	1799	1490	1493	1490
   q18	7649	7475	7421	7421
   q19	1669	1596	1434	1434
   q20	2102	1812	1871	1812
   q21	5506	5360	5258	5258
   q22	1137	1060	1017	1017
   Total cold run time: 67841 ms
   Total hot run time: 54959 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   run buidall


-- 
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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.07 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 49eb0bc00abfef81badc9b7fe8d263d9b9c693c0, data reload: false
   
   query1	0.05	0.05	0.04
   query2	0.08	0.04	0.03
   query3	0.22	0.05	0.05
   query4	1.67	0.07	0.06
   query5	0.49	0.48	0.48
   query6	1.14	0.72	0.73
   query7	0.02	0.01	0.01
   query8	0.05	0.05	0.05
   query9	0.58	0.51	0.51
   query10	0.56	0.55	0.56
   query11	0.15	0.11	0.12
   query12	0.15	0.13	0.13
   query13	0.62	0.61	0.60
   query14	0.78	0.79	0.78
   query15	0.90	0.86	0.85
   query16	0.35	0.35	0.34
   query17	0.99	1.02	0.98
   query18	0.22	0.21	0.21
   query19	1.83	1.72	1.74
   query20	0.02	0.01	0.01
   query21	15.38	0.77	0.67
   query22	3.88	8.30	1.50
   query23	18.15	1.27	1.20
   query24	2.26	0.22	0.22
   query25	0.19	0.08	0.08
   query26	0.31	0.21	0.21
   query27	0.47	0.23	0.23
   query28	13.17	1.00	0.97
   query29	12.61	3.33	3.28
   query30	0.26	0.05	0.06
   query31	2.87	0.42	0.41
   query32	3.23	0.50	0.48
   query33	2.96	3.03	2.92
   query34	15.45	4.27	4.25
   query35	4.28	4.28	4.30
   query36	0.67	0.48	0.48
   query37	0.18	0.16	0.16
   query38	0.17	0.15	0.15
   query39	0.05	0.04	0.03
   query40	0.16	0.13	0.14
   query41	0.10	0.06	0.05
   query42	0.06	0.05	0.05
   query43	0.05	0.05	0.04
   Total cold run time: 107.78 s
   Total hot run time: 30.07 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.74 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 b19b13209f5b13937ba509e31a3a2fea24506d0b, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.07	0.04	0.04
   query3	0.22	0.05	0.05
   query4	1.68	0.07	0.07
   query5	0.48	0.49	0.48
   query6	1.14	0.71	0.72
   query7	0.02	0.01	0.02
   query8	0.05	0.04	0.04
   query9	0.57	0.53	0.51
   query10	0.56	0.56	0.57
   query11	0.15	0.12	0.12
   query12	0.15	0.13	0.12
   query13	0.61	0.60	0.59
   query14	0.77	0.80	0.83
   query15	0.90	0.86	0.86
   query16	0.36	0.35	0.36
   query17	1.00	0.99	1.00
   query18	0.22	0.21	0.21
   query19	1.90	1.74	1.72
   query20	0.02	0.01	0.01
   query21	15.41	0.78	0.66
   query22	4.00	7.23	2.00
   query23	18.05	1.37	1.32
   query24	2.28	0.23	0.22
   query25	0.19	0.09	0.08
   query26	0.32	0.22	0.22
   query27	0.46	0.24	0.23
   query28	13.17	1.00	0.97
   query29	12.57	3.28	3.26
   query30	0.26	0.06	0.06
   query31	2.86	0.40	0.40
   query32	3.24	0.49	0.49
   query33	2.94	2.94	3.00
   query34	15.44	4.26	4.27
   query35	4.29	4.28	4.29
   query36	0.69	0.48	0.47
   query37	0.19	0.16	0.16
   query38	0.16	0.15	0.16
   query39	0.04	0.04	0.04
   query40	0.16	0.13	0.13
   query41	0.09	0.05	0.05
   query42	0.06	0.05	0.04
   query43	0.05	0.03	0.03
   Total cold run time: 107.83 s
   Total hot run time: 30.74 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41817 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 49eb0bc00abfef81badc9b7fe8d263d9b9c693c0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17706	4176	4101	4101
   q2	2028	200	199	199
   q3	10487	1419	1360	1360
   q4	10156	822	917	822
   q5	7663	3058	3012	3012
   q6	224	137	136	136
   q7	1066	624	610	610
   q8	9442	1965	1964	1964
   q9	8518	6616	6589	6589
   q10	8713	3861	3837	3837
   q11	448	259	248	248
   q12	412	223	221	221
   q13	17765	2970	2924	2924
   q14	282	249	232	232
   q15	508	481	492	481
   q16	521	417	387	387
   q17	988	949	945	945
   q18	8346	7361	7210	7210
   q19	1374	1237	1221	1221
   q20	564	325	331	325
   q21	5397	4714	4768	4714
   q22	342	279	282	279
   Total cold run time: 112950 ms
   Total hot run time: 41817 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4077	4073	4032	4032
   q2	334	223	222	222
   q3	2982	3043	3143	3043
   q4	1989	2057	1968	1968
   q5	5680	5483	5437	5437
   q6	225	131	130	130
   q7	2147	1780	1873	1780
   q8	3333	3429	3370	3370
   q9	8702	8606	8834	8606
   q10	3954	4121	4008	4008
   q11	559	477	460	460
   q12	780	637	611	611
   q13	14305	3151	3116	3116
   q14	308	264	293	264
   q15	524	499	486	486
   q16	467	417	409	409
   q17	1784	1768	1755	1755
   q18	8403	7773	7692	7692
   q19	1778	1728	1742	1728
   q20	2051	1810	1839	1810
   q21	5709	5380	5376	5376
   q22	528	463	465	463
   Total cold run time: 70619 ms
   Total hot run time: 56766 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 189205 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 5a59de963d62b2f16d01261eb044487150597d03, data reload: false
   
   query1	925	378	366	366
   query2	6452	2007	1944	1944
   query3	6666	211	209	209
   query4	33701	23413	23387	23387
   query5	4180	511	482	482
   query6	249	166	158	158
   query7	4584	297	291	291
   query8	266	215	223	215
   query9	8599	2517	2501	2501
   query10	450	272	275	272
   query11	15884	15264	15084	15084
   query12	155	122	100	100
   query13	1641	385	370	370
   query14	9547	7387	7328	7328
   query15	300	173	169	169
   query16	7827	458	477	458
   query17	1633	550	543	543
   query18	2062	285	302	285
   query19	333	144	142	142
   query20	117	115	111	111
   query21	205	102	104	102
   query22	4446	4237	4180	4180
   query23	34402	33628	33162	33162
   query24	11047	2909	2914	2909
   query25	627	388	378	378
   query26	1162	158	156	156
   query27	2748	304	287	287
   query28	7432	2148	2161	2148
   query29	860	447	449	447
   query30	299	167	168	167
   query31	1022	787	807	787
   query32	103	64	63	63
   query33	761	315	307	307
   query34	931	512	506	506
   query35	855	754	774	754
   query36	1129	1007	958	958
   query37	162	96	91	91
   query38	4029	3842	3840	3840
   query39	1458	1413	1409	1409
   query40	207	122	117	117
   query41	48	47	51	47
   query42	117	96	98	96
   query43	528	463	477	463
   query44	1333	764	760	760
   query45	197	167	175	167
   query46	1116	733	732	732
   query47	1847	1773	1769	1769
   query48	390	302	298	298
   query49	1033	426	428	426
   query50	836	408	409	408
   query51	7191	6998	7109	6998
   query52	101	86	89	86
   query53	249	183	188	183
   query54	1064	460	496	460
   query55	76	79	79	79
   query56	321	266	252	252
   query57	1189	1079	1094	1079
   query58	240	236	228	228
   query59	3016	2854	2794	2794
   query60	303	273	271	271
   query61	106	100	99	99
   query62	827	657	678	657
   query63	221	186	178	178
   query64	5319	679	644	644
   query65	3251	3176	3320	3176
   query66	1417	341	342	341
   query67	15698	15187	15519	15187
   query68	3499	580	574	574
   query69	402	274	278	274
   query70	1153	1143	1026	1026
   query71	332	272	268	268
   query72	6385	4008	4222	4008
   query73	737	330	336	330
   query74	9167	8898	8902	8898
   query75	3481	2692	2656	2656
   query76	1897	995	984	984
   query77	498	307	332	307
   query78	11009	9468	9406	9406
   query79	1026	545	530	530
   query80	685	510	513	510
   query81	493	240	230	230
   query82	251	160	143	143
   query83	171	152	151	151
   query84	226	78	79	78
   query85	723	300	285	285
   query86	307	302	296	296
   query87	4411	4236	4317	4236
   query88	3184	2370	2355	2355
   query89	381	293	291	291
   query90	1932	199	194	194
   query91	127	104	102	102
   query92	62	56	58	56
   query93	1038	549	544	544
   query94	825	315	305	305
   query95	377	345	261	261
   query96	600	268	274	268
   query97	3253	3098	3149	3098
   query98	218	207	201	201
   query99	1485	1294	1279	1279
   Total cold run time: 287825 ms
   Total hot run time: 189205 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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


-- 
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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 168796 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 49eb0bc00abfef81badc9b7fe8d263d9b9c693c0, data reload: false
   
   query1	913	382	374	374
   query2	6466	1668	1656	1656
   query3	6681	211	228	211
   query4	20261	17354	17339	17339
   query5	3613	502	516	502
   query6	264	173	167	167
   query7	4596	293	290	290
   query8	246	195	194	194
   query9	8526	2364	2346	2346
   query10	427	278	266	266
   query11	10494	9885	10028	9885
   query12	122	93	90	90
   query13	1637	384	388	384
   query14	9198	7620	6366	6366
   query15	217	171	170	170
   query16	6962	474	433	433
   query17	964	594	555	555
   query18	1928	294	291	291
   query19	195	150	151	150
   query20	90	86	87	86
   query21	205	100	99	99
   query22	4288	4050	4175	4050
   query23	33946	33880	33577	33577
   query24	10385	3126	3049	3049
   query25	682	406	399	399
   query26	1744	152	167	152
   query27	3067	291	293	291
   query28	7542	2023	2004	2004
   query29	1275	465	431	431
   query30	238	154	158	154
   query31	987	784	750	750
   query32	100	57	54	54
   query33	690	326	333	326
   query34	960	485	513	485
   query35	860	751	753	751
   query36	1053	894	880	880
   query37	293	85	86	85
   query38	2964	2792	2776	2776
   query39	874	818	794	794
   query40	242	111	107	107
   query41	46	47	48	47
   query42	116	96	98	96
   query43	467	436	421	421
   query44	1192	731	737	731
   query45	209	177	181	177
   query46	1086	834	810	810
   query47	1796	1715	1708	1708
   query48	364	291	299	291
   query49	935	414	425	414
   query50	925	426	428	426
   query51	6834	6677	6698	6677
   query52	101	88	92	88
   query53	255	183	181	181
   query54	647	448	458	448
   query55	77	74	78	74
   query56	277	249	245	245
   query57	1139	1054	1030	1030
   query58	287	264	254	254
   query59	2627	2543	2289	2289
   query60	302	277	264	264
   query61	97	98	93	93
   query62	898	652	651	651
   query63	214	181	178	178
   query64	5682	1901	1859	1859
   query65	3142	3110	3096	3096
   query66	1302	331	355	331
   query67	15417	14855	14724	14724
   query68	4358	578	587	578
   query69	454	296	295	295
   query70	1114	1083	1047	1047
   query71	419	287	278	278
   query72	7079	2682	2532	2532
   query73	779	329	328	328
   query74	6037	5666	5707	5666
   query75	3408	2712	2713	2712
   query76	2283	1220	1284	1220
   query77	418	301	306	301
   query78	9486	9017	8906	8906
   query79	1590	559	535	535
   query80	1122	495	506	495
   query81	560	225	228	225
   query82	1037	131	131	131
   query83	234	167	165	165
   query84	259	77	79	77
   query85	1200	309	304	304
   query86	411	305	290	290
   query87	3269	3116	3077	3077
   query88	3025	2517	2502	2502
   query89	378	291	288	288
   query90	1771	191	187	187
   query91	126	103	100	100
   query92	61	48	50	48
   query93	1433	610	617	610
   query94	851	283	290	283
   query95	377	260	264	260
   query96	604	291	288	288
   query97	3243	3131	3026	3026
   query98	210	203	207	203
   query99	1665	1267	1267	1267
   Total cold run time: 261890 ms
   Total hot run time: 168796 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] [bugfix](paimon)Use the fs cache, otherwise it will cause OOM [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 170510 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 b19b13209f5b13937ba509e31a3a2fea24506d0b, data reload: false
   
   query1	913	368	372	368
   query2	6437	1797	1767	1767
   query3	6654	214	223	214
   query4	20051	17398	17061	17061
   query5	3729	509	536	509
   query6	303	179	166	166
   query7	4604	298	301	298
   query8	259	207	207	207
   query9	8554	2372	2356	2356
   query10	434	299	286	286
   query11	10433	10143	9962	9962
   query12	123	87	91	87
   query13	1636	384	380	380
   query14	9556	7533	8332	7533
   query15	199	165	169	165
   query16	6830	456	456	456
   query17	959	560	557	557
   query18	1917	293	281	281
   query19	193	150	147	147
   query20	95	89	90	89
   query21	209	103	97	97
   query22	4176	4051	4166	4051
   query23	34100	33564	33582	33564
   query24	9364	3072	3137	3072
   query25	676	462	447	447
   query26	1391	181	159	159
   query27	3007	289	284	284
   query28	7624	2049	2035	2035
   query29	1036	474	445	445
   query30	249	171	157	157
   query31	959	784	801	784
   query32	105	62	62	62
   query33	733	324	345	324
   query34	916	487	500	487
   query35	875	751	755	751
   query36	1037	932	878	878
   query37	236	77	83	77
   query38	2908	2797	2794	2794
   query39	881	803	811	803
   query40	292	112	113	112
   query41	48	44	47	44
   query42	120	101	99	99
   query43	486	427	429	427
   query44	1190	730	748	730
   query45	205	182	180	180
   query46	1079	802	783	783
   query47	1810	1739	1744	1739
   query48	370	296	290	290
   query49	1029	420	420	420
   query50	897	423	417	417
   query51	6816	6733	6690	6690
   query52	105	89	93	89
   query53	251	182	180	180
   query54	635	455	457	455
   query55	76	76	72	72
   query56	261	265	246	246
   query57	1136	1050	1030	1030
   query58	269	252	275	252
   query59	2549	2361	2373	2361
   query60	288	275	265	265
   query61	97	106	93	93
   query62	899	695	661	661
   query63	212	187	185	185
   query64	4837	1892	1896	1892
   query65	3152	3092	3063	3063
   query66	995	333	333	333
   query67	15376	14915	14906	14906
   query68	6237	576	599	576
   query69	742	380	309	309
   query70	1149	1077	1083	1077
   query71	535	274	272	272
   query72	8191	2663	2458	2458
   query73	965	327	325	325
   query74	6017	5620	5677	5620
   query75	4400	2771	2752	2752
   query76	4397	1374	1403	1374
   query77	764	310	299	299
   query78	9592	9021	8969	8969
   query79	2763	520	529	520
   query80	1928	503	497	497
   query81	570	222	224	222
   query82	767	131	126	126
   query83	280	176	169	169
   query84	272	80	76	76
   query85	1367	352	306	306
   query86	441	300	303	300
   query87	3269	3110	3102	3102
   query88	3608	2386	2399	2386
   query89	399	285	292	285
   query90	1976	184	188	184
   query91	127	102	98	98
   query92	65	50	48	48
   query93	2963	617	614	614
   query94	910	284	294	284
   query95	382	263	262	262
   query96	601	281	276	276
   query97	3190	3050	3053	3050
   query98	233	204	198	198
   query99	1589	1302	1311	1302
   Total cold run time: 270530 ms
   Total hot run time: 170510 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