Skip to content

[Fix](hive-writer) Fix s3 file commiter not working. - #35502

Merged
morningman merged 1 commit into
apache:masterfrom
kaka11chen:fix_s3_committer
May 29, 2024
Merged

morningman merged 1 commit into
apache:masterfrom
kaka11chen:fix_s3_committer

Conversation

@kaka11chen

Copy link
Copy Markdown
Contributor

Proposed changes

Issue

The specified upload does not exist. The upload ID may be invalid, or the upload may have been aborted or completed. (Service: S3, Status Code: 404, Request ID: 66557027E897233333FFC198)

Root cause

#35311 adjusted the order of building hive partition update information. This change caused the update id to be unable to be obtained, causing the s3 file committer to not work properly.

Solution

Because uploading to s3 occurs after s3 file writer close(), close() must be called first, and then the build hive partiton update information is called.

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

@doris-robot

Copy link
Copy Markdown

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website.
See Doris Document.

@kaka11chen

Copy link
Copy Markdown
Contributor Author

run buildall

@github-actions

Copy link
Copy Markdown
Contributor

clang-tidy review says "All clean, LGTM! 👍"

@morningman morningman left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@github-actions github-actions Bot added the approved Indicates a PR has been approved by one committer. label May 28, 2024
@github-actions

Copy link
Copy Markdown
Contributor

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

@github-actions

Copy link
Copy Markdown
Contributor

PR approved by anyone and no changes requested.

@morningman

Copy link
Copy Markdown
Contributor

run buildall

@github-actions

Copy link
Copy Markdown
Contributor

clang-tidy review says "All clean, LGTM! 👍"

@doris-robot

Copy link
Copy Markdown
TPC-H: Total hot run time: 41380 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit d43df719ca77b429aac69f14ebe5dbd89c269bc1, data reload: false

------ Round 1 ----------------------------------
q1	17677	4429	4299	4299
q2	2033	201	196	196
q3	10516	1336	1258	1258
q4	10227	786	806	786
q5	7477	2698	2755	2698
q6	237	128	133	128
q7	958	618	605	605
q8	9218	2175	2101	2101
q9	9504	6700	6791	6700
q10	9647	3902	3924	3902
q11	440	240	239	239
q12	511	230	224	224
q13	17544	3140	3189	3140
q14	257	227	223	223
q15	525	482	501	482
q16	519	399	417	399
q17	995	804	708	708
q18	8464	7836	7808	7808
q19	6126	1591	1558	1558
q20	666	327	328	327
q21	5192	3327	4195	3327
q22	345	281	272	272
Total cold run time: 119078 ms
Total hot run time: 41380 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4522	4387	4408	4387
q2	373	274	268	268
q3	3168	2941	2949	2941
q4	1935	1578	1611	1578
q5	5421	5529	5527	5527
q6	221	125	124	124
q7	2151	1788	1812	1788
q8	3206	3408	3385	3385
q9	8574	8749	8713	8713
q10	4069	3661	3741	3661
q11	624	488	510	488
q12	801	599	641	599
q13	17124	3159	3156	3156
q14	293	270	274	270
q15	541	487	497	487
q16	511	440	431	431
q17	1840	1549	1507	1507
q18	7668	7608	7466	7466
q19	1663	1565	1518	1518
q20	2008	1794	1763	1763
q21	9744	4710	4626	4626
q22	576	481	478	478
Total cold run time: 77033 ms
Total hot run time: 55161 ms

@doris-robot

Copy link
Copy Markdown
TPC-DS: Total hot run time: 172652 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit d43df719ca77b429aac69f14ebe5dbd89c269bc1, data reload: false

query1	921	377	373	373
query2	6433	2541	2359	2359
query3	6652	205	205	205
query4	19219	17502	17396	17396
query5	4232	429	415	415
query6	242	167	150	150
query7	4581	295	287	287
query8	245	184	183	183
query9	8511	2445	2427	2427
query10	446	290	262	262
query11	10741	10192	10184	10184
query12	132	92	86	86
query13	1656	366	374	366
query14	10108	7736	6758	6758
query15	273	168	166	166
query16	8084	267	297	267
query17	1669	514	503	503
query18	2064	273	277	273
query19	204	165	156	156
query20	93	86	87	86
query21	196	133	133	133
query22	4615	4127	4134	4127
query23	33612	33048	33139	33048
query24	7903	2825	2759	2759
query25	553	341	380	341
query26	693	156	158	156
query27	2174	322	323	322
query28	5400	2102	2089	2089
query29	861	605	591	591
query30	221	153	151	151
query31	960	765	735	735
query32	90	53	53	53
query33	571	265	255	255
query34	884	470	478	470
query35	691	613	591	591
query36	1063	920	900	900
query37	102	65	66	65
query38	2869	2800	2794	2794
query39	844	783	798	783
query40	204	124	124	124
query41	48	45	47	45
query42	100	96	94	94
query43	612	569	539	539
query44	1090	732	744	732
query45	178	158	164	158
query46	1071	694	727	694
query47	1864	1771	1795	1771
query48	367	297	300	297
query49	832	382	381	381
query50	769	393	394	393
query51	6910	6772	6727	6727
query52	101	91	88	88
query53	375	295	299	295
query54	583	443	435	435
query55	72	72	71	71
query56	260	239	246	239
query57	1149	1033	1041	1033
query58	232	212	209	209
query59	3425	3185	3186	3185
query60	273	270	262	262
query61	88	86	88	86
query62	608	458	445	445
query63	308	277	291	277
query64	8542	2220	1715	1715
query65	3185	3090	3105	3090
query66	766	329	328	328
query67	14992	14830	14813	14813
query68	4526	561	558	558
query69	449	267	272	267
query70	1140	1129	1075	1075
query71	371	270	265	265
query72	7452	5753	5351	5351
query73	723	333	324	324
query74	6184	5710	5650	5650
query75	3313	2583	2634	2583
query76	2395	1014	981	981
query77	444	264	270	264
query78	10343	9933	9811	9811
query79	1582	513	504	504
query80	1085	444	422	422
query81	540	225	216	216
query82	952	95	87	87
query83	239	170	174	170
query84	255	88	86	86
query85	1117	272	330	272
query86	365	322	323	322
query87	3375	3167	3116	3116
query88	3123	2464	2513	2464
query89	474	410	384	384
query90	1941	191	179	179
query91	124	98	104	98
query92	59	50	50	50
query93	1107	526	506	506
query94	1188	185	186	185
query95	408	312	315	312
query96	634	271	277	271
query97	3207	3018	3028	3018
query98	240	223	213	213
query99	1188	868	857	857
Total cold run time: 260355 ms
Total hot run time: 172652 ms

