You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yujun777 (via GitHub)" <gi...@apache.org> on 2024/01/17 03:09:50 UTC
[PR] [fix](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
yujun777 opened a new pull request, #30041:
URL: https://github.com/apache/doris/pull/30041
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1895013268
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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1895013234
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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1894866389
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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #30041:
URL: https://github.com/apache/doris/pull/30041
--
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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1894887388
<details>
<summary>TPC-DS: <b>Total hot run time: 177746 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 517e993c282bd2a7bde03109699c2df85069e64e, data reload: false
query1 931 332 327 327
query2 6561 1972 2095 1972
query3 6707 213 206 206
query4 30680 22249 22214 22214
query5 6924 545 598 545
query6 258 177 171 171
query7 4607 266 264 264
query8 225 181 178 178
query9 8439 2534 2535 2534
query10 413 228 221 221
query11 16679 15481 15496 15481
query12 132 69 71 69
query13 1687 379 379 379
query14 10574 6848 6924 6848
query15 219 185 185 185
query16 4597 233 228 228
query17 994 491 483 483
query18 1782 255 257 255
query19 173 146 142 142
query20 71 73 71 71
query21 195 133 129 129
query22 4917 4856 4823 4823
query23 31689 31067 30764 30764
query24 11577 2846 2818 2818
query25 553 303 319 303
query26 890 144 144 144
query27 2878 272 275 272
query28 5953 1842 1823 1823
query29 921 625 623 623
query30 285 151 140 140
query31 939 771 769 769
query32 86 51 49 49
query33 598 218 211 211
query34 840 442 458 442
query35 848 759 779 759
query36 1402 1231 1320 1231
query37 96 60 58 58
query38 3354 3273 3249 3249
query39 1328 1255 1265 1255
query40 207 88 85 85
query41 39 41 34 34
query42 94 83 96 83
query43 529 498 486 486
query44 1016 690 714 690
query45 198 187 175 175
query46 1059 658 669 658
query47 1612 1575 1597 1575
query48 404 307 339 307
query49 1100 286 284 284
query50 693 328 323 323
query51 5324 5306 5195 5195
query52 85 83 74 74
query53 335 269 257 257
query54 890 434 451 434
query55 90 79 76 76
query56 187 175 173 173
query57 982 963 973 963
query58 190 164 166 164
query59 2999 2822 2793 2793
query60 216 187 192 187
query61 87 80 80 80
query62 597 408 413 408
query63 275 265 269 265
query64 4076 1845 1782 1782
query65 3374 3291 3277 3277
query66 1267 329 314 314
query67 15710 15142 15038 15038
query68 12728 533 523 523
query69 620 312 300 300
query70 1859 1525 1551 1525
query71 514 210 219 210
query72 5116 2830 2838 2830
query73 3397 325 327 325
query74 6967 6352 6478 6352
query75 5209 2256 2293 2256
query76 6023 1028 1040 1028
query77 705 237 242 237
query78 9121 8602 8705 8602
query79 1066 510 511 510
query80 556 322 321 321
query81 471 207 207 207
query82 205 79 82 79
query83 172 121 125 121
query84 272 73 69 69
query85 1067 320 317 317
query86 403 372 411 372
query87 3533 3341 3389 3341
query88 2889 2285 2290 2285
query89 451 384 355 355
query90 2043 195 188 188
query91 161 120 126 120
query92 52 45 44 44
query93 1556 440 429 429
query94 1238 165 156 156
query95 497 465 441 441
query96 646 331 331 331
query97 4339 4131 4160 4131
query98 206 195 195 195
query99 1002 747 731 731
Total cold run time: 290721 ms
Total hot run time: 177746 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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1894890860
<details>
<summary>ClickBench: <b>Total hot run time: 30.87 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 517e993c282bd2a7bde03109699c2df85069e64e, data reload: false
query1 0.03 0.02 0.02
query2 0.05 0.02 0.02
query3 0.23 0.05 0.04
query4 1.69 0.07 0.06
query5 0.54 0.52 0.52
query6 1.29 0.62 0.62
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.55 0.51 0.52
query10 0.56 0.55 0.55
query11 0.11 0.10 0.09
query12 0.10 0.09 0.09
query13 0.59 0.60 0.60
query14 0.78 0.79 0.79
query15 0.80 0.78 0.78
query16 0.36 0.37 0.37
query17 1.03 1.00 1.01
query18 0.21 0.28 0.23
query19 1.86 1.80 1.78
query20 0.02 0.01 0.01
query21 15.41 0.58 0.59
query22 2.79 2.34 1.96
query23 17.33 0.88 0.71
query24 2.67 1.48 0.84
query25 0.35 0.21 0.16
query26 0.66 0.13 0.13
query27 0.06 0.05 0.05
query28 11.28 0.77 0.77
query29 12.57 3.29 3.28
query30 0.59 0.49 0.47
query31 2.78 0.34 0.35
query32 3.39 0.47 0.49
query33 3.25 3.23 3.24
query34 15.94 4.22 4.22
query35 4.25 4.26 4.21
query36 1.11 1.08 1.09
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.01
query40 0.17 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.7 s
Total hot run time: 30.87 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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1894879385
<details>
<summary>TPC-H: <b>Total hot run time: 39236 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 517e993c282bd2a7bde03109699c2df85069e64e, data reload: false
------ Round 1 ----------------------------------
q1 18137 5609 5571 5571
q2 2363 146 139 139
q3 11255 1211 1183 1183
q4 10293 825 850 825
q5 7774 3288 3194 3194
q6 200 123 123 123
q7 889 493 482 482
q8 9247 1932 1947 1932
q9 7288 6393 6341 6341
q10 8206 3050 3051 3050
q11 423 218 202 202
q12 358 198 198 198
q13 17974 3372 3350 3350
q14 250 217 209 209
q15 549 516 509 509
q16 443 377 374 374
q17 944 487 499 487
q18 7524 7022 6695 6695
q19 1559 1353 1455 1353
q20 591 307 304 304
q21 2737 2425 2413 2413
q22 374 324 302 302
Total cold run time: 109378 ms
Total hot run time: 39236 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5573 5340 5263 5263
q2 333 218 214 214
q3 3310 3179 3192 3179
q4 2109 2066 2050 2050
q5 5928 5913 5882 5882
q6 198 119 118 118
q7 2333 1881 1908 1881
q8 3217 3395 3400 3395
q9 8899 8902 8908 8902
q10 4317 3818 3766 3766
q11 722 461 453 453
q12 808 623 624 623
q13 16939 3192 3161 3161
q14 278 251 271 251
q15 555 505 507 505
q16 534 493 486 486
q17 1876 1837 1893 1837
q18 9430 9243 9546 9243
q19 24103 1633 1514 1514
q20 4596 1942 1949 1942
q21 15564 5344 5442 5344
q22 988 550 537 537
Total cold run time: 112610 ms
Total hot run time: 60546 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](fe ut) fix unstable TabletRepairAndBalanceTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30041:
URL: https://github.com/apache/doris/pull/30041#issuecomment-1894892794
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 517e993c282bd2a7bde03109699c2df85069e64e with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.6 seconds inserted 10000000 Rows, about 684K ops/s
```
--
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