Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-21 Thread via GitHub


hello-stephen merged PR #47103:
URL: https://github.com/apache/doris/pull/47103


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


github-actions[bot] commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603792224

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


github-actions[bot] commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603792189

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603604637

   
   
   ClickBench: Total hot run time: 30.71 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a06969020f3a30feaf8386a898725f480db50c7e, 
data reload: false
   
   query1   0.030.030.03
   query2   0.080.030.03
   query3   0.240.070.07
   query4   1.610.110.10
   query5   0.470.440.40
   query6   1.160.660.66
   query7   0.030.020.02
   query8   0.040.030.03
   query9   0.600.510.49
   query10  0.550.560.54
   query11  0.140.110.11
   query12  0.130.110.11
   query13  0.610.590.60
   query14  2.692.902.75
   query15  0.920.830.84
   query16  0.370.370.38
   query17  1.071.071.03
   query18  0.230.200.21
   query19  1.981.861.97
   query20  0.010.020.01
   query21  15.36   0.920.58
   query22  0.770.830.66
   query23  15.26   1.430.56
   query24  2.610.871.54
   query25  0.180.180.08
   query26  0.310.140.15
   query27  0.060.060.06
   query28  14.30   1.030.44
   query29  12.57   3.993.27
   query30  0.270.110.07
   query31  2.810.610.38
   query32  3.230.550.46
   query33  2.973.063.02
   query34  16.50   5.194.58
   query35  4.554.574.51
   query36  0.660.480.47
   query37  0.090.060.06
   query38  0.050.040.03
   query39  0.030.030.03
   query40  0.160.130.13
   query41  0.090.030.03
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 105.86 s
   Total hot run time: 30.71 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603600756

   
   
   TPC-DS: Total hot run time: 194630 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 a06969020f3a30feaf8386a898725f480db50c7e, 
data reload: false
   
   query1   1307977 934 934
   query2   6345209820742074
   query3   11100   467645444544
   query4   32683   23453   22763   22763
   query5   3538588 458 458
   query6   283 204 196 196
   query7   4009487 313 313
   query8   297 240 240 240
   query9   9252258925822582
   query10  472 309 250 250
   query11  17681   15167   15345   15167
   query12  155 106 103 103
   query13  1557497 399 399
   query14  9562713568386838
   query15  243 214 185 185
   query16  7542621 456 456
   query17  1646737 564 564
   query18  1502397 326 326
   query19  213 188 165 165
   query20  123 114 117 114
   query21  214 134 105 105
   query22  4625463945294529
   query23  34297   33711   33455   33455
   query24  6709228323142283
   query25  512 469 401 401
   query26  734 282 152 152
   query27  2214478 343 343
   query28  5443247124432443
   query29  573 560 445 445
   query30  217 191 156 156
   query31  980 897 843 843
   query32  74  57  61  57
   query33  490 378 312 312
   query34  747 888 522 522
   query35  818 856 762 762
   query36  10341081964 964
   query37  125 102 79  79
   query38  4452429642284228
   query39  1553146114341434
   query40  202 113 101 101
   query41  51  51  50  50
   query42  130 105 106 105
   query43  531 561 498 498
   query44  1401841 831 831
   query45  183 176 171 171
   query46  890 1056663 663
   query47  1888196918611861
   query48  389 421 343 343
   query49  728 514 398 398
   query50  654 667 420 420
   query51  7118710470527052
   query52  104 102 95  95
   query53  229 255 197 197
   query54  495 533 448 448
   query55  84  85  84  84
   query56  257 297 242 242
   query57  1200121810881088
   query58  255 277 249 249
   query59  3366329631583158
   query60  289 284 322 284
   query61  135 133 120 120
   query62  814 751 655 655
   query63  230 190 194 190
   query64  33421064671 671
   query65  3205314031483140
   query66  738 389 294 294
   query67  15929   15657   15574   15574
   query68  2791841 539 539
   query69  444 297 262 262
   query70  1211110411471104
   query71  361 292 254 254
   query72  5956389638013801
   query73  651 737 362 362
   query74  9978899291358992
   query75  3167315026682668
   query76  29291190790 790
   query77  506 362 289 289
   query78  10007   93119311
   query79  2781810 610 610
   query80  1724624 435 435
   query81  539 289 229 229
   query82  365 160 123 123
   query83  273 171 151 151
   query84  229 90  75  75
   query85  784 351 314 314
   query86  410 311 306 306
   query87  4485449044554455
   query88  3793217321772173
   query89  393 340 296 296
   query90  1717189 191 189
   query91  136 151 107 107
   query92  67  55  51  51
   query93  1215896 531 531
   query94  652 413 297 297
   query95  337 275 272 272
   query96  488 610 289 289
   query97  2799286527422742
   query98  224 197 194 194
   query99  1289136912531253
   Total cold run time: 282851 ms
   Total hot run time: 194630 ms
   ```
   
   


-- 
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 t

Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603591744

   
   
   TPC-H: Total hot run time: 32437 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a06969020f3a30feaf8386a898725f480db50c7e, 
data reload: false
   
   -- Round 1 --
   q1   17574   551454235423
   q2   2053326 178 178
   q3   10432   1239754 754
   q4   10230   961 521 521
   q5   7684238821562156
   q6   195 171 140 140
   q7   907 761 600 600
   q8   9230137111681168
   q9   5269491849394918
   q10  6829233918601860
   q11  482 270 246 246
   q12  349 353 219 219
   q13  17781   372132163216
   q14  230 232 220 220
   q15  516 476 480 476
   q16  653 634 591 591
   q17  581 864 325 325
   q18  7088647764136413
   q19  1925968 534 534
   q20  313 325 196 196
   q21  2938217819711971
   q22  362 344 312 312
   Total cold run time: 103621 ms
   Total hot run time: 32437 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5539549454985494
   q2   244 334 238 238
   q3   2191269022762276
   q4   1396179613401340
   q5   4327477346824682
   q6   172 161 128 128
   q7   2054198118551855
   q8   2623277926902690
   q9   7323725372997253
   q10  3063330127962796
   q11  576 513 481 481
   q12  627 740 565 565
   q13  3445389832943294
   q14  293 305 275 275
   q15  514 478 473 473
   q16  653 688 628 628
   q17  1205174712481248
   q18  7763751374197419
   q19  814 119710551055
   q20  2018205918801880
   q21  5841516947114711
   q22  612 559 559 559
   Total cold run time: 53293 ms
   Total hot run time: 51340 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603493481

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-20 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2603491103

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-19 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2601248100

   
   
   ClickBench: Total hot run time: 31.21 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 889b7d78f5df4e7be9aaac55f0e38a60e716ee9d, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.040.03
   query3   0.230.070.07
   query4   1.620.100.10
   query5   0.420.410.42
   query6   1.160.640.65
   query7   0.030.020.01
   query8   0.040.030.04
   query9   0.600.510.50
   query10  0.570.580.58
   query11  0.150.100.10
   query12  0.140.120.11
   query13  0.600.600.61
   query14  2.812.742.88
   query15  0.900.830.82
   query16  0.360.380.39
   query17  1.061.011.08
   query18  0.230.210.21
   query19  1.961.882.00
   query20  0.020.020.01
   query21  15.35   0.900.56
   query22  0.740.870.65
   query23  15.26   1.430.63
   query24  2.991.421.93
   query25  0.210.140.09
   query26  0.220.140.14
   query27  0.050.050.06
   query28  14.51   0.950.44
   query29  12.55   3.913.24
   query30  0.250.090.07
   query31  2.810.600.39
   query32  3.230.550.46
   query33  3.103.003.11
   query34  16.72   5.194.53
   query35  4.544.554.48
   query36  0.630.490.51
   query37  0.100.060.06
   query38  0.050.040.03
   query39  0.040.020.03
   query40  0.180.140.13
   query41  0.080.030.02
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 106.68 s
   Total hot run time: 31.21 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-19 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2601243484

   
   
   TPC-DS: Total hot run time: 187610 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 889b7d78f5df4e7be9aaac55f0e38a60e716ee9d, 
data reload: false
   
   query1   977 378 379 378
   query2   6516209219771977
   query3   6795216 211 211
   query4   33219   23368   23106   23106
   query5   4417607 471 471
   query6   304 210 196 196
   query7   4611488 304 304
   query8   301 241 236 236
   query9   9638260025862586
   query10  471 311 258 258
   query11  17870   15210   15002   15002
   query12  160 105 103 103
   query13  1652542 400 400
   query14  9281690879256908
   query15  272 210 201 201
   query16  8303597 439 439
   query17  1642717 538 538
   query18  1414362 300 300
   query19  231 181 154 154
   query20  114 113 139 113
   query21  208 119 100 100
   query22  4206445742594259
   query23  33577   32830   33066   32830
   query24  6546223622342234
   query25  490 445 372 372
   query26  760 264 156 156
   query27  2052463 329 329
   query28  5319240423882388
   query29  569 532 414 414
   query30  232 182 160 160
   query31  988 870 815 815
   query32  95  65  62  62
   query33  503 343 299 299
   query34  749 853 489 489
   query35  796 805 734 734
   query36  995 1070977 977
   query37  114 113 74  74
   query38  4115416142374161
   query39  1454141414401414
   query40  198 114 101 101
   query41  52  51  52  51
   query42  115 101 102 101
   query43  509 511 486 486
   query44  1270805 787 787
   query45  181 175 165 165
   query46  838 1038634 634
   query47  1790181617671767
   query48  379 404 308 308
   query49  726 487 401 401
   query50  619 679 388 388
   query51  6954683668596836
   query52  105 106 87  87
   query53  225 248 183 183
   query54  484 518 424 424
   query55  83  80  79  79
   query56  273 249 250 249
   query57  1231115511071107
   query58  250 228 235 228
   query59  2905298629562956
   query60  268 263 269 263
   query61  118 118 155 118
   query62  754 728 653 653
   query63  218 195 184 184
   query64  3445994 655 655
   query65  3226319031483148
   query66  765 404 326 326
   query67  15863   15558   15437   15437
   query68  5954815 530 530
   query69  486 297 259 259
   query70  1174112611511126
   query71  383 285 254 254
   query72  5945381037383738
   query73  639 741 367 367
   query74  10165   918090399039
   query75  3168317726992699
   query76  31681182844 844
   query77  536 357 278 278
   query78  10071   10044   92549254
   query79  2792798 581 581
   query80  617 536 431 431
   query81  508 294 245 245
   query82  377 160 119 119
   query83  186 165 155 155
   query84  239 92  123 92
   query85  788 339 307 307
   query86  421 311 306 306
   query87  4547444843904390
   query88  5097213421052105
   query89  390 341 294 294
   query90  1893190 192 190
   query91  137 141 109 109
   query92  65  58  54  54
   query93  1951897 548 548
   query94  672 421 286 286
   query95  342 263 254 254
   query96  492 591 275 275
   query97  2816286027842784
   query98  231 201 200 200
   query99  1262136412271227
   Total cold run time: 283312 ms
   Total hot run time: 187610 ms
   ```
   
   


-- 
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

Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-19 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2601233867

   
   
   TPC-H: Total hot run time: 32187 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 889b7d78f5df4e7be9aaac55f0e38a60e716ee9d, 
data reload: false
   
   -- Round 1 --
   q1   17590   548253925392
   q2   2048320 182 182
   q3   10487   1310712 712
   q4   10266   954 531 531
   q5   8880244821322132
   q6   198 166 136 136
   q7   924 761 623 623
   q8   9256132911401140
   q9   5927487749004877
   q10  6907234818951895
   q11  479 273 263 263
   q12  344 360 216 216
   q13  17774   366630283028
   q14  233 239 211 211
   q15  528 482 457 457
   q16  645 617 592 592
   q17  563 861 329 329
   q18  7104661464806480
   q19  1869950 538 538
   q20  314 327 186 186
   q21  2760216219461946
   q22  363 345 321 321
   Total cold run time: 105459 ms
   Total hot run time: 32187 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5614545754825457
   q2   242 330 241 241
   q3   2319263922832283
   q4   1435182414081408
   q5   4327472747364727
   q6   176 162 124 124
   q7   2098201218701870
   q8   2645277626812681
   q9   7332732171657165
   q10  2952325128282828
   q11  575 498 490 490
   q12  708 737 608 608
   q13  3554390633343334
   q14  272 296 271 271
   q15  524 480 462 462
   q16  659 693 654 654
   q17  1208173312781278
   q18  7856762574137413
   q19  758 112210451045
   q20  1983204318671867
   q21  5658534949364936
   q22  610 622 553 553
   Total cold run time: 53505 ms
   Total hot run time: 51695 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-19 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2601210694

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597989750

   
   
   ClickBench: Total hot run time: 30.52 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 83a7e62844e50fd4cc200ff1aee50413ad367256, 
data reload: false
   
   query1   0.030.030.03
   query2   0.080.030.04
   query3   0.240.070.08
   query4   1.620.110.10
   query5   0.400.430.41
   query6   1.140.650.65
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.590.490.51
   query10  0.550.570.57
   query11  0.140.100.10
   query12  0.140.110.10
   query13  0.600.600.59
   query14  2.732.822.74
   query15  0.890.820.82
   query16  0.390.370.37
   query17  1.001.060.99
   query18  0.230.220.22
   query19  1.971.832.01
   query20  0.020.020.01
   query21  15.37   1.000.59
   query22  0.740.750.78
   query23  15.29   1.450.57
   query24  2.940.611.73
   query25  0.150.130.23
   query26  0.300.130.14
   query27  0.050.040.06
   query28  14.06   1.030.42
   query29  12.61   4.053.33
   query30  0.250.080.06
   query31  2.830.600.38
   query32  3.230.550.46
   query33  2.983.023.05
   query34  16.62   5.224.50
   query35  4.574.564.57
   query36  0.660.510.49
   query37  0.100.060.06
   query38  0.040.040.03
   query39  0.040.030.02
   query40  0.160.130.13
   query41  0.080.020.02
   query42  0.040.030.02
   query43  0.040.030.03
   Total cold run time: 105.97 s
   Total hot run time: 30.52 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597955450

   
   
   TPC-DS: Total hot run time: 187593 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 83a7e62844e50fd4cc200ff1aee50413ad367256, 
data reload: false
   
   query1   963 393 375 375
   query2   6525205520832055
   query3   6784213 219 213
   query4   33624   23239   23304   23239
   query5   4344638 474 474
   query6   287 197 189 189
   query7   4606509 315 315
   query8   289 245 241 241
   query9   9475257525742574
   query10  475 320 261 261
   query11  18017   15036   15016   15016
   query12  166 109 110 109
   query13  1652505 404 404
   query14  9911694965066506
   query15  233 200 187 187
   query16  7989611 492 492
   query17  1603725 546 546
   query18  2084396 282 282
   query19  222 172 149 149
   query20  148 112 109 109
   query21  211 122 98  98
   query22  4320413642804136
   query23  34674   33012   33117   33012
   query24  6498227722412241
   query25  462 454 390 390
   query26  1060256 155 155
   query27  2003461 334 334
   query28  5271239723952395
   query29  521 532 413 413
   query30  242 183 156 156
   query31  961 877 789 789
   query32  80  65  58  58
   query33  507 368 291 291
   query34  741 838 496 496
   query35  787 825 749 749
   query36  998 1026926 926
   query37  118 95  81  81
   query38  4106427041904190
   query39  1464141814061406
   query40  201 121 99  99
   query41  52  54  52  52
   query42  117 98  104 98
   query43  516 526 489 489
   query44  1292803 793 793
   query45  174 176 164 164
   query46  854 1034635 635
   query47  1820180717771777
   query48  375 391 308 308
   query49  778 502 393 393
   query50  609 673 380 380
   query51  7045698069596959
   query52  100 101 91  91
   query53  221 252 183 183
   query54  471 519 410 410
   query55  85  78  82  78
   query56  272 277 250 250
   query57  1150113310721072
   query58  243 244 235 235
   query59  2928306230503050
   query60  285 265 247 247
   query61  117 117 116 116
   query62  835 717 640 640
   query63  222 184 190 184
   query64  44101011636 636
   query65  3237311231623112
   query66  1062423 313 313
   query67  15908   15611   15517   15517
   query68  5149825 530 530
   query69  468 289 256 256
   query70  1179110311291103
   query71  390 296 253 253
   query72  5757382537893789
   query73  656 737 354 354
   query74  10044   899989098909
   query75  3174330926482648
   query76  32931203795 795
   query77  551 360 275 275
   query78  10093   10078   93259325
   query79  3174798 598 598
   query80  615 527 434 434
   query81  522 284 240 240
   query82  553 147 125 125
   query83  176 172 155 155
   query84  246 88  71  71
   query85  893 341 302 302
   query86  403 321 313 313
   query87  4379451344464446
   query88  4727215221012101
   query89  402 318 298 298
   query90  1869189 187 187
   query91  137 139 105 105
   query92  65  56  51  51
   query93  1968895 538 538
   query94  719 415 276 276
   query95  336 260 259 259
   query96  484 632 276 276
   query97  2812290927922792
   query98  231 203 196 196
   query99  1265136612601260
   Total cold run time: 286530 ms
   Total hot run time: 187593 ms
   ```
   
   


-- 
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 th

Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597917667

   
   
   TPC-H: Total hot run time: 32711 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 83a7e62844e50fd4cc200ff1aee50413ad367256, 
data reload: false
   
   -- Round 1 --
   q1   17584   583257375737
   q2   2048306 173 173
   q3   10504   1314727 727
   q4   10293   986 543 543
   q5   8846242221792179
   q6   194 169 139 139
   q7   910 758 599 599
   q8   9239134611141114
   q9   5407499749464946
   q10  6894234419081908
   q11  475 273 257 257
   q12  363 362 224 224
   q13  1   366431263126
   q14  237 247 209 209
   q15  520 461 462 461
   q16  636 617 576 576
   q17  572 872 320 320
   q18  7109644264236423
   q19  2184977 536 536
   q20  320 322 193 193
   q21  2833220919991999
   q22  375 335 322 322
   Total cold run time: 105320 ms
   Total hot run time: 32711 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6077591459295914
   q2   237 336 239 239
   q3   2220264023022302
   q4   1412183513681368
   q5   4345471948734719
   q6   170 167 126 126
   q7   2102204618211821
   q8   2640278426402640
   q9   7262721972077207
   q10  3035332028152815
   q11  601 536 516 516
   q12  681 748 625 625
   q13  3467398231933193
   q14  282 294 279 279
   q15  515 488 466 466
   q16  637 693 661 661
   q17  1256175512551255
   q18  7889743473447344
   q19  804 113911071107
   q20  2058204118631863
   q21  5826537548644864
   q22  628 613 574 574
   Total cold run time: 54144 ms
   Total hot run time: 51898 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597859496

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


doris-robot commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597858176

   
   
   TPC-H: Total hot run time: 32342 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ea3491368fa3b909d91bfe53ab58b057c126e644, 
data reload: false
   
   -- Round 1 --
   q1   17614   549154125412
   q2   2049295 177 177
   q3   10476   1232763 763
   q4   10220   981 521 521
   q5   7980239721802180
   q6   195 162 135 135
   q7   914 763 594 594
   q8   9251137411601160
   q9   5296487748644864
   q10  6832233118821882
   q11  480 275 257 257
   q12  363 355 224 224
   q13  17768   376430703070
   q14  242 231 206 206
   q15  509 475 458 458
   q16  635 613 596 596
   q17  575 870 329 329
   q18  6995646564586458
   q19  1755955 550 550
   q20  322 321 189 189
   q21  2843220620092009
   q22  369 337 308 308
   Total cold run time: 103683 ms
   Total hot run time: 32342 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5588571955095509
   q2   238 326 236 236
   q3   2256271223572357
   q4   1478184513561356
   q5   4332478746894689
   q6   175 167 126 126
   q7   2074194518841884
   q8   2602285026982698
   q9   7384723172387231
   q10  3061329828352835
   q11  591 510 478 478
   q12  652 738 594 594
   q13  3579396933103310
   q14  283 303 285 285
   q15  512 473 463 463
   q16  660 689 650 650
   q17  1243176612741274
   q18  7726758574217421
   q19  862 110911161109
   q20  2022204318891889
   q21  5762518049834983
   q22  607 640 559 559
   Total cold run time: 53687 ms
   Total hot run time: 51936 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-17 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2597741250

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-16 Thread via GitHub


zddr commented on code in PR #47103:
URL: https://github.com/apache/doris/pull/47103#discussion_r1919509758


##
regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy:
##
@@ -1521,22 +1521,22 @@ class Suite implements GroovyInterceptable {
 
 def waitingMTMVTaskFinishedByMvNameAllowCancel = {mvName, dbName = 
context.dbName ->
 Thread.sleep(2000);
-String showTasks = "select 
TaskId,JobId,JobName,MvId,Status,MvName,MvDatabaseName,ErrorMsg from 
tasks('type'='mv') where MvDatabaseName = '${dbName}' and MvName = '${mvName}' 
order by CreateTime DESC LIMIT 1"
+String showTasks = "select 
TaskId,JobId,JobName,MvId,Status,MvName,MvDatabaseName,ErrorMsg from 
tasks('type'='mv') where MvDatabaseName = '${dbName}' and MvName = '${mvName}' 
order by CreateTime ASC"
 
 String status = "NULL"
 List> result
 long startTime = System.currentTimeMillis()
 long timeoutTimestamp = startTime + 5 * 60 * 1000 // 5 min
 List toCheckTaskRow = new ArrayList<>();
-while (timeoutTimestamp > System.currentTimeMillis() && (status != 
"SUCCESS")) {
+while (timeoutTimestamp > System.currentTimeMillis() && (status == 
'PENDING' || status == 'RUNNING' || status == 'NULL')) {

Review Comment:
   should add `|| status == 'CANCELED'`



-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-16 Thread via GitHub


seawinde commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2595521695

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [test](mtmv) Fix mv regression test fail occasionally and add some log [doris]

2025-01-16 Thread via GitHub


hello-stephen commented on PR #47103:
URL: https://github.com/apache/doris/pull/47103#issuecomment-2595521484

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]