@doris-robot

Copy link
Copy Markdown

TeamCity be ut coverage result:
Function Coverage: 35.77% (9005/25173)
Line Coverage: 27.40% (74569/272170)
Region Coverage: 26.62% (38580/144929)
Branch Coverage: 23.48% (19674/83784)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d43df719ca77b429aac69f14ebe5dbd89c269bc1_d43df719ca77b429aac69f14ebe5dbd89c269bc1/report/index.html

@doris-robot

Copy link
Copy Markdown
ClickBench: Total hot run time: 30.37 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d43df719ca77b429aac69f14ebe5dbd89c269bc1, data reload: false

query1	0.04	0.03	0.03
query2	0.09	0.04	0.04
query3	0.23	0.05	0.04
query4	1.68	0.06	0.06
query5	0.51	0.47	0.49
query6	1.13	0.72	0.72
query7	0.02	0.02	0.01
query8	0.05	0.04	0.04
query9	0.54	0.47	0.47
query10	0.54	0.54	0.54
query11	0.16	0.12	0.12
query12	0.15	0.12	0.12
query13	0.60	0.59	0.60
query14	0.76	0.78	0.79
query15	0.82	0.81	0.81
query16	0.38	0.37	0.36
query17	0.95	1.04	0.99
query18	0.22	0.25	0.25
query19	1.81	1.76	1.69
query20	0.02	0.01	0.01
query21	15.43	0.70	0.68
query22	4.69	7.02	1.85
query23	18.33	1.30	1.24
query24	1.98	0.25	0.19
query25	0.15	0.10	0.08
query26	0.25	0.16	0.16
query27	0.08	0.08	0.07
query28	13.23	1.02	0.99
query29	13.27	3.30	3.27
query30	0.24	0.06	0.06
query31	2.87	0.37	0.38
query32	3.31	0.47	0.48
query33	2.89	2.89	2.90
query34	17.19	4.50	4.42
query35	4.51	4.44	4.57
query36	0.65	0.47	0.46
query37	0.18	0.15	0.15
query38	0.16	0.15	0.14
query39	0.04	0.04	0.04
query40	0.17	0.14	0.15
query41	0.08	0.04	0.05
query42	0.06	0.05	0.04
query43	0.04	0.04	0.04
Total cold run time: 110.5 s
Total hot run time: 30.37 s

@morningman
morningman merged commit 961ccf1 into apache:master May 29, 2024
morningman pushed a commit to morningman/doris that referenced this pull request May 29, 2024
### Issue
`The specified upload does not exist. The upload ID may be invalid, or
the upload may have been aborted or completed. (Service: S3, Status
Code: 404, Request ID: 66557027E897233333FFC198)`

### Root cause
apache#35311 adjusted the order of building hive partition update information.
This change caused the update id to be unable to be obtained, causing
the s3 file committer to not work properly.

### Solution
Because uploading to s3 occurs after s3 file writer close(), close()
must be called first, and then the build hive partiton update
information is called.
morningman added a commit that referenced this pull request May 29, 2024
dataroaring pushed a commit that referenced this pull request May 31, 2024
### Issue
`The specified upload does not exist. The upload ID may be invalid, or
the upload may have been aborted or completed. (Service: S3, Status
Code: 404, Request ID: 66557027E897233333FFC198)`

### Root cause
#35311 adjusted the order of building hive partition update information.
This change caused the update id to be unable to be obtained, causing
the s3 file committer to not work properly.

### Solution
Because uploading to s3 occurs after s3 file writer close(), close()
must be called first, and then the build hive partiton update
information is called.
HappenLee pushed a commit to HappenLee/incubator-doris that referenced this pull request Apr 24, 2026
### Issue
`The specified upload does not exist. The upload ID may be invalid, or
the upload may have been aborted or completed. (Service: S3, Status
Code: 404, Request ID: 66557027E897233333FFC198)`

### Root cause
apache#35311 adjusted the order of building hive partition update information.
This change caused the update id to be unable to be obtained, causing
the s3 file committer to not work properly.

### Solution
Because uploading to s3 occurs after s3 file writer close(), close()
must be called first, and then the build hive partiton update
information is called.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

approved Indicates a PR has been approved by one committer. dev/2.1.4-merged dev/3.0.0-merged reviewed

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants