You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org> on 2024/07/18 09:16:00 UTC
[PR] [fix](profile) Task state of query profile is not set correctly [doris]
zhiqiang-hhhh opened a new pull request, #38082:
URL: https://github.com/apache/doris/pull/38082
Task state in connection context will only be updated after profile is updated. So task state of profile should be set to query state of coordinator.
--
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](profile) Task state of query profile is not set correctly [doris]
Posted by "zhiqiang-hhhh (via GitHub)" <gi...@apache.org>.
zhiqiang-hhhh commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2236035993
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](profile) Task state of query profile is not set correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2236088527
<details>
<summary>TPC-H: <b>Total hot run time: 39767 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 80939b9234c982ca43f3eca770f62232481d2b7c, data reload: false
------ Round 1 ----------------------------------
q1 18677 4483 4348 4348
q2 3223 198 192 192
q3 10979 1182 1110 1110
q4 10671 893 816 816
q5 8553 2812 2669 2669
q6 220 138 135 135
q7 959 604 606 604
q8 9208 2078 2077 2077
q9 8861 6527 6568 6527
q10 8772 3735 3752 3735
q11 461 244 239 239
q12 402 224 217 217
q13 18973 2948 2940 2940
q14 275 235 234 234
q15 539 483 495 483
q16 508 386 373 373
q17 967 734 675 675
q18 8204 7548 7396 7396
q19 5412 1335 1422 1335
q20 706 319 341 319
q21 4800 3059 3307 3059
q22 349 288 284 284
Total cold run time: 121719 ms
Total hot run time: 39767 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4394 4225 4224 4224
q2 364 274 254 254
q3 3048 2762 2735 2735
q4 1888 1620 1602 1602
q5 5297 5292 5297 5292
q6 222 132 132 132
q7 2064 1762 1697 1697
q8 3221 3345 3298 3298
q9 8409 8403 8339 8339
q10 3913 3716 3697 3697
q11 557 493 490 490
q12 796 599 618 599
q13 16286 2951 2988 2951
q14 303 267 283 267
q15 518 474 476 474
q16 479 418 416 416
q17 1755 1517 1467 1467
q18 7734 7593 7336 7336
q19 4184 1559 1637 1559
q20 1990 1782 1739 1739
q21 5031 4674 4721 4674
q22 577 482 492 482
Total cold run time: 73030 ms
Total hot run time: 53724 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](profile) Task state of query profile is not set correctly [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2241902573
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](profile) Task state of query profile is not set correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2236111133
<details>
<summary>TPC-DS: <b>Total hot run time: 173228 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 80939b9234c982ca43f3eca770f62232481d2b7c, data reload: false
query1 910 372 368 368
query2 6459 1935 1876 1876
query3 6684 206 221 206
query4 26061 17470 17396 17396
query5 4205 487 482 482
query6 275 163 162 162
query7 4596 299 286 286
query8 234 195 197 195
query9 8569 2522 2503 2503
query10 439 284 272 272
query11 10678 10009 10217 10009
query12 133 85 81 81
query13 1650 367 376 367
query14 10325 7843 7461 7461
query15 227 171 172 171
query16 7634 330 322 322
query17 1771 579 538 538
query18 1907 288 283 283
query19 197 158 155 155
query20 94 85 79 79
query21 220 127 130 127
query22 4486 4220 4120 4120
query23 34055 33189 33232 33189
query24 11901 2878 2813 2813
query25 687 394 393 393
query26 1753 153 149 149
query27 2963 275 277 275
query28 7342 2063 2051 2051
query29 1099 662 635 635
query30 286 153 150 150
query31 966 726 750 726
query32 97 53 59 53
query33 800 318 308 308
query34 936 479 510 479
query35 706 609 582 582
query36 1110 936 939 936
query37 265 88 83 83
query38 2856 2755 2777 2755
query39 873 820 810 810
query40 282 123 126 123
query41 49 47 48 47
query42 124 100 102 100
query43 506 470 475 470
query44 1186 832 737 737
query45 201 158 165 158
query46 1093 723 722 722
query47 1840 1796 1757 1757
query48 377 306 310 306
query49 1177 407 424 407
query50 777 406 402 402
query51 6819 6778 6664 6664
query52 99 92 89 89
query53 354 289 291 289
query54 1060 455 456 455
query55 74 78 73 73
query56 291 268 275 268
query57 1137 1087 1074 1074
query58 253 241 244 241
query59 2824 2595 2813 2595
query60 295 275 276 275
query61 113 95 98 95
query62 834 636 659 636
query63 326 282 283 282
query64 10487 2223 1682 1682
query65 3229 3096 3117 3096
query66 1374 326 329 326
query67 15772 15011 15068 15011
query68 4732 546 546 546
query69 696 422 356 356
query70 1191 1114 1163 1114
query71 451 278 282 278
query72 8692 5650 5656 5650
query73 757 325 326 325
query74 6068 5655 5686 5655
query75 4450 2662 2640 2640
query76 3386 920 890 890
query77 726 305 300 300
query78 10669 9058 8947 8947
query79 7436 530 530 530
query80 1148 483 480 480
query81 587 226 227 226
query82 978 139 136 136
query83 396 167 167 167
query84 280 89 84 84
query85 1559 361 301 301
query86 458 326 293 293
query87 3308 3177 3101 3101
query88 4747 2494 2455 2455
query89 501 383 379 379
query90 2027 197 201 197
query91 132 101 101 101
query92 66 49 49 49
query93 5324 520 520 520
query94 1389 215 215 215
query95 416 323 327 323
query96 615 274 274 274
query97 3240 3012 3090 3012
query98 218 196 187 187
query99 1576 1271 1274 1271
Total cold run time: 297621 ms
Total hot run time: 173228 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](profile) Task state of query profile is not set correctly [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2241902603
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](profile) Task state of query profile is not set correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2236024384
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] [fix](profile) Task state of query profile is not set correctly [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee merged PR #38082:
URL: https://github.com/apache/doris/pull/38082
--
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](profile) Task state of query profile is not set correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38082:
URL: https://github.com/apache/doris/pull/38082#issuecomment-2236122343
<details>
<summary>ClickBench: <b>Total hot run time: 30.95 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 80939b9234c982ca43f3eca770f62232481d2b7c, data reload: false
query1 0.04 0.04 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.04
query4 1.67 0.06 0.07
query5 0.50 0.49 0.49
query6 1.15 0.72 0.71
query7 0.03 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.49 0.48
query10 0.53 0.54 0.53
query11 0.15 0.12 0.11
query12 0.14 0.11 0.12
query13 0.60 0.58 0.58
query14 0.76 0.77 0.78
query15 0.84 0.81 0.82
query16 0.34 0.36 0.35
query17 0.95 0.96 0.95
query18 0.23 0.22 0.22
query19 1.80 1.67 1.67
query20 0.01 0.01 0.01
query21 15.39 0.78 0.65
query22 3.70 6.75 2.49
query23 18.28 1.34 1.26
query24 2.12 0.22 0.21
query25 0.16 0.09 0.09
query26 0.29 0.21 0.20
query27 0.46 0.23 0.23
query28 13.33 1.01 0.98
query29 12.58 3.40 3.31
query30 0.25 0.06 0.05
query31 2.90 0.39 0.39
query32 3.24 0.47 0.47
query33 2.89 2.98 2.88
query34 17.12 4.35 4.32
query35 4.44 4.41 4.39
query36 0.66 0.45 0.46
query37 0.18 0.16 0.15
query38 0.15 0.14 0.14
query39 0.04 0.04 0.03
query40 0.15 0.12 0.13
query41 0.09 0.06 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 109.16 s
Total hot run time: 30.95 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