[fix](compaction) fix compaction producer hold for permits leak

[qzsee]

What problem does this PR solve?

compaction producer hold

compaction threads is free

so judge permits has alread leak

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

• Test

  • 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

• Behavior changed:

  • No.
  • Yes.

• Does this need documentation?

  • No.
  • Yes.

Check List (For Reviewer who merge this PR)

• Confirm the release note
• Confirm test cases
• Confirm document
• Add branch pick label

[hello-stephen]

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See 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?

[TangSiyang2001]

LGTM

[github-actions]

PR approved by anyone and no changes requested.

[TangSiyang2001]

run buildall

[dqz123]

run buildall

[doris-robot]

TPC-H: Total hot run time: 39698 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit c8f3a060048f536c339b6910422e8e59e4978fd8, data reload: false

------ Round 1 ----------------------------------
q1	17581	7438	7252	7252
q2	2043	188	162	162
q3	10607	1067	1186	1067
q4	10577	753	750	750
q5	7614	2685	2666	2666
q6	243	147	145	145
q7	979	657	597	597
q8	9603	1865	1939	1865
q9	6664	6457	6476	6457
q10	7068	2294	2307	2294
q11	473	255	252	252
q12	435	217	219	217
q13	17781	2939	2953	2939
q14	264	215	218	215
q15	558	517	494	494
q16	664	583	582	582
q17	978	499	556	499
q18	7257	6683	6601	6601
q19	1347	1041	1055	1041
q20	488	182	182	182
q21	3979	3111	3176	3111
q22	375	310	317	310
Total cold run time: 107578 ms
Total hot run time: 39698 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7226	7221	7210	7210
q2	330	227	231	227
q3	2881	2819	2902	2819
q4	2032	1781	1841	1781
q5	5680	5656	5646	5646
q6	226	147	146	146
q7	2269	1788	1809	1788
q8	3394	3531	3467	3467
q9	8857	8963	8992	8963
q10	3547	3517	3511	3511
q11	604	491	522	491
q12	828	589	573	573
q13	12961	3056	3152	3056
q14	305	283	274	274
q15	563	509	514	509
q16	688	633	641	633
q17	1837	1618	1609	1609
q18	8260	7873	7700	7700
q19	1769	1450	1540	1450
q20	2102	1864	1862	1862
q21	5542	5415	5447	5415
q22	654	577	585	577
Total cold run time: 72555 ms
Total hot run time: 59707 ms

[doris-robot]

TPC-DS: Total hot run time: 195864 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 c8f3a060048f536c339b6910422e8e59e4978fd8, data reload: false

query1	1283	979	930	930
query2	6242	2339	2379	2339
query3	10980	4557	4438	4438
query4	33400	23380	23387	23380
query5	4223	465	453	453
query6	282	191	185	185
query7	3993	301	308	301
query8	301	235	239	235
query9	9556	2745	2708	2708
query10	453	250	247	247
query11	18003	15097	15189	15097
query12	160	104	107	104
query13	1564	427	451	427
query14	8648	7041	7593	7041
query15	287	206	197	197
query16	8254	438	437	437
query17	1769	633	587	587
query18	2207	322	327	322
query19	385	175	164	164
query20	123	115	113	113
query21	218	109	113	109
query22	4761	4476	4365	4365
query23	34733	33715	33684	33684
query24	10381	2491	2512	2491
query25	620	403	400	400
query26	1228	158	159	158
query27	2401	354	353	353
query28	7725	2494	2444	2444
query29	843	412	423	412
query30	229	153	180	153
query31	1044	853	842	842
query32	90	56	56	56
query33	765	296	287	287
query34	1162	558	540	540
query35	909	754	759	754
query36	1117	934	947	934
query37	147	76	79	76
query38	4295	4084	4368	4084
query39	1480	1643	1451	1451
query40	208	103	100	100
query41	45	42	45	42
query42	113	101	110	101
query43	541	485	514	485
query44	1269	836	825	825
query45	194	169	167	167
query46	1162	726	717	717
query47	2055	1901	1894	1894
query48	416	330	329	329
query49	923	387	408	387
query50	830	407	385	385
query51	7431	7291	7177	7177
query52	100	91	93	91
query53	261	182	178	178
query54	1106	411	454	411
query55	88	83	78	78
query56	287	237	247	237
query57	1295	1183	1167	1167
query58	234	220	227	220
query59	3288	3053	3070	3053
query60	277	267	268	267
query61	113	106	106	106
query62	907	698	699	698
query63	220	185	188	185
query64	4094	718	650	650
query65	3254	3264	3274	3264
query66	822	309	298	298
query67	16602	15512	15542	15512
query68	5633	542	538	538
query69	504	265	243	243
query70	1198	1115	1122	1115
query71	474	252	249	249
query72	6939	4103	4082	4082
query73	802	359	361	359
query74	10202	8796	8876	8796
query75	3639	2756	2704	2704
query76	3736	1077	1076	1076
query77	606	273	273	273
query78	10153	9364	9444	9364
query79	1972	593	601	593
query80	1288	432	428	428
query81	511	241	231	231
query82	262	120	127	120
query83	200	155	139	139
query84	286	67	71	67
query85	1019	318	296	296
query86	383	306	303	303
query87	4430	4625	4270	4270
query88	4172	2209	2200	2200
query89	444	289	287	287
query90	2168	186	189	186
query91	138	106	102	102
query92	66	48	50	48
query93	4711	545	535	535
query94	917	286	285	285
query95	354	247	250	247
query96	665	279	281	279
query97	2840	2617	2643	2617
query98	217	197	201	197
query99	1608	1313	1324	1313
Total cold run time: 306933 ms
Total hot run time: 195864 ms

