You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mymeiyi (via GitHub)" <gi...@apache.org> on 2025/11/26 08:02:09 UTC
[PR] [fix](snapshot) drop index should set db_id [doris]
mymeiyi opened a new pull request, #58401:
URL: https://github.com/apache/doris/pull/58401
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
`recycle_indexes` require `db_id` to recycle multi versioned keys, but drop index does not set db_id
### 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] [fix](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3584111457
# FE UT Coverage Report
Increment line coverage ` 25.00% (2/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046/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] [fix](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3584064091
<details>
<summary>TPC-DS: <b>Total hot run time: 183669 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 cecb2429a8d13aa69dd7da0a1cc5b19dddec5046, data reload: false
query1 1056 414 397 397
query2 6591 1559 1580 1559
query3 6749 227 227 227
query4 25386 22894 22568 22568
query5 4395 607 471 471
query6 330 242 212 212
query7 4648 495 293 293
query8 301 257 249 249
query9 8710 2574 2564 2564
query10 534 356 301 301
query11 15105 14881 14670 14670
query12 164 118 113 113
query13 1686 583 463 463
query14 10239 8850 8960 8850
query15 211 199 195 195
query16 7215 702 532 532
query17 1272 772 644 644
query18 2007 443 347 347
query19 217 208 185 185
query20 128 127 125 125
query21 220 139 119 119
query22 3917 4004 3989 3989
query23 33413 31856 32074 31856
query24 8435 2412 2398 2398
query25 625 550 486 486
query26 1235 276 163 163
query27 2755 485 342 342
query28 4342 2125 2125 2125
query29 839 617 483 483
query30 309 237 209 209
query31 847 718 608 608
query32 82 74 73 73
query33 589 381 321 321
query34 805 870 535 535
query35 811 833 752 752
query36 910 941 842 842
query37 120 109 84 84
query38 3284 3250 3258 3250
query39 1466 1402 1392 1392
query40 225 131 120 120
query41 67 63 63 63
query42 129 114 116 114
query43 455 472 443 443
query44 1214 778 750 750
query45 198 201 196 196
query46 884 992 643 643
query47 1690 1720 1635 1635
query48 398 434 322 322
query49 827 479 401 401
query50 652 685 402 402
query51 3886 3896 3825 3825
query52 119 116 107 107
query53 249 255 199 199
query54 300 300 277 277
query55 97 108 92 92
query56 341 334 321 321
query57 1145 1161 1095 1095
query58 296 276 276 276
query59 2416 2479 2416 2416
query60 346 357 341 341
query61 163 162 163 162
query62 761 717 704 704
query63 224 186 190 186
query64 4569 1214 887 887
query65 4059 4011 3995 3995
query66 1190 428 336 336
query67 15200 14900 14880 14880
query68 8317 931 626 626
query69 523 336 303 303
query70 1345 1179 1139 1139
query71 410 323 310 310
query72 5989 5032 4843 4843
query73 642 563 342 342
query74 8976 8503 8260 8260
query75 3296 3377 2826 2826
query76 3251 1142 706 706
query77 521 402 312 312
query78 9460 9786 8901 8901
query79 1500 816 596 596
query80 641 595 492 492
query81 509 270 240 240
query82 214 165 130 130
query83 263 260 247 247
query84 259 111 101 101
query85 897 489 441 441
query86 383 308 299 299
query87 3476 3450 3351 3351
query88 2794 2334 2274 2274
query89 389 321 292 292
query90 1923 223 216 216
query91 170 166 142 142
query92 81 70 63 63
query93 1149 984 657 657
query94 720 440 351 351
query95 494 398 409 398
query96 504 564 286 286
query97 2892 2968 2855 2855
query98 223 214 207 207
query99 1282 1402 1283 1283
Total cold run time: 267541 ms
Total hot run time: 183669 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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587901773
<details>
<summary>TPC-DS: <b>Total hot run time: 181883 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 1e5669a700c8f6e1597d975bc7dfaf77e4c4ca04, data reload: false
query1 1037 423 401 401
query2 6620 1586 1564 1564
query3 6755 223 222 222
query4 25692 23118 22974 22974
query5 4598 675 481 481
query6 336 246 229 229
query7 4640 527 316 316
query8 300 265 243 243
query9 8705 2601 2594 2594
query10 495 364 296 296
query11 15352 15134 14718 14718
query12 183 123 112 112
query13 1689 573 441 441
query14 9703 5629 5556 5556
query15 219 204 187 187
query16 7496 731 550 550
query17 1245 807 683 683
query18 2012 435 329 329
query19 214 203 175 175
query20 132 125 124 124
query21 225 141 117 117
query22 3976 3869 3923 3869
query23 33083 31876 32053 31876
query24 8639 2457 2433 2433
query25 615 534 454 454
query26 1245 292 163 163
query27 2726 519 344 344
query28 4333 2136 2171 2136
query29 803 660 523 523
query30 313 247 213 213
query31 844 735 650 650
query32 87 76 70 70
query33 598 391 333 333
query34 848 938 545 545
query35 827 859 748 748
query36 929 937 839 839
query37 120 111 87 87
query38 3966 3842 3791 3791
query39 1482 1407 1436 1407
query40 230 141 122 122
query41 69 68 62 62
query42 137 114 111 111
query43 458 454 407 407
query44 1353 756 766 756
query45 199 197 183 183
query46 938 1059 652 652
query47 1688 1701 1657 1657
query48 403 437 327 327
query49 797 510 416 416
query50 707 738 408 408
query51 3974 3979 3930 3930
query52 113 118 107 107
query53 247 280 198 198
query54 311 301 275 275
query55 102 97 95 95
query56 340 364 332 332
query57 1176 1149 1117 1117
query58 286 281 266 266
query59 2327 2449 2282 2282
query60 360 354 337 337
query61 182 163 163 163
query62 847 767 682 682
query63 242 201 192 192
query64 4646 1330 922 922
query65 4057 3973 3945 3945
query66 1141 477 342 342
query67 15471 15065 14943 14943
query68 7629 975 620 620
query69 546 352 301 301
query70 1167 1031 1042 1031
query71 453 352 317 317
query72 5758 4815 4779 4779
query73 676 582 344 344
query74 8740 8866 8535 8535
query75 3223 3184 2587 2587
query76 3279 1251 747 747
query77 506 422 339 339
query78 9386 9493 8842 8842
query79 2278 904 619 619
query80 689 599 492 492
query81 516 284 241 241
query82 499 152 112 112
query83 266 275 255 255
query84 259 113 103 103
query85 949 495 445 445
query86 384 309 291 291
query87 4176 4046 4026 4026
query88 4225 2300 2309 2300
query89 410 348 304 304
query90 1924 225 216 216
query91 169 173 142 142
query92 83 72 68 68
query93 1982 995 646 646
query94 759 460 345 345
query95 510 408 404 404
query96 521 595 293 293
query97 2718 2752 2622 2622
query98 254 223 217 217
query99 1364 1427 1278 1278
Total cold run time: 272181 ms
Total hot run time: 181883 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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3584047132
<details>
<summary>TPC-H: <b>Total hot run time: 34204 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 cecb2429a8d13aa69dd7da0a1cc5b19dddec5046, data reload: false
------ Round 1 ----------------------------------
q1 17634 5023 4840 4840
q2 2033 314 199 199
q3 10263 1278 719 719
q4 10227 908 370 370
q5 7530 2327 2323 2323
q6 187 167 137 137
q7 924 778 633 633
q8 9335 1320 1031 1031
q9 7060 5277 5239 5239
q10 7275 2218 1805 1805
q11 527 301 274 274
q12 342 358 223 223
q13 17875 3768 3089 3089
q14 239 238 216 216
q15 599 535 519 519
q16 1083 1024 997 997
q17 603 873 362 362
q18 7812 7256 7310 7256
q19 1147 942 543 543
q20 338 335 227 227
q21 3611 2560 2234 2234
q22 1023 1025 968 968
Total cold run time: 107667 ms
Total hot run time: 34204 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4912 4907 4948 4907
q2 339 407 315 315
q3 2134 2633 2338 2338
q4 1301 1761 1323 1323
q5 4236 4405 4549 4405
q6 211 179 133 133
q7 2115 1947 1814 1814
q8 2663 2450 2589 2450
q9 7615 7351 7575 7351
q10 3052 3218 2808 2808
q11 580 512 507 507
q12 660 780 652 652
q13 3628 3882 3293 3293
q14 290 335 295 295
q15 567 515 514 514
q16 1114 1119 1061 1061
q17 1149 1542 1382 1382
q18 7991 7936 7625 7625
q19 804 810 841 810
q20 1991 2053 1910 1910
q21 4900 4339 4234 4234
q22 1113 1047 992 992
Total cold run time: 53365 ms
Total hot run time: 51119 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](snapshot) drop index should set db_id [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3580830345
run cloud_p0
--
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](snapshot) drop index should set db_id [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3579948466
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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3580352220
<details>
<summary>ClickBench: <b>Total hot run time: 27.98 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 eb063a5c7c15fb3a76f9f3618f8bbeac2717e955, data reload: false
query1 0.06 0.04 0.05
query2 0.09 0.05 0.04
query3 0.26 0.08 0.08
query4 1.61 0.11 0.11
query5 0.26 0.25 0.25
query6 1.19 0.64 0.63
query7 0.03 0.02 0.03
query8 0.05 0.05 0.04
query9 0.58 0.52 0.51
query10 0.58 0.57 0.58
query11 0.17 0.11 0.12
query12 0.15 0.13 0.12
query13 0.64 0.62 0.60
query14 1.00 1.02 0.99
query15 0.85 0.82 0.84
query16 0.39 0.40 0.40
query17 1.05 1.02 1.02
query18 0.20 0.20 0.20
query19 1.89 1.86 1.82
query20 0.01 0.02 0.02
query21 15.44 0.19 0.14
query22 5.02 0.07 0.05
query23 15.66 0.27 0.11
query24 2.55 0.80 0.81
query25 0.07 0.08 0.08
query26 0.14 0.14 0.13
query27 0.08 0.06 0.05
query28 5.03 1.16 0.92
query29 12.57 3.90 3.24
query30 0.27 0.14 0.12
query31 2.82 0.60 0.39
query32 3.23 0.55 0.48
query33 2.99 3.10 3.13
query34 15.84 5.17 4.54
query35 4.57 4.59 4.59
query36 0.66 0.50 0.50
query37 0.11 0.06 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.04
query40 0.18 0.14 0.15
query41 0.08 0.04 0.03
query42 0.03 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 98.55 s
Total hot run time: 27.98 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](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3580946136
# FE Regression Coverage Report
Increment line coverage ` 90.91% (10/11)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58401_eb063a5c7c15fb3a76f9f3618f8bbeac2717e955_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58401_eb063a5c7c15fb3a76f9f3618f8bbeac2717e955_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
Re: [PR] [fix](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3588223970
# FE Regression Coverage Report
Increment line coverage ` 87.50% (14/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58401_1e5669a700c8f6e1597d975bc7dfaf77e4c4ca04_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58401_1e5669a700c8f6e1597d975bc7dfaf77e4c4ca04_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
Re: [PR] [fix](snapshot) drop index should set db_id [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou merged PR #58401:
URL: https://github.com/apache/doris/pull/58401
--
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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3580243391
<details>
<summary>TPC-H: <b>Total hot run time: 34681 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 eb063a5c7c15fb3a76f9f3618f8bbeac2717e955, data reload: false
------ Round 1 ----------------------------------
q1 17651 5068 5047 5047
q2 2026 332 220 220
q3 10219 1316 742 742
q4 10239 888 375 375
q5 7526 2450 2352 2352
q6 184 164 138 138
q7 943 787 645 645
q8 9353 1431 1101 1101
q9 7162 5269 5297 5269
q10 6907 2262 1854 1854
q11 509 302 278 278
q12 370 366 226 226
q13 17796 3678 3082 3082
q14 232 252 223 223
q15 598 514 525 514
q16 1061 1019 979 979
q17 598 873 365 365
q18 7933 7188 7153 7153
q19 1088 958 557 557
q20 342 347 231 231
q21 3991 3195 2374 2374
q22 1014 1019 956 956
Total cold run time: 107742 ms
Total hot run time: 34681 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5021 5000 5032 5000
q2 326 417 319 319
q3 2168 2681 2312 2312
q4 1371 1771 1329 1329
q5 4239 4607 4629 4607
q6 214 179 129 129
q7 2144 2018 1870 1870
q8 2663 2626 2572 2572
q9 7451 7430 7570 7430
q10 3049 3215 2864 2864
q11 601 520 496 496
q12 708 852 606 606
q13 3690 3962 3384 3384
q14 310 303 267 267
q15 584 519 518 518
q16 1144 1136 1094 1094
q17 1210 1574 1456 1456
q18 7842 7630 7505 7505
q19 838 878 899 878
q20 2011 2079 1946 1946
q21 5124 4283 4346 4283
q22 1071 1043 994 994
Total cold run time: 53779 ms
Total hot run time: 51859 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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3580315398
<details>
<summary>TPC-DS: <b>Total hot run time: 184869 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 eb063a5c7c15fb3a76f9f3618f8bbeac2717e955, data reload: false
query1 1051 437 386 386
query2 6555 1606 1591 1591
query3 6754 230 222 222
query4 26044 23157 22917 22917
query5 4400 606 463 463
query6 344 230 241 230
query7 4649 502 290 290
query8 316 252 245 245
query9 8679 2555 2535 2535
query10 530 371 311 311
query11 15461 14783 14564 14564
query12 194 114 112 112
query13 1671 566 454 454
query14 10113 8872 8897 8872
query15 214 197 186 186
query16 7381 711 540 540
query17 1284 768 658 658
query18 1986 425 330 330
query19 211 195 173 173
query20 134 124 119 119
query21 209 135 115 115
query22 3973 4157 3863 3863
query23 33209 32120 32100 32100
query24 8449 2394 2360 2360
query25 593 525 460 460
query26 1226 277 166 166
query27 2740 495 343 343
query28 4340 2141 2118 2118
query29 844 652 489 489
query30 310 239 210 210
query31 854 723 618 618
query32 96 72 70 70
query33 602 371 328 328
query34 807 883 523 523
query35 803 831 760 760
query36 896 952 860 860
query37 119 112 86 86
query38 3368 3287 3312 3287
query39 1474 1450 1446 1446
query40 220 129 118 118
query41 65 68 66 66
query42 131 112 111 111
query43 423 450 426 426
query44 1231 751 750 750
query45 206 186 183 183
query46 889 994 643 643
query47 1677 1743 1658 1658
query48 391 436 323 323
query49 788 506 417 417
query50 655 678 402 402
query51 3890 3882 3860 3860
query52 120 115 106 106
query53 236 271 197 197
query54 304 290 276 276
query55 98 91 99 91
query56 328 308 326 308
query57 1186 1174 1109 1109
query58 281 270 277 270
query59 2419 2542 2406 2406
query60 363 343 366 343
query61 167 169 164 164
query62 799 710 657 657
query63 225 189 193 189
query64 4554 1326 1055 1055
query65 4051 3959 3997 3959
query66 1206 459 358 358
query67 15342 14958 15027 14958
query68 8297 909 678 678
query69 511 342 297 297
query70 1254 1242 1237 1237
query71 471 328 308 308
query72 5493 4858 4852 4852
query73 603 555 343 343
query74 8871 8782 8559 8559
query75 3987 3320 2837 2837
query76 3592 1121 741 741
query77 816 403 319 319
query78 9513 9775 8918 8918
query79 1759 829 580 580
query80 743 574 486 486
query81 517 276 243 243
query82 240 161 143 143
query83 268 259 249 249
query84 268 113 95 95
query85 887 504 459 459
query86 384 311 292 292
query87 3518 3581 3430 3430
query88 2787 2228 2219 2219
query89 376 320 302 302
query90 1870 221 216 216
query91 172 174 141 141
query92 75 71 67 67
query93 1119 1013 662 662
query94 654 436 335 335
query95 502 401 409 401
query96 499 569 283 283
query97 2898 3018 2902 2902
query98 238 213 211 211
query99 1300 1372 1261 1261
Total cold run time: 269610 ms
Total hot run time: 184869 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](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3584456439
# FE Regression Coverage Report
Increment line coverage ` 87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046_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
Re: [PR] [fix](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3584071033
<details>
<summary>ClickBench: <b>Total hot run time: 27.44 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 cecb2429a8d13aa69dd7da0a1cc5b19dddec5046, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.04 0.04
query3 0.25 0.08 0.08
query4 1.60 0.11 0.11
query5 0.27 0.25 0.25
query6 1.15 0.66 0.64
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.58 0.52 0.51
query10 0.57 0.57 0.58
query11 0.16 0.11 0.11
query12 0.14 0.11 0.12
query13 0.63 0.60 0.61
query14 1.02 0.99 0.99
query15 0.84 0.82 0.82
query16 0.40 0.38 0.39
query17 1.02 1.02 1.03
query18 0.21 0.20 0.20
query19 1.89 1.84 1.83
query20 0.01 0.02 0.02
query21 15.44 0.21 0.13
query22 4.84 0.06 0.05
query23 15.67 0.26 0.10
query24 2.81 0.52 0.46
query25 0.08 0.06 0.07
query26 0.14 0.14 0.14
query27 0.07 0.05 0.05
query28 4.37 1.13 0.92
query29 12.55 3.89 3.18
query30 0.29 0.14 0.12
query31 2.82 0.57 0.39
query32 3.22 0.54 0.47
query33 3.09 3.09 3.13
query34 15.90 5.13 4.52
query35 4.50 4.54 4.59
query36 0.67 0.51 0.49
query37 0.10 0.07 0.06
query38 0.06 0.04 0.03
query39 0.03 0.02 0.02
query40 0.17 0.14 0.15
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.03
Total cold run time: 97.94 s
Total hot run time: 27.44 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](snapshot) drop index should set db_id [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3583987479
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](snapshot) drop index should set db_id [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587693336
run cloud_p0
--
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](snapshot) drop index should set db_id [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3588055613
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] [fix](snapshot) drop index should set db_id [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3588055674
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](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587825863
# FE Regression Coverage Report
Increment line coverage ` 87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58401_cecb2429a8d13aa69dd7da0a1cc5b19dddec5046_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
Re: [PR] [fix](snapshot) drop index should set db_id [doris]
Posted by "mymeiyi (via GitHub)" <gi...@apache.org>.
mymeiyi commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587828491
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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587886855
<details>
<summary>TPC-H: <b>Total hot run time: 34324 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 1e5669a700c8f6e1597d975bc7dfaf77e4c4ca04, data reload: false
------ Round 1 ----------------------------------
q1 17629 5092 4881 4881
q2 2025 308 200 200
q3 10308 1271 749 749
q4 10219 826 361 361
q5 7498 2475 2469 2469
q6 188 187 143 143
q7 956 798 643 643
q8 9345 1428 1017 1017
q9 7026 5260 5325 5260
q10 6874 2253 1831 1831
q11 507 308 291 291
q12 330 372 236 236
q13 18144 3644 3115 3115
q14 246 265 221 221
q15 599 509 512 509
q16 921 880 816 816
q17 606 782 523 523
q18 7602 7276 6992 6992
q19 1101 940 556 556
q20 334 339 224 224
q21 3580 3267 2329 2329
q22 1005 972 958 958
Total cold run time: 107043 ms
Total hot run time: 34324 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4909 4903 4906 4903
q2 324 390 321 321
q3 2220 2663 2298 2298
q4 1321 1750 1273 1273
q5 4222 4397 4606 4397
q6 224 181 140 140
q7 2004 2030 1901 1901
q8 2727 2476 2472 2472
q9 7534 7498 7612 7498
q10 3050 3301 2828 2828
q11 593 546 510 510
q12 663 781 625 625
q13 3501 3955 3483 3483
q14 282 306 281 281
q15 554 515 520 515
q16 886 931 873 873
q17 1163 1495 1441 1441
q18 7822 7848 7620 7620
q19 767 753 767 753
q20 2031 1950 2001 1950
q21 4563 4294 4172 4172
q22 1069 1046 967 967
Total cold run time: 52429 ms
Total hot run time: 51221 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](snapshot) drop index should set db_id [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3587907867
<details>
<summary>ClickBench: <b>Total hot run time: 27.39 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 1e5669a700c8f6e1597d975bc7dfaf77e4c4ca04, data reload: false
query1 0.05 0.05 0.05
query2 0.11 0.05 0.05
query3 0.25 0.09 0.09
query4 1.61 0.11 0.11
query5 0.29 0.26 0.25
query6 1.17 0.64 0.65
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.58 0.51 0.50
query10 0.57 0.58 0.55
query11 0.16 0.11 0.10
query12 0.15 0.11 0.12
query13 0.62 0.61 0.61
query14 0.99 0.99 0.98
query15 0.81 0.80 0.80
query16 0.40 0.37 0.39
query17 0.97 1.04 1.07
query18 0.23 0.22 0.21
query19 1.83 1.81 1.82
query20 0.02 0.01 0.01
query21 15.45 0.27 0.15
query22 4.58 0.06 0.05
query23 15.88 0.26 0.10
query24 1.29 0.24 0.55
query25 0.06 0.08 0.09
query26 0.14 0.13 0.13
query27 0.07 0.07 0.05
query28 4.06 1.23 1.03
query29 12.63 3.95 3.24
query30 0.28 0.14 0.11
query31 2.82 0.60 0.40
query32 3.24 0.56 0.46
query33 2.98 3.15 3.06
query34 16.96 5.18 4.52
query35 4.57 4.57 4.58
query36 0.65 0.50 0.49
query37 0.10 0.06 0.06
query38 0.07 0.04 0.04
query39 0.05 0.04 0.03
query40 0.17 0.14 0.14
query41 0.09 0.03 0.04
query42 0.04 0.03 0.04
query43 0.05 0.03 0.03
Total cold run time: 97.12 s
Total hot run time: 27.39 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](snapshot) drop index should set db_id [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58401:
URL: https://github.com/apache/doris/pull/58401#issuecomment-3579930976
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