[doris-robot]

ClickBench: Total hot run time: 32.92 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c8f3a060048f536c339b6910422e8e59e4978fd8, data reload: false

query1	0.03	0.03	0.04
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.61	0.10	0.12
query5	0.44	0.41	0.39
query6	1.38	0.67	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.60	0.50	0.52
query10	0.55	0.55	0.55
query11	0.13	0.10	0.10
query12	0.14	0.11	0.10
query13	0.60	0.60	0.60
query14	2.72	2.73	2.87
query15	0.89	0.84	0.83
query16	0.38	0.39	0.39
query17	1.06	1.06	0.98
query18	0.23	0.20	0.21
query19	1.85	1.87	2.02
query20	0.01	0.01	0.02
query21	15.37	0.58	0.60
query22	2.60	2.69	2.01
query23	16.95	0.95	0.77
query24	2.65	1.02	1.76
query25	0.19	0.27	0.10
query26	0.42	0.14	0.15
query27	0.04	0.04	0.05
query28	10.38	1.13	1.06
query29	12.68	3.26	3.30
query30	0.25	0.07	0.06
query31	2.86	0.38	0.38
query32	3.25	0.47	0.45
query33	3.08	3.21	3.18
query34	17.16	4.47	4.47
query35	4.42	4.47	4.45
query36	0.68	0.49	0.51
query37	0.10	0.06	0.05
query38	0.04	0.03	0.04
query39	0.03	0.02	0.02
query40	0.16	0.12	0.12
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.45 s
Total hot run time: 32.92 s

[doris-robot]

TeamCity be ut coverage result:
Function Coverage: 38.90% (10138/26063)
Line Coverage: 29.82% (85304/286101)
Region Coverage: 28.94% (43557/150489)
Branch Coverage: 25.45% (22176/87146)
Coverage Report: http://coverage.selectdb-in.cc/coverage/c8f3a060048f536c339b6910422e8e59e4978fd8_c8f3a060048f536c339b6910422e8e59e4978fd8/report/index.html

[TangSiyang2001]

LGTM

[dqz123]

run p0

[cambyzju]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33043 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 48895c6528c7eda04245b88a609e3422365e6818, data reload: false

------ Round 1 ----------------------------------
q1	17609	6233	6079	6079
q2	2047	305	160	160
q3	10418	1272	708	708
q4	10195	851	425	425
q5	7515	2217	2022	2022
q6	207	181	146	146
q7	881	753	616	616
q8	9240	1434	1240	1240
q9	5466	4962	4998	4962
q10	6751	2327	1842	1842
q11	471	272	258	258
q12	344	353	223	223
q13	17772	3676	3016	3016
q14	245	245	216	216
q15	559	517	498	498
q16	655	607	592	592
q17	571	875	324	324
q18	7010	6594	6641	6594
q19	1243	971	586	586
q20	312	327	197	197
q21	2927	2171	2023	2023
q22	355	334	316	316
Total cold run time: 102793 ms
Total hot run time: 33043 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6269	6253	6262	6253
q2	238	322	232	232
q3	2252	2628	2322	2322
q4	1441	1853	1373	1373
q5	4400	4809	4895	4809
q6	196	183	143	143
q7	2076	1988	1865	1865
q8	2606	2775	2718	2718
q9	7347	7157	7300	7157
q10	3029	3320	2851	2851
q11	599	512	499	499
q12	658	761	604	604
q13	3512	3899	3249	3249
q14	279	304	289	289
q15	586	575	507	507
q16	640	687	654	654
q17	1245	1731	1242	1242
q18	7756	7459	7217	7217
q19	861	1169	1092	1092
q20	1991	2049	1921	1921
q21	5675	5110	4941	4941
q22	616	582	581	581
Total cold run time: 54272 ms
Total hot run time: 52519 ms

[doris-robot]

TPC-DS: Total hot run time: 190671 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 48895c6528c7eda04245b88a609e3422365e6818, data reload: false

query1	975	376	370	370
query2	6536	2427	2297	2297
query3	6704	212	211	211
query4	34228	23638	23438	23438
query5	4300	619	443	443
query6	292	204	185	185
query7	4622	488	306	306
query8	313	269	235	235
query9	9471	2750	2751	2750
query10	475	313	252	252
query11	18666	15704	15197	15197
query12	159	109	105	105
query13	1668	533	410	410
query14	11689	7511	7137	7137
query15	256	196	197	196
query16	7690	608	441	441
query17	1621	768	577	577
query18	1236	394	296	296
query19	230	176	153	153
query20	115	114	111	111
query21	206	126	104	104
query22	4662	4763	4485	4485
query23	34460	33595	33536	33536
query24	6219	2308	2261	2261
query25	484	443	380	380
query26	766	269	151	151
query27	2001	459	339	339
query28	5363	2476	2448	2448
query29	526	528	411	411
query30	227	183	157	157
query31	1010	880	817	817
query32	75	83	58	58
query33	496	342	292	292
query34	761	842	513	513
query35	799	829	725	725
query36	1024	1050	969	969
query37	112	96	78	78
query38	4281	4168	4026	4026
query39	1457	1463	1428	1428
query40	202	113	97	97
query41	47	43	45	43
query42	128	103	103	103
query43	502	512	473	473
query44	1324	803	788	788
query45	174	168	163	163
query46	871	1037	637	637
query47	1936	1950	1917	1917
query48	376	396	326	326
query49	735	471	388	388
query50	636	658	378	378
query51	6984	6844	6778	6778
query52	100	99	96	96
query53	218	257	186	186
query54	483	480	405	405
query55	83	77	79	77
query56	257	307	235	235
query57	1190	1217	1149	1149
query58	237	233	235	233
query59	2957	3155	2994	2994
query60	288	264	249	249
query61	117	111	107	107
query62	910	807	743	743
query63	227	192	201	192
query64	3193	1003	650	650
query65	3324	3227	3238	3227
query66	865	417	305	305
query67	16048	15969	15562	15562
query68	7302	689	498	498
query69	469	290	252	252
query70	1212	1141	1108	1108
query71	449	290	251	251
query72	5803	3816	3899	3816
query73	644	760	358	358
query74	9768	9185	9188	9185
query75	3880	3152	2659	2659
query76	3652	1187	765	765
query77	761	354	273	273
query78	10166	10182	9541	9541
query79	3773	792	577	577
query80	745	509	436	436
query81	483	280	225	225
query82	620	149	125	125
query83	199	165	147	147
query84	284	95	77	77
query85	785	375	310	310
query86	364	318	313	313
query87	4570	4616	4300	4300
query88	4338	2248	2210	2210
query89	415	336	294	294
query90	1942	189	189	189
query91	137	135	109	109
query92	65	54	54	54
query93	1486	856	513	513
query94	656	403	285	285
query95	337	259	251	251
query96	492	615	291	291
query97	2942	2999	2876	2876
query98	234	205	198	198
query99	1682	1578	1396	1396
Total cold run time: 291242 ms
Total hot run time: 190671 ms

[doris-robot]

ClickBench: Total hot run time: 31.52 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 48895c6528c7eda04245b88a609e3422365e6818, data reload: false

query1	0.04	0.04	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.60	0.11	0.11
query5	0.42	0.44	0.41
query6	1.15	0.66	0.65
query7	0.03	0.02	0.02
query8	0.04	0.03	0.04
query9	0.59	0.50	0.51
query10	0.57	0.58	0.54
query11	0.15	0.11	0.10
query12	0.13	0.11	0.11
query13	0.61	0.60	0.59
query14	2.73	2.73	2.79
query15	0.89	0.81	0.82
query16	0.37	0.39	0.38
query17	1.03	1.07	1.06
query18	0.24	0.20	0.22
query19	1.96	1.91	1.94
query20	0.01	0.00	0.01
query21	15.36	1.00	0.58
query22	0.74	0.79	0.66
query23	15.34	1.41	0.60
query24	3.07	0.98	1.68
query25	0.24	0.07	0.22
query26	0.26	0.14	0.15
query27	0.05	0.05	0.05
query28	13.91	1.49	1.06
query29	12.57	3.95	3.28
query30	0.24	0.09	0.06
query31	2.82	0.57	0.38
query32	3.22	0.53	0.45
query33	3.06	3.10	3.12
query34	16.90	5.18	4.52
query35	4.54	4.53	4.54
query36	0.84	0.49	0.48
query37	0.09	0.06	0.06
query38	0.04	0.03	0.04
query39	0.04	0.02	0.03
query40	0.18	0.13	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.53 s
Total hot run time: 31.52 s

[doris-robot]

TeamCity be ut coverage result:
Function Coverage: 38.89% (10135/26063)
Line Coverage: 29.92% (85744/286545)
Region Coverage: 29.02% (43746/150761)
Branch Coverage: 25.55% (22327/87374)
Coverage Report: http://coverage.selectdb-in.cc/coverage/48895c6528c7eda04245b88a609e3422365e6818_48895c6528c7eda04245b88a609e3422365e6818/report/index.html

[dqz123]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33050 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f705f6ebd78aa7d71382df7634dab83770c9a2a7, data reload: false

------ Round 1 ----------------------------------
q1	17565	6164	6093	6093
q2	2050	298	160	160
q3	10582	1215	739	739
q4	10190	856	431	431
q5	7522	2150	1936	1936
q6	206	175	147	147
q7	878	739	604	604
q8	9252	1362	1181	1181
q9	5237	4929	4912	4912
q10	6759	2314	1860	1860
q11	470	281	267	267
q12	341	362	230	230
q13	17819	3732	3330	3330
q14	243	247	221	221
q15	569	499	496	496
q16	636	647	586	586
q17	577	861	346	346
q18	6975	6581	6486	6486
q19	2351	943	547	547
q20	306	316	189	189
q21	2943	2186	1985	1985
q22	359	329	304	304
Total cold run time: 103830 ms
Total hot run time: 33050 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6331	6228	6247	6228
q2	241	322	234	234
q3	2230	2654	2363	2363
q4	1420	1832	1348	1348
q5	4300	4681	4831	4681
q6	184	177	142	142
q7	2062	1970	1828	1828
q8	2590	2796	2675	2675
q9	7286	7261	7170	7170
q10	3076	3323	2741	2741
q11	573	539	503	503
q12	679	821	643	643
q13	3443	3869	3291	3291
q14	292	299	284	284
q15	549	510	528	510
q16	681	683	647	647
q17	1201	1716	1254	1254
q18	7756	7487	7375	7375
q19	805	1082	1091	1082
q20	2021	2014	1898	1898
q21	5733	5162	4981	4981
q22	616	599	575	575
Total cold run time: 54069 ms
Total hot run time: 52453 ms

[doris-robot]

TeamCity be ut coverage result:
Function Coverage: 38.90% (10136/26058)
Line Coverage: 29.95% (85760/286358)
Region Coverage: 29.03% (43739/150649)
Branch Coverage: 25.58% (22326/87296)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f705f6ebd78aa7d71382df7634dab83770c9a2a7_f705f6ebd78aa7d71382df7634dab83770c9a2a7/report/index.html

[doris-robot]

TPC-DS: Total hot run time: 194998 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 f705f6ebd78aa7d71382df7634dab83770c9a2a7, data reload: false

query1	1285	942	967	942
query2	6372	2322	2376	2322
query3	11145	4749	4658	4658
query4	32785	23517	23256	23256
query5	4198	619	459	459
query6	294	201	195	195
query7	4001	486	319	319
query8	305	254	234	234
query9	9291	2723	2714	2714
query10	459	317	247	247
query11	17751	15585	15143	15143
query12	157	108	105	105
query13	1727	535	380	380
query14	11903	7058	6592	6592
query15	226	199	195	195
query16	7881	586	469	469
query17	1526	734	577	577
query18	2115	416	310	310
query19	229	191	164	164
query20	119	115	110	110
query21	221	129	105	105
query22	4629	4433	4426	4426
query23	33912	33781	33813	33781
query24	5963	2334	2382	2334
query25	498	457	399	399
query26	753	282	151	151
query27	2201	468	345	345
query28	5515	2494	2442	2442
query29	612	568	433	433
query30	208	186	147	147
query31	948	875	781	781
query32	70	58	58	58
query33	527	344	295	295
query34	780	873	501	501
query35	827	825	745	745
query36	995	1056	973	973
query37	126	109	76	76
query38	4067	4240	4093	4093
query39	1509	1452	1428	1428
query40	203	120	100	100
query41	50	50	46	46
query42	116	103	105	103
query43	517	573	493	493
query44	1311	821	839	821
query45	177	170	178	170
query46	861	1069	655	655
query47	1878	1906	1870	1870
query48	381	401	318	318
query49	698	481	396	396
query50	664	666	403	403
query51	7055	7182	6925	6925
query52	103	97	97	97
query53	217	254	182	182
query54	471	510	402	402
query55	81	78	85	78
query56	255	270	227	227
query57	1205	1175	1151	1151
query58	249	229	242	229
query59	3133	3308	3287	3287
query60	274	264	256	256
query61	114	114	117	114
query62	879	814	748	748
query63	227	188	190	188
query64	3230	1129	754	754
query65	3307	3253	3230	3230
query66	793	416	330	330
query67	16396	15726	15472	15472
query68	8793	705	515	515
query69	491	292	247	247
query70	1226	1157	1125	1125
query71	438	282	280	280
query72	6278	3822	3854	3822
query73	662	762	355	355
query74	10234	9140	8607	8607
query75	4596	3136	2666	2666
query76	4321	1180	772	772
query77	783	362	275	275
query78	9969	10081	9244	9244
query79	3204	839	596	596
query80	583	524	428	428
query81	472	279	242	242
query82	653	149	119	119
query83	162	161	143	143
query84	241	91	72	72
query85	779	435	301	301
query86	345	313	297	297
query87	4413	4340	4409	4340
query88	4385	2180	2162	2162
query89	418	334	289	289
query90	1843	188	191	188
query91	133	137	108	108
query92	64	56	51	51
query93	1830	845	524	524
query94	655	376	299	299
query95	336	263	253	253
query96	491	603	277	277
query97	2814	2969	2846	2846
query98	229	198	197	197
query99	1425	1485	1409	1409
Total cold run time: 296241 ms
Total hot run time: 194998 ms

[doris-robot]

ClickBench: Total hot run time: 31.4 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f705f6ebd78aa7d71382df7634dab83770c9a2a7, data reload: false

query1	0.03	0.03	0.03
query2	0.07	0.03	0.04
query3	0.25	0.08	0.07
query4	1.62	0.10	0.10
query5	0.43	0.43	0.40
query6	1.16	0.67	0.64
query7	0.02	0.02	0.02
query8	0.04	0.04	0.04
query9	0.59	0.49	0.50
query10	0.55	0.56	0.54
query11	0.15	0.10	0.10
query12	0.14	0.10	0.11
query13	0.62	0.60	0.59
query14	2.70	2.76	2.73
query15	0.90	0.82	0.82
query16	0.39	0.39	0.37
query17	1.00	0.98	0.99
query18	0.23	0.21	0.21
query19	1.97	1.91	1.93
query20	0.02	0.01	0.01
query21	15.38	0.90	0.58
query22	0.76	0.73	0.69
query23	15.30	1.51	0.58
query24	2.94	1.74	0.96
query25	0.22	0.12	0.21
query26	0.25	0.15	0.13
query27	0.05	0.06	0.06
query28	14.03	1.52	1.05
query29	12.57	4.05	3.32
query30	0.25	0.09	0.07
query31	2.84	0.60	0.39
query32	3.22	0.55	0.46
query33	3.07	3.05	3.16
query34	16.82	5.15	4.49
query35	4.54	4.49	4.48
query36	0.64	0.53	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.16	0.14	0.13
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.24 s
Total hot run time: 31.4 s

[dqz123]

run p0