doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[improve](exchange) the sink could eos early when all queues have enough rows
Proposed changes
the sink of exchange could eos as soon as possible, when the all queues have received data reached limit rows.
Issue Number: close #xxx
Further comments
If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
TPC-H: Total hot run time: 39749 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 30b886d372b6ebf995ca030ed624ce461088003c, data reload: false
------ Round 1 ----------------------------------
q1 6003 4240 4226 4226
q2 668 198 196 196
q3 7620 1105 1114 1105
q4 1008 771 716 716
q5 2649 2660 2612 2612
q6 247 164 148 148
q7 1141 623 600 600
q8 2062 2085 2058 2058
q9 6759 6563 6541 6541
q10 3800 3696 3679 3679
q11 365 242 249 242
q12 388 212 210 210
q13 16900 2994 3025 2994
q14 264 221 223 221
q15 512 477 484 477
q16 460 402 396 396
q17 953 649 736 649
q18 7915 7443 7393 7393
q19 1610 1514 1470 1470
q20 510 311 316 311
q21 4928 3926 3230 3230
q22 344 275 286 275
Total cold run time: 67106 ms
Total hot run time: 39749 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4296 4239 4234 4234
q2 370 263 265 263
q3 2981 2706 2691 2691
q4 1845 1574 1577 1574
q5 5287 5265 5261 5261
q6 208 123 124 123
q7 2190 1834 1855 1834
q8 3175 3314 3295 3295
q9 8323 8371 8369 8369
q10 3884 3707 3633 3633
q11 576 473 486 473
q12 756 618 590 590
q13 12950 2979 2993 2979
q14 293 263 245 245
q15 513 475 472 472
q16 454 417 409 409
q17 1782 1498 1459 1459
q18 7557 7292 7501 7292
q19 1654 1593 1526 1526
q20 1945 1787 1774 1774
q21 4942 4839 4814 4814
q22 561 472 485 472
Total cold run time: 66542 ms
Total hot run time: 53782 ms
TPC-DS: Total hot run time: 184745 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 30b886d372b6ebf995ca030ed624ce461088003c, data reload: false
query1 902 366 353 353
query2 6458 2412 2309 2309
query3 6649 208 210 208
query4 23113 21222 21271 21222
query5 4169 414 446 414
query6 256 170 174 170
query7 4583 303 286 286
query8 247 199 188 188
query9 8532 2417 2395 2395
query10 441 240 250 240
query11 14734 14189 14212 14189
query12 142 94 90 90
query13 1668 383 375 375
query14 10421 6561 7235 6561
query15 250 164 165 164
query16 8161 257 265 257
query17 1865 551 538 538
query18 2108 273 264 264
query19 220 146 148 146
query20 92 90 90 90
query21 198 131 124 124
query22 5012 4874 4776 4776
query23 33817 33155 33189 33155
query24 10800 2897 2896 2896
query25 615 359 361 359
query26 1652 156 149 149
query27 3048 323 312 312
query28 7722 2051 2047 2047
query29 955 595 588 588
query30 281 151 149 149
query31 992 741 720 720
query32 95 53 54 53
query33 770 259 240 240
query34 1076 484 478 478
query35 809 689 668 668
query36 1098 891 925 891
query37 126 63 65 63
query38 2884 2749 2747 2747
query39 1597 1525 1536 1525
query40 274 123 126 123
query41 40 36 38 36
query42 110 94 99 94
query43 549 548 504 504
query44 1186 708 723 708
query45 273 255 254 254
query46 1078 716 712 712
query47 1931 1879 1872 1872
query48 360 297 293 293
query49 1167 392 390 390
query50 775 386 398 386
query51 6858 6690 6679 6679
query52 99 85 92 85
query53 345 279 288 279
query54 987 424 456 424
query55 76 70 71 70
query56 236 221 221 221
query57 1261 1160 1152 1152
query58 219 192 196 192
query59 3307 3293 3102 3102
query60 267 239 233 233
query61 90 88 88 88
query62 656 467 449 449
query63 307 277 280 277
query64 9614 7259 7196 7196
query65 3122 3029 3040 3029
query66 1373 345 341 341
query67 15575 15023 15010 15010
query68 4559 542 527 527
query69 479 302 306 302
query70 1154 1073 1086 1073
query71 400 272 299 272
query72 7805 2603 2341 2341
query73 699 323 319 319
query74 6503 6102 6200 6102
query75 3438 2644 2591 2591
query76 2726 941 1048 941
query77 412 256 260 256
query78 10734 10189 10012 10012
query79 2382 502 516 502
query80 1019 427 467 427
query81 505 218 218 218
query82 673 99 91 91
query83 236 162 171 162
query84 245 86 84 84
query85 1719 290 258 258
query86 513 297 280 280
query87 3286 3087 3081 3081
query88 4123 2405 2400 2400
query89 477 374 371 371
query90 1998 187 182 182
query91 121 98 100 98
query92 56 47 49 47
query93 2021 512 487 487
query94 1194 179 182 179
query95 392 302 297 297
query96 592 270 263 263
query97 3237 2906 2981 2906
query98 231 224 214 214
query99 1090 914 864 864
Total cold run time: 285712 ms
Total hot run time: 184745 ms
TPC-H: Total hot run time: 41943 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 30b886d372b6ebf995ca030ed624ce461088003c, data reload: false
------ Round 1 ----------------------------------
q1 17641 4295 4293 4293
q2 2017 193 195 193
q3 10451 1215 1207 1207
q4 10200 878 731 731
q5 7495 2696 2675 2675
q6 219 140 134 134
q7 1003 601 622 601
q8 9234 2141 2101 2101
q9 9200 6765 6754 6754
q10 9173 3962 3859 3859
q11 451 247 249 247
q12 485 222 229 222
q13 18300 3210 3185 3185
q14 256 213 205 205
q15 522 473 472 472
q16 516 427 397 397
q17 971 738 775 738
q18 8327 7913 7667 7667
q19 6836 1549 1542 1542
q20 640 328 335 328
q21 5414 4279 4104 4104
q22 365 292 288 288
Total cold run time: 119716 ms
Total hot run time: 41943 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4582 4394 4388 4388
q2 375 276 278 276
q3 3177 3027 2818 2818
q4 1869 1611 1668 1611
q5 5517 5499 5521 5499
q6 212 125 126 125
q7 2338 1996 2003 1996
q8 3245 3398 3390 3390
q9 8650 8778 8545 8545
q10 3969 3814 3891 3814
q11 603 517 506 506
q12 805 635 623 623
q13 17094 3144 3157 3144
q14 311 257 276 257
q15 526 460 464 460
q16 475 423 438 423
q17 1783 1483 1495 1483
q18 7633 7489 7308 7308
q19 1649 1522 1529 1522
q20 1941 1739 1770 1739
q21 9742 4767 4701 4701
q22 590 498 500 498
Total cold run time: 77086 ms
Total hot run time: 55126 ms
TPC-DS: Total hot run time: 187603 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 30b886d372b6ebf995ca030ed624ce461088003c, data reload: false
query1 931 363 346 346
query2 7469 2313 2249 2249
query3 6649 219 208 208
query4 23159 21318 21167 21167
query5 4107 409 417 409
query6 284 191 189 189
query7 4597 294 295 294
query8 267 202 185 185
query9 8548 2404 2384 2384
query10 438 248 250 248
query11 14798 14177 14162 14162
query12 140 91 87 87
query13 1644 382 384 382
query14 8805 7779 8641 7779
query15 255 173 166 166
query16 8049 271 264 264
query17 1726 553 547 547
query18 2103 292 268 268
query19 303 149 149 149
query20 91 85 84 84
query21 193 134 126 126
query22 5006 4904 4835 4835
query23 34361 33634 33653 33634
query24 6539 2806 2923 2806
query25 554 372 363 363
query26 686 160 156 156
query27 1941 325 333 325
query28 4089 2059 2046 2046
query29 851 608 624 608
query30 221 156 156 156
query31 976 729 737 729
query32 87 52 56 52
query33 483 253 241 241
query34 892 499 478 478
query35 778 685 673 673
query36 1018 892 900 892
query37 107 64 70 64
query38 2930 2814 2795 2795
query39 1634 1579 1549 1549
query40 193 129 127 127
query41 42 39 39 39
query42 103 97 97 97
query43 552 554 545 545
query44 1063 720 736 720
query45 261 254 259 254
query46 1072 711 730 711
query47 1935 1874 1863 1863
query48 368 295 294 294
query49 847 396 393 393
query50 784 401 382 382
query51 6865 6840 6764 6764
query52 100 88 92 88
query53 354 292 296 292
query54 539 442 428 428
query55 74 73 72 72
query56 235 224 218 218
query57 1216 1150 1140 1140
query58 210 197 199 197
query59 3428 3270 3176 3176
query60 267 239 244 239
query61 90 86 90 86
query62 630 457 461 457
query63 310 296 297 296
query64 8414 7353 7307 7307
query65 3164 3095 3107 3095
query66 781 347 333 333
query67 15174 14928 15002 14928
query68 4498 545 537 537
query69 459 300 303 300
query70 1186 1063 1132 1063
query71 354 273 277 273
query72 7170 2727 2493 2493
query73 707 327 335 327
query74 6462 6038 6147 6038
query75 3290 2657 2685 2657
query76 2295 997 1040 997
query77 390 272 273 272
query78 10877 10257 10245 10245
query79 3129 514 515 514
query80 2109 460 458 458
query81 535 222 226 222
query82 1519 100 98 98
query83 316 174 182 174
query84 280 91 96 91
query85 1279 324 311 311
query86 458 307 310 307
query87 3297 3088 3150 3088
query88 4340 2432 2448 2432
query89 496 406 390 390
query90 2040 201 195 195
query91 138 208 99 99
query92 62 48 50 48
query93 2849 506 507 506
query94 1203 188 188 188
query95 404 313 317 313
query96 599 268 266 266
query97 3132 3008 2969 2969
query98 240 222 204 204
query99 1257 892 906 892
Total cold run time: 274150 ms
Total hot run time: 187603 ms
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TPC-H: Total hot run time: 40110 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b41a5b5cc60fbe20f9b2d9e01e90ececc99442bc, data reload: false
------ Round 1 ----------------------------------
q1 17615 4419 4269 4269
q2 2012 193 187 187
q3 10490 1265 1283 1265
q4 10549 801 813 801
q5 7637 2679 2728 2679
q6 216 133 135 133
q7 1015 608 574 574
q8 9322 2107 2090 2090
q9 9101 6660 6605 6605
q10 9095 3694 3692 3692
q11 465 246 240 240
q12 455 209 211 209
q13 17774 2962 2983 2962
q14 263 223 228 223
q15 506 475 479 475
q16 510 401 383 383
q17 958 719 698 698
q18 8031 7578 7381 7381
q19 3312 1541 1464 1464
q20 641 316 313 313
q21 5036 3192 3210 3192
q22 349 275 288 275
Total cold run time: 115352 ms
Total hot run time: 40110 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4385 4208 4220 4208
q2 385 280 266 266
q3 2972 2781 2713 2713
q4 1871 1602 1628 1602
q5 5257 5333 5267 5267
q6 206 123 123 123
q7 2256 1909 1867 1867
q8 3185 3301 3354 3301
q9 8417 8329 8331 8329
q10 3890 3668 3714 3668
q11 585 489 506 489
q12 762 584 595 584
q13 16393 2948 2982 2948
q14 292 253 278 253
q15 511 483 483 483
q16 468 412 428 412
q17 1766 1488 1477 1477
q18 7515 7469 7422 7422
q19 1636 1562 1568 1562
q20 1929 1762 1780 1762
q21 4878 4800 4736 4736
q22 594 481 470 470
Total cold run time: 70153 ms
Total hot run time: 53942 ms
TPC-DS: Total hot run time: 188045 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 b41a5b5cc60fbe20f9b2d9e01e90ececc99442bc, data reload: false
query1 908 373 346 346
query2 6442 2425 2365 2365
query3 6657 215 213 213
query4 24093 21305 21173 21173
query5 4209 420 418 418
query6 256 182 172 172
query7 4589 289 288 288
query8 245 196 183 183
query9 8609 2431 2435 2431
query10 453 260 255 255
query11 14756 14173 14294 14173
query12 134 88 87 87
query13 1642 366 376 366
query14 9813 8390 8449 8390
query15 260 167 169 167
query16 8170 262 264 262
query17 1865 540 536 536
query18 2106 277 269 269
query19 273 151 146 146
query20 94 86 83 83
query21 194 130 131 130
query22 5136 4831 4825 4825
query23 34288 33571 33555 33555
query24 12040 2827 2883 2827
query25 641 362 357 357
query26 1731 158 158 158
query27 2888 319 330 319
query28 7478 2085 2069 2069
query29 1028 652 619 619
query30 292 152 153 152
query31 979 773 784 773
query32 92 53 55 53
query33 760 253 247 247
query34 1015 474 478 474
query35 820 690 684 684
query36 1094 919 934 919
query37 260 67 69 67
query38 2923 2782 2774 2774
query39 1637 1549 1553 1549
query40 278 125 124 124
query41 41 38 39 38
query42 102 95 95 95
query43 592 575 534 534
query44 1211 719 734 719
query45 267 240 259 240
query46 1074 732 715 715
query47 1967 1912 1869 1869
query48 382 304 291 291
query49 1194 397 395 395
query50 775 401 389 389
query51 6794 6748 6612 6612
query52 105 86 91 86
query53 348 295 274 274
query54 987 440 440 440
query55 75 71 71 71
query56 239 222 237 222
query57 1256 1149 1184 1149
query58 221 203 197 197
query59 3388 3281 3169 3169
query60 254 231 232 231
query61 93 89 90 89
query62 680 485 469 469
query63 310 280 280 280
query64 9768 7331 7348 7331
query65 3115 3083 3096 3083
query66 1383 344 339 339
query67 15253 15102 15053 15053
query68 4544 525 539 525
query69 477 297 302 297
query70 1165 1129 1122 1122
query71 397 274 269 269
query72 7420 2572 2366 2366
query73 706 321 326 321
query74 6510 6151 6157 6151
query75 3327 2625 2634 2625
query76 2620 1035 1014 1014
query77 430 258 258 258
query78 10556 10221 10130 10130
query79 1697 511 502 502
query80 1071 439 426 426
query81 510 216 227 216
query82 1173 95 92 92
query83 237 161 157 157
query84 236 85 85 85
query85 1260 271 312 271
query86 413 291 290 290
query87 3276 3062 3108 3062
query88 3309 2433 2447 2433
query89 471 369 382 369
query90 1934 189 184 184
query91 123 96 97 96
query92 64 53 47 47
query93 1630 505 491 491
query94 1260 184 179 179
query95 395 316 293 293
query96 593 273 269 269
query97 3145 3032 3021 3021
query98 240 215 215 215
query99 1129 917 891 891
Total cold run time: 285340 ms
Total hot run time: 188045 ms
TeamCity be ut coverage result: Function Coverage: 35.66% (8988/25208) Line Coverage: 27.32% (74284/271951) Region Coverage: 26.55% (38394/144606) Branch Coverage: 23.36% (19578/83794) Coverage Report: http://coverage.selectdb-in.cc/coverage/983aa76082b7d8486d1fd34f1947e75c9e481381_983aa76082b7d8486d1fd34f1947e75c9e481381/report/index.html
TeamCity be ut coverage result: Function Coverage: 35.67% (8989/25200) Line Coverage: 27.33% (74309/271927) Region Coverage: 26.56% (38403/144589) Branch Coverage: 23.38% (19588/83786) Coverage Report: http://coverage.selectdb-in.cc/coverage/ddc0ca625a89d62cf798a54ed6f080fbb6164677_ddc0ca625a89d62cf798a54ed6f080fbb6164677/report/index.html
TPC-H: Total hot run time: 41844 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ddc0ca625a89d62cf798a54ed6f080fbb6164677, data reload: false
------ Round 1 ----------------------------------
q1 17608 4435 4227 4227
q2 2012 195 191 191
q3 10459 1159 1178 1159
q4 10200 836 788 788
q5 7469 2720 2772 2720
q6 229 128 133 128
q7 1012 582 590 582
q8 9225 2129 2094 2094
q9 9556 6700 6734 6700
q10 9081 3861 3885 3861
q11 461 240 236 236
q12 461 237 220 220
q13 17429 3311 3169 3169
q14 266 218 219 218
q15 536 493 466 466
q16 530 405 392 392
q17 982 721 765 721
q18 8328 7980 7795 7795
q19 2887 1581 1524 1524
q20 639 316 310 310
q21 5237 4069 4192 4069
q22 360 280 274 274
Total cold run time: 114967 ms
Total hot run time: 41844 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4503 4321 4344 4321
q2 372 261 275 261
q3 3152 2933 2963 2933
q4 1964 1629 1610 1610
q5 5386 5491 5469 5469
q6 204 121 120 120
q7 2346 1946 1991 1946
q8 3239 3414 3410 3410
q9 8655 8595 8672 8595
q10 4003 3799 3820 3799
q11 605 494 505 494
q12 794 656 621 621
q13 15858 3122 3125 3122
q14 299 286 284 284
q15 518 489 481 481
q16 499 447 432 432
q17 1806 1535 1457 1457
q18 7632 7524 7318 7318
q19 1778 1577 1530 1530
q20 1979 1753 1788 1753
q21 5077 4997 4987 4987
q22 564 467 474 467
Total cold run time: 71233 ms
Total hot run time: 55410 ms
TPC-DS: Total hot run time: 186475 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 ddc0ca625a89d62cf798a54ed6f080fbb6164677, data reload: false
query1 911 373 343 343
query2 6894 2259 2182 2182
query3 6649 204 206 204
query4 23221 21240 21172 21172
query5 4130 427 430 427
query6 257 176 170 170
query7 4579 317 289 289
query8 238 189 195 189
query9 8587 2417 2386 2386
query10 433 256 252 252
query11 14643 14251 14150 14150
query12 142 91 107 91
query13 1633 387 370 370
query14 9751 6848 8188 6848
query15 235 169 168 168
query16 7708 256 258 256
query17 1735 580 536 536
query18 1918 282 268 268
query19 204 148 148 148
query20 93 84 87 84
query21 188 130 126 126
query22 5068 4942 4899 4899
query23 34039 33756 33494 33494
query24 6701 2894 2917 2894
query25 547 374 365 365
query26 709 160 154 154
query27 2057 326 330 326
query28 3921 2099 2047 2047
query29 839 614 606 606
query30 244 154 153 153
query31 956 748 727 727
query32 89 51 54 51
query33 484 245 243 243
query34 863 486 484 484
query35 747 663 656 656
query36 1046 905 944 905
query37 102 71 68 68
query38 2895 2750 2737 2737
query39 1618 1554 1556 1554
query40 197 127 131 127
query41 43 40 43 40
query42 107 97 99 97
query43 579 543 541 541
query44 1135 732 740 732
query45 266 265 254 254
query46 1068 704 714 704
query47 1981 1906 1932 1906
query48 389 307 302 302
query49 820 390 397 390
query50 783 390 386 386
query51 6854 6704 6829 6704
query52 102 92 94 92
query53 354 294 285 285
query54 531 442 459 442
query55 73 72 72 72
query56 247 231 224 224
query57 1261 1142 1127 1127
query58 225 204 206 204
query59 3559 3214 3202 3202
query60 269 233 244 233
query61 92 116 88 88
query62 585 467 476 467
query63 313 288 294 288
query64 8382 7395 7332 7332
query65 3084 3044 3096 3044
query66 805 352 346 346
query67 15730 14990 14866 14866
query68 4590 547 538 538
query69 495 308 312 308
query70 1201 1075 1124 1075
query71 365 285 279 279
query72 7434 2700 2490 2490
query73 698 328 327 327
query74 6475 6171 6089 6089
query75 3287 2681 2668 2668
query76 2285 996 978 978
query77 402 278 278 278
query78 10666 10324 10174 10174
query79 2295 522 531 522
query80 1073 472 450 450
query81 509 223 221 221
query82 640 92 95 92
query83 258 177 175 175
query84 255 94 92 92
query85 1529 328 316 316
query86 490 303 316 303
query87 3288 3133 3143 3133
query88 3938 2338 2354 2338
query89 492 377 379 377
query90 2016 192 193 192
query91 139 107 112 107
query92 69 53 51 51
query93 2445 537 517 517
query94 1210 192 194 192
query95 401 320 311 311
query96 584 275 275 275
query97 3123 3000 2967 2967
query98 244 224 223 223
query99 1175 931 900 900
Total cold run time: 270979 ms
Total hot run time: 186475 ms
TPC-H: Total hot run time: 41809 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ddc0ca625a89d62cf798a54ed6f080fbb6164677, data reload: false
------ Round 1 ----------------------------------
q1 17607 4222 4202 4202
q2 2011 192 196 192
q3 10453 1212 1182 1182
q4 10189 829 770 770
q5 7472 2714 2746 2714
q6 217 130 133 130
q7 1040 614 597 597
q8 9238 2153 2093 2093
q9 9153 6729 6700 6700
q10 9932 3886 3837 3837
q11 452 248 250 248
q12 493 237 230 230
q13 17217 3157 3263 3157
q14 271 236 220 220
q15 510 463 454 454
q16 493 385 387 385
q17 975 717 684 684
q18 8299 7682 7708 7682
q19 2805 1556 1529 1529
q20 658 312 310 310
q21 5277 4216 4328 4216
q22 367 282 277 277
Total cold run time: 115129 ms
Total hot run time: 41809 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4689 4348 4380 4348
q2 366 265 266 265
q3 3150 2865 2883 2865
q4 1900 1574 1554 1554
q5 5390 5465 5463 5463
q6 206 122 125 122
q7 2339 2002 1997 1997
q8 3254 3387 3388 3387
q9 8654 8666 8695 8666
q10 3941 3726 3868 3726
q11 593 508 489 489
q12 803 625 627 625
q13 16024 3156 3136 3136
q14 309 268 293 268
q15 535 465 495 465
q16 495 428 434 428
q17 1801 1477 1461 1461
q18 7752 7579 7569 7569
q19 1641 1555 1551 1551
q20 1977 1751 1767 1751
q21 10058 4950 4836 4836
q22 580 481 491 481
Total cold run time: 76457 ms
Total hot run time: 55453 ms
TPC-DS: Total hot run time: 186581 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 ddc0ca625a89d62cf798a54ed6f080fbb6164677, data reload: false
query1 903 361 339 339
query2 6427 2364 2272 2272
query3 6634 207 208 207
query4 22970 21135 21260 21135
query5 4159 407 403 403
query6 253 170 170 170
query7 4578 295 292 292
query8 240 188 195 188
query9 8564 2400 2364 2364
query10 430 246 256 246
query11 14793 14108 14180 14108
query12 130 87 85 85
query13 1630 371 354 354
query14 8815 8626 7781 7781
query15 278 164 171 164
query16 8069 265 260 260
query17 1766 548 532 532
query18 2087 272 268 268
query19 204 145 144 144
query20 93 91 87 87
query21 201 129 130 129
query22 5017 4885 4864 4864
query23 34216 33587 33425 33425
query24 6502 2915 2903 2903
query25 552 365 396 365
query26 690 153 152 152
query27 2043 320 317 317
query28 4377 2057 2049 2049
query29 845 608 589 589
query30 220 157 153 153
query31 947 775 747 747
query32 93 50 52 50
query33 470 243 243 243
query34 890 484 486 484
query35 751 684 672 672
query36 1042 879 913 879
query37 106 68 69 68
query38 2921 2762 2731 2731
query39 1628 1553 1551 1551
query40 200 129 124 124
query41 43 43 40 40
query42 104 100 97 97
query43 594 562 567 562
query44 1105 717 745 717
query45 275 256 257 256
query46 1055 745 715 715
query47 2017 1887 1904 1887
query48 369 295 302 295
query49 852 401 406 401
query50 772 409 384 384
query51 6954 6715 6738 6715
query52 105 91 93 91
query53 349 284 279 279
query54 515 418 431 418
query55 83 73 73 73
query56 237 217 217 217
query57 1224 1150 1134 1134
query58 218 214 196 196
query59 3474 3262 3418 3262
query60 260 233 237 233
query61 95 90 88 88
query62 622 496 479 479
query63 359 294 297 294
query64 8428 7374 7286 7286
query65 3122 3051 3075 3051
query66 767 347 340 340
query67 15310 14908 15268 14908
query68 4579 532 537 532
query69 472 302 300 300
query70 1179 1141 1094 1094
query71 361 273 260 260
query72 7167 2555 2383 2383
query73 707 331 325 325
query74 6522 6019 6156 6019
query75 3295 2636 2627 2627
query76 2316 968 948 948
query77 374 263 259 259
query78 10688 9980 10101 9980
query79 2433 514 506 506
query80 1034 431 435 431
query81 506 216 223 216
query82 762 89 91 89
query83 246 168 168 168
query84 247 82 86 82
query85 1032 302 362 302
query86 444 275 289 275
query87 3357 3153 3126 3126
query88 3948 2330 2321 2321
query89 459 372 376 372
query90 2029 185 190 185
query91 123 98 96 96
query92 56 51 47 47
query93 1908 521 500 500
query94 1096 176 181 176
query95 383 309 293 293
query96 581 266 265 265
query97 3190 2981 2997 2981
query98 244 206 216 206
query99 1164 909 905 905
Total cold run time: 268944 ms
Total hot run time: 186581 ms
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In regression-test/pipeline/performance/run-clickbench.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 50:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 51:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 52:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 53:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 54:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 57:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 58:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 60:
echo "#### Run clickbench test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 61:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 62:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 63:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 65:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 66:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 67:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 69:
host="127.0.0.1"
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 70:
query_port=$(get_doris_conf_value "${DORIS_HOME}"/fe/conf/fe.conf query_port)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 71:
backup_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/backup_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 72:
opt_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/opt_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 74:
echo "#### 1. backup session variables to file ${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 75:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 76:
backup_session_variables() {
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 77:
_IFS="${IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 78:
IFS=$'\n'
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 79:
while read -r line; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 80:
if [[ -z "${line}" || "${line}" == "#"* ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 81:
k="${line/set global /}"
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 82:
k="${k%=*}"
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 83:
v=$(mysql -h"${host}" -P"${query_port}" -uroot -e"show variables like '${k}'\G" | grep " Value: ")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 84:
v="${v/*Value: /}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 85:
echo "set global ${k}=${v};" >>"${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 87:
IFS="${_IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 89:
backup_session_variables
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 91:
echo "#### 2. optimize doris config"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 92:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/fe_custom.conf "${DORIS_HOME}"/fe/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 93:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/be_custom.conf "${DORIS_HOME}"/be/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 94:
target_branch="$(echo "${target_branch}" | sed 's| ||g;s|\.||g;s|-||g')" # remove space、dot、hyphen from branch name
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 95:
sed -i "s|^meta_dir=/data/doris-meta-\${branch_name}|meta_dir=/data/doris-meta-${target_branch}|g" "${DORIS_HOME}"/fe/conf/fe_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 96:
sed -i "s|^storage_root_path=/data/doris-storage-\${branch_name}|storage_root_path=/data/doris-storage-${target_branch}|g" "${DORIS_HOME}"/be/conf/be_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 97:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 99:
echo "#### 3. optimize session variables"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 100:
cat "${opt_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 101:
mysql -h"${host}" -P"${query_port}" -uroot -e"source ${opt_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 103:
echo "#### 4. check data rows"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 104:
data_home="/data/clickbench" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 105:
db_name="clickbench"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 106:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 107:
echo "INFO: need to load clickbench data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 108:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 110:
mkdir -p "${data_home}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 113:
mysql -h"${host}" -P"${query_port}" -uroot -e "DROP DATABASE IF EXISTS ${db_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 114:
mysql -h"${host}" -P"${query_port}" -uroot -e "CREATE DATABASE IF NOT EXISTS ${db_name}" && sleep 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 115:
mysql -h"${host}" -P"${query_port}" -uroot "${db_name}" -e"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 227:
echo "####load data"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 228:
if [[ ! -f "${data_home}"/hits.tsv ]] || [[ $(wc -c "${data_home}"/hits.tsv | awk '{print $1}') != '74807831229' ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 229:
cd "${data_home}"
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 230:
wget --continue 'https://datasets.clickhouse.com/hits_compatible/hits.tsv.gz'
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 231:
gzip -d hits.tsv.gz
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 232:
if ${DEBUG:-false}; then head -n 10000 hits.tsv >hits.tsv.10000; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 233:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 235:
data_file_name="${data_home}/hits.tsv"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 236:
if ${DEBUG:-false}; then data_file_name="${data_home}/hits.tsv.10000"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 237:
echo "start loading ..."
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 238:
START=$(date +%s)
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 239:
curl --location-trusted \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 245:
END=$(date +%s)
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 246:
LOADTIME=$(echo "${END} - ${START}" | bc)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 247:
echo "INFO: ClickBench Load data costs ${LOADTIME} seconds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 248:
echo "${LOADTIME}" >clickbench_loadtime
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 250:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 251:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 253:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 256:
echo "#### 5. run clickbench query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 257:
sed -i '/^run_sql \"analyze table hits with sync;\"/d' "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 258:
bash "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 259:
cold_run_time_threshold=${cold_run_time_threshold_master:-120} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 260:
hot_run_time_threshold=${hot_run_time_threshold_master:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 261:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 262:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-110} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 263:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 265:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 267:
if ! check_clickbench_performance_result result.csv; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 268:
if ! (cd clickbench && bash check-query-result.sh && cd -); then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 269:
cold_run_sum=$(awk -F ',' '{sum+=$2} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 270:
best_hot_run_sum=$(awk -F ',' '{if($3<$4){sum+=$3}else{sum+=$4}} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 271:
comment_body_summary="Total hot run time: ${best_hot_run_sum} s"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 272:
comment_body_detail="ClickBench test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 274:
$(sed 's|,|\t|g' result.csv)
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 278:
echo "#### 6. comment result on clickbench"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 279:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 280:
create_an_issue_comment_clickbench "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 281:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 282:
echo -e "INFO: Restore session variables \n$(cat "${backup_session_variables_file}")"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 283:
mysql -h"${host}" -P"${query_port}" -uroot -e "source ${backup_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 284:
rm -f "${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 286:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 288:
echo "#### 7. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 289:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 290:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 291:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 292:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 293:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 294:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 298:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 61:
echo "#### Run tpcds test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 75:
TPCDS_DATA_DIR="/data/tpcds/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 76:
TPCDS_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/tpcds-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 77:
db_name="tpcds_sf${SF}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 80:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 81:
echo "INFO: need to load tpcds-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 84:
mkdir -p "${TPCDS_DATA_DIR}"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 86:
cd "${TPCDS_DATA_DIR}" || exit 1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 88:
if [[ ${SF} == "1" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 89:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=1 ['customer']=1 ['web_returns']=1 ['catalog_returns']=1 ['store_returns']=1 ['inventory']=10 ['web_sales']=1 ['catalog_sales']=1 ['store_sales']=1)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 90:
elif [[ ${SF} == "100" ]]; then
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 91:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=10 ['customer']=10 ['web_returns']=10 ['catalog_returns']=10 ['store_returns']=10 ['inventory']=10 ['web_sales']=10 ['catalog_sales']=10 ['store_sales']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 93:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 94:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 95:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_1_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 96:
if [[ -f ${table_name}_1_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 98:
if ! gzip -d "${table_name}_1_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_1_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 99:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 100:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 101:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 102:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_${i}_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 103:
if [[ -f ${table_name}_${i}_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 104:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 105:
if ! gzip -d "${table_name}_${i}_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_${i}_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 108:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 113:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/create-tpcds-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 114:
rm -rf "${TPCDS_DATA_DIR_LINK}"
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 115:
ln -s "${TPCDS_DATA_DIR}" "${TPCDS_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 116:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/load-tpcds-data.sh -c 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 117:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 118:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 120:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 121:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 122:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 125:
echo "#### 3. run tpcds-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 126:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 127:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/run-tpcds-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpcds-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 128:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 129:
cold_run_time_threshold=${cold_run_time_threshold_master:-315000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 130:
hot_run_time_threshold=${hot_run_time_threshold_master:-190000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 131:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 132:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-370000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 133:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-260000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 135:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 136:
if ! check_tpcds_result "${teamcity_build_checkoutDir}"/run-tpcds-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 137:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 138:
line_begin=$((line_end - 100))
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 139:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 140:
comment_body_detail="TPC-DS sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 142:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 144:
echo "#### 4. comment result on tpcds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 145:
comment_body_summary=$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 146:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 147:
create_an_issue_comment_tpcds "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 148:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 150:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 152:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 153:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 154:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 155:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 156:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 157:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 158:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 162:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 61:
echo "#### Run tpch test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 75:
TPCH_DATA_DIR="/data/tpch/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 76:
TPCH_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/tpch-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 77:
db_name="tpch_sf${SF}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 80:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 81:
echo "INFO: need to load tpch-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 84:
mkdir -p "${TPCH_DATA_DIR}"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 86:
cd "${TPCH_DATA_DIR}" || exit 1
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 88:
table_file_count=(['region']=1 ['nation']=1 ['supplier']=1 ['customer']=1 ['part']=1 ['partsupp']=10 ['orders']=10 ['lineitem']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 89:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 90:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 91:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 92:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 93:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 94:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 95:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 96:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl.${i}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 100:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 105:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/create-tpch-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 106:
rm -rf "${TPCH_DATA_DIR_LINK}"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 107:
ln -s "${TPCH_DATA_DIR}" "${TPCH_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 108:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/load-tpch-data.sh -c 2
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 109:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 110:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 112:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 113:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 114:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 117:
echo "#### 3. run tpch-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 118:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 119:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 120:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 121:
cold_run_time_threshold=${cold_run_time_threshold_master:-120000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 122:
hot_run_time_threshold=${hot_run_time_threshold_master:-42000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 123:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 124:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-130000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 125:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-55000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 127:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 128:
if ! check_tpch_result "${teamcity_build_checkoutDir}"/run-tpch-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 129:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 130:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 131:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 132:
comment_body_detail="Tpch sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 135:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 137:
echo "#### 4. run tpch-sf${SF} query with runtime_filter_mode=off"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 138:
set_session_variable runtime_filter_mode off
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 139:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 140:
if ! grep '^Total hot run time' "${teamcity_build_checkoutDir}"/run-tpch-queries.log >/dev/null; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 141:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 142:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 143:
comment_body_detail="${comment_body_detail}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 146:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 148:
echo "#### 5. comment result on tpch"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 149:
comment_body_summary="$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 150:
comment_body_detail="$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 151:
create_an_issue_comment_tpch "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 152:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 154:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 156:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 157:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 158:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 159:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 160:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 161:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 162:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 166:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.
TeamCity be ut coverage result: Function Coverage: 35.67% (8983/25182) Line Coverage: 27.33% (74268/271775) Region Coverage: 26.56% (38369/144464) Branch Coverage: 23.37% (19566/83710) Coverage Report: http://coverage.selectdb-in.cc/coverage/1592087d2dc4361b0fb1d6d4578e121c73b1ad32_1592087d2dc4361b0fb1d6d4578e121c73b1ad32/report/index.html
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In regression-test/pipeline/performance/run-clickbench.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 50:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 51:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 52:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 53:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 54:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 57:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 58:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 60:
echo "#### Run clickbench test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 61:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 62:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 63:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 65:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 66:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 67:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 69:
host="127.0.0.1"
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 70:
query_port=$(get_doris_conf_value "${DORIS_HOME}"/fe/conf/fe.conf query_port)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 71:
backup_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/backup_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 72:
opt_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/opt_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 74:
echo "#### 1. backup session variables to file ${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 75:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 76:
backup_session_variables() {
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 77:
_IFS="${IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 78:
IFS=$'\n'
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 79:
while read -r line; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 80:
if [[ -z "${line}" || "${line}" == "#"* ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 81:
k="${line/set global /}"
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 82:
k="${k%=*}"
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 83:
v=$(mysql -h"${host}" -P"${query_port}" -uroot -e"show variables like '${k}'\G" | grep " Value: ")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 84:
v="${v/*Value: /}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 85:
echo "set global ${k}=${v};" >>"${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 87:
IFS="${_IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 89:
backup_session_variables
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 91:
echo "#### 2. optimize doris config"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 92:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/fe_custom.conf "${DORIS_HOME}"/fe/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 93:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/be_custom.conf "${DORIS_HOME}"/be/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 94:
target_branch="$(echo "${target_branch}" | sed 's| ||g;s|\.||g;s|-||g')" # remove space、dot、hyphen from branch name
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 95:
sed -i "s|^meta_dir=/data/doris-meta-\${branch_name}|meta_dir=/data/doris-meta-${target_branch}|g" "${DORIS_HOME}"/fe/conf/fe_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 96:
sed -i "s|^storage_root_path=/data/doris-storage-\${branch_name}|storage_root_path=/data/doris-storage-${target_branch}|g" "${DORIS_HOME}"/be/conf/be_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 97:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 99:
echo "#### 3. optimize session variables"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 100:
cat "${opt_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 101:
mysql -h"${host}" -P"${query_port}" -uroot -e"source ${opt_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 103:
echo "#### 4. check data rows"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 104:
data_home="/data/clickbench" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 105:
db_name="clickbench"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 106:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 107:
echo "INFO: need to load clickbench data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 108:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 110:
mkdir -p "${data_home}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 113:
mysql -h"${host}" -P"${query_port}" -uroot -e "DROP DATABASE IF EXISTS ${db_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 114:
mysql -h"${host}" -P"${query_port}" -uroot -e "CREATE DATABASE IF NOT EXISTS ${db_name}" && sleep 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 115:
mysql -h"${host}" -P"${query_port}" -uroot "${db_name}" -e"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 227:
echo "####load data"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 228:
if [[ ! -f "${data_home}"/hits.tsv ]] || [[ $(wc -c "${data_home}"/hits.tsv | awk '{print $1}') != '74807831229' ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 229:
cd "${data_home}"
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 230:
wget --continue 'https://datasets.clickhouse.com/hits_compatible/hits.tsv.gz'
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 231:
gzip -d hits.tsv.gz
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 232:
if ${DEBUG:-false}; then head -n 10000 hits.tsv >hits.tsv.10000; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 233:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 235:
data_file_name="${data_home}/hits.tsv"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 236:
if ${DEBUG:-false}; then data_file_name="${data_home}/hits.tsv.10000"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 237:
echo "start loading ..."
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 238:
START=$(date +%s)
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 239:
curl --location-trusted \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 245:
END=$(date +%s)
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 246:
LOADTIME=$(echo "${END} - ${START}" | bc)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 247:
echo "INFO: ClickBench Load data costs ${LOADTIME} seconds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 248:
echo "${LOADTIME}" >clickbench_loadtime
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 250:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 251:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 253:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 256:
echo "#### 5. run clickbench query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 257:
sed -i '/^run_sql \"analyze table hits with sync;\"/d' "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 258:
bash "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 259:
cold_run_time_threshold=${cold_run_time_threshold_master:-120} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 260:
hot_run_time_threshold=${hot_run_time_threshold_master:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 261:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 262:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-110} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 263:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 265:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 267:
if ! check_clickbench_performance_result result.csv; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 268:
if ! (cd clickbench && bash check-query-result.sh && cd -); then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 269:
cold_run_sum=$(awk -F ',' '{sum+=$2} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 270:
best_hot_run_sum=$(awk -F ',' '{if($3<$4){sum+=$3}else{sum+=$4}} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 271:
comment_body_summary="Total hot run time: ${best_hot_run_sum} s"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 272:
comment_body_detail="ClickBench test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 274:
$(sed 's|,|\t|g' result.csv)
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 278:
echo "#### 6. comment result on clickbench"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 279:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 280:
create_an_issue_comment_clickbench "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 281:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 282:
echo -e "INFO: Restore session variables \n$(cat "${backup_session_variables_file}")"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 283:
mysql -h"${host}" -P"${query_port}" -uroot -e "source ${backup_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 284:
rm -f "${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 286:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 288:
echo "#### 7. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 289:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 290:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 291:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 292:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 293:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 294:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 298:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 61:
echo "#### Run tpcds test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 75:
TPCDS_DATA_DIR="/data/tpcds/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 76:
TPCDS_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/tpcds-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 77:
db_name="tpcds_sf${SF}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 80:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 81:
echo "INFO: need to load tpcds-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 84:
mkdir -p "${TPCDS_DATA_DIR}"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 86:
cd "${TPCDS_DATA_DIR}" || exit 1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 88:
if [[ ${SF} == "1" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 89:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=1 ['customer']=1 ['web_returns']=1 ['catalog_returns']=1 ['store_returns']=1 ['inventory']=10 ['web_sales']=1 ['catalog_sales']=1 ['store_sales']=1)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 90:
elif [[ ${SF} == "100" ]]; then
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 91:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=10 ['customer']=10 ['web_returns']=10 ['catalog_returns']=10 ['store_returns']=10 ['inventory']=10 ['web_sales']=10 ['catalog_sales']=10 ['store_sales']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 93:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 94:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 95:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_1_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 96:
if [[ -f ${table_name}_1_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 98:
if ! gzip -d "${table_name}_1_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_1_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 99:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 100:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 101:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 102:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_${i}_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 103:
if [[ -f ${table_name}_${i}_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 104:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 105:
if ! gzip -d "${table_name}_${i}_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_${i}_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 108:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 113:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/create-tpcds-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 114:
rm -rf "${TPCDS_DATA_DIR_LINK}"
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 115:
ln -s "${TPCDS_DATA_DIR}" "${TPCDS_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 116:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/load-tpcds-data.sh -c 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 117:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 118:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 120:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 121:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 122:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 125:
echo "#### 3. run tpcds-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 126:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 127:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/run-tpcds-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpcds-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 128:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 129:
cold_run_time_threshold=${cold_run_time_threshold_master:-315000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 130:
hot_run_time_threshold=${hot_run_time_threshold_master:-190000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 131:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 132:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-370000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 133:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-260000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 135:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 136:
if ! check_tpcds_result "${teamcity_build_checkoutDir}"/run-tpcds-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 137:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 138:
line_begin=$((line_end - 100))
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 139:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 140:
comment_body_detail="TPC-DS sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 142:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 144:
echo "#### 4. comment result on tpcds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 145:
comment_body_summary=$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 146:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 147:
create_an_issue_comment_tpcds "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 148:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 150:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 152:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 153:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 154:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 155:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 156:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 157:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 158:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 162:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 61:
echo "#### Run tpch test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 75:
TPCH_DATA_DIR="/data/tpch/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 76:
TPCH_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/tpch-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 77:
db_name="tpch_sf${SF}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 80:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 81:
echo "INFO: need to load tpch-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 84:
mkdir -p "${TPCH_DATA_DIR}"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 86:
cd "${TPCH_DATA_DIR}" || exit 1
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 88:
table_file_count=(['region']=1 ['nation']=1 ['supplier']=1 ['customer']=1 ['part']=1 ['partsupp']=10 ['orders']=10 ['lineitem']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 89:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 90:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 91:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 92:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 93:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 94:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 95:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 96:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl.${i}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 100:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 105:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/create-tpch-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 106:
rm -rf "${TPCH_DATA_DIR_LINK}"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 107:
ln -s "${TPCH_DATA_DIR}" "${TPCH_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 108:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/load-tpch-data.sh -c 2
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 109:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 110:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 112:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 113:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 114:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 117:
echo "#### 3. run tpch-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 118:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 119:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 120:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 121:
cold_run_time_threshold=${cold_run_time_threshold_master:-120000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 122:
hot_run_time_threshold=${hot_run_time_threshold_master:-42000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 123:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 124:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-130000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 125:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-55000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 127:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 128:
if ! check_tpch_result "${teamcity_build_checkoutDir}"/run-tpch-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 129:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 130:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 131:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 132:
comment_body_detail="Tpch sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 135:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 137:
echo "#### 4. run tpch-sf${SF} query with runtime_filter_mode=off"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 138:
set_session_variable runtime_filter_mode off
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 139:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 140:
if ! grep '^Total hot run time' "${teamcity_build_checkoutDir}"/run-tpch-queries.log >/dev/null; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 141:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 142:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 143:
comment_body_detail="${comment_body_detail}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 146:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 148:
echo "#### 5. comment result on tpch"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 149:
comment_body_summary="$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 150:
comment_body_detail="$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 151:
create_an_issue_comment_tpch "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 152:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 154:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 156:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 157:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 158:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 159:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 160:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 161:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 162:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 166:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.
TeamCity be ut coverage result: Function Coverage: 35.67% (8983/25182) Line Coverage: 27.33% (74273/271775) Region Coverage: 26.57% (38379/144464) Branch Coverage: 23.38% (19568/83710) Coverage Report: http://coverage.selectdb-in.cc/coverage/b43c1d0702e3a8db5af7d81b00d755678da4c0d8_b43c1d0702e3a8db5af7d81b00d755678da4c0d8/report/index.html
sh-checker report
To get the full details, please check in the job output.
shellcheck errors
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In regression-test/pipeline/performance/run-clickbench.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 50:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 51:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 52:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 53:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 54:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 57:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 58:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 60:
echo "#### Run clickbench test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 61:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 62:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 63:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 65:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 66:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 67:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 69:
host="127.0.0.1"
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 70:
query_port=$(get_doris_conf_value "${DORIS_HOME}"/fe/conf/fe.conf query_port)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 71:
backup_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/backup_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 72:
opt_session_variables_file="${teamcity_build_checkoutDir}/regression-test/pipeline/performance/clickbench/conf/opt_session_variables.sql"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 74:
echo "#### 1. backup session variables to file ${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 75:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 76:
backup_session_variables() {
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 77:
_IFS="${IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 78:
IFS=$'\n'
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 79:
while read -r line; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 80:
if [[ -z "${line}" || "${line}" == "#"* ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 81:
k="${line/set global /}"
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 82:
k="${k%=*}"
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 83:
v=$(mysql -h"${host}" -P"${query_port}" -uroot -e"show variables like '${k}'\G" | grep " Value: ")
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 84:
v="${v/*Value: /}"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 85:
echo "set global ${k}=${v};" >>"${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 87:
IFS="${_IFS}"
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 89:
backup_session_variables
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 91:
echo "#### 2. optimize doris config"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 92:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/fe_custom.conf "${DORIS_HOME}"/fe/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 93:
cp -f "${teamcity_build_checkoutDir}"/regression-test/pipeline/performance/clickbench/conf/be_custom.conf "${DORIS_HOME}"/be/conf/
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 94:
target_branch="$(echo "${target_branch}" | sed 's| ||g;s|\.||g;s|-||g')" # remove space、dot、hyphen from branch name
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 95:
sed -i "s|^meta_dir=/data/doris-meta-\${branch_name}|meta_dir=/data/doris-meta-${target_branch}|g" "${DORIS_HOME}"/fe/conf/fe_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 96:
sed -i "s|^storage_root_path=/data/doris-storage-\${branch_name}|storage_root_path=/data/doris-storage-${target_branch}|g" "${DORIS_HOME}"/be/conf/be_custom.conf
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 97:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 99:
echo "#### 3. optimize session variables"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 100:
cat "${opt_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 101:
mysql -h"${host}" -P"${query_port}" -uroot -e"source ${opt_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 103:
echo "#### 4. check data rows"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 104:
data_home="/data/clickbench" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 105:
db_name="clickbench"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 106:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 107:
echo "INFO: need to load clickbench data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 108:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 110:
mkdir -p "${data_home}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 113:
mysql -h"${host}" -P"${query_port}" -uroot -e "DROP DATABASE IF EXISTS ${db_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 114:
mysql -h"${host}" -P"${query_port}" -uroot -e "CREATE DATABASE IF NOT EXISTS ${db_name}" && sleep 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 115:
mysql -h"${host}" -P"${query_port}" -uroot "${db_name}" -e"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 227:
echo "####load data"
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 228:
if [[ ! -f "${data_home}"/hits.tsv ]] || [[ $(wc -c "${data_home}"/hits.tsv | awk '{print $1}') != '74807831229' ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 229:
cd "${data_home}"
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 230:
wget --continue 'https://datasets.clickhouse.com/hits_compatible/hits.tsv.gz'
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 231:
gzip -d hits.tsv.gz
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 232:
if ${DEBUG:-false}; then head -n 10000 hits.tsv >hits.tsv.10000; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 233:
cd -
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 235:
data_file_name="${data_home}/hits.tsv"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 236:
if ${DEBUG:-false}; then data_file_name="${data_home}/hits.tsv.10000"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 237:
echo "start loading ..."
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 238:
START=$(date +%s)
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 239:
curl --location-trusted \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 245:
END=$(date +%s)
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 246:
LOADTIME=$(echo "${END} - ${START}" | bc)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 247:
echo "INFO: ClickBench Load data costs ${LOADTIME} seconds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 248:
echo "${LOADTIME}" >clickbench_loadtime
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 250:
if ! check_clickbench_table_rows "${db_name}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 251:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 253:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 256:
echo "#### 5. run clickbench query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 257:
sed -i '/^run_sql \"analyze table hits with sync;\"/d' "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 258:
bash "${teamcity_build_checkoutDir}"/tools/clickbench-tools/run-clickbench-queries.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 259:
cold_run_time_threshold=${cold_run_time_threshold_master:-120} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 260:
hot_run_time_threshold=${hot_run_time_threshold_master:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 261:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 262:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-110} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 263:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-34} # 单位 秒
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 265:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 267:
if ! check_clickbench_performance_result result.csv; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 268:
if ! (cd clickbench && bash check-query-result.sh && cd -); then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 269:
cold_run_sum=$(awk -F ',' '{sum+=$2} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 270:
best_hot_run_sum=$(awk -F ',' '{if($3<$4){sum+=$3}else{sum+=$4}} END {print sum}' result.csv)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 271:
comment_body_summary="Total hot run time: ${best_hot_run_sum} s"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 272:
comment_body_detail="ClickBench test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 274:
$(sed 's|,|\t|g' result.csv)
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 278:
echo "#### 6. comment result on clickbench"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 279:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 280:
create_an_issue_comment_clickbench "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 281:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 282:
echo -e "INFO: Restore session variables \n$(cat "${backup_session_variables_file}")"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 283:
mysql -h"${host}" -P"${query_port}" -uroot -e "source ${backup_session_variables_file};"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 284:
rm -f "${backup_session_variables_file}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 286:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 288:
echo "#### 7. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 289:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 290:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 291:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 292:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 293:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 294:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-clickbench.sh line 298:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 61:
echo "#### Run tpcds test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 75:
TPCDS_DATA_DIR="/data/tpcds/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 76:
TPCDS_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/tpcds-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 77:
db_name="tpcds_sf${SF}"
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 80:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 81:
echo "INFO: need to load tpcds-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 84:
mkdir -p "${TPCDS_DATA_DIR}"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 86:
cd "${TPCDS_DATA_DIR}" || exit 1
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 88:
if [[ ${SF} == "1" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 89:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=1 ['customer']=1 ['web_returns']=1 ['catalog_returns']=1 ['store_returns']=1 ['inventory']=10 ['web_sales']=1 ['catalog_sales']=1 ['store_sales']=1)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 90:
elif [[ ${SF} == "100" ]]; then
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 91:
table_file_count=(['income_band']=1 ['ship_mode']=1 ['warehouse']=1 ['reason']=1 ['web_site']=1 ['call_center']=1 ['store']=1 ['promotion']=1 ['household_demographics']=1 ['web_page']=1 ['catalog_page']=1 ['time_dim']=1 ['date_dim']=1 ['item']=1 ['customer_demographics']=10 ['customer_address']=10 ['customer']=10 ['web_returns']=10 ['catalog_returns']=10 ['store_returns']=10 ['inventory']=10 ['web_sales']=10 ['catalog_sales']=10 ['store_sales']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 93:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 94:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 95:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_1_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 96:
if [[ -f ${table_name}_1_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 98:
if ! gzip -d "${table_name}_1_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_1_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 99:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 100:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 101:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 102:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpcds/sf${SF}/${table_name}_${i}_10.dat.gz"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 103:
if [[ -f ${table_name}_${i}_10.dat ]]; then continue; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 104:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 105:
if ! gzip -d "${table_name}_${i}_10.dat.gz"; then echo "ERROR: gzip -d ${table_name}_${i}_10.dat.gz" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 108:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 113:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/create-tpcds-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 114:
rm -rf "${TPCDS_DATA_DIR_LINK}"
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 115:
ln -s "${TPCDS_DATA_DIR}" "${TPCDS_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 116:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/load-tpcds-data.sh -c 10
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 117:
if ! check_tpcds_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 118:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 120:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 121:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 122:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 125:
echo "#### 3. run tpcds-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 126:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 127:
bash "${teamcity_build_checkoutDir}"/tools/tpcds-tools/bin/run-tpcds-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpcds-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 128:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 129:
cold_run_time_threshold=${cold_run_time_threshold_master:-315000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 130:
hot_run_time_threshold=${hot_run_time_threshold_master:-190000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 131:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 132:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-370000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 133:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-260000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 135:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 136:
if ! check_tpcds_result "${teamcity_build_checkoutDir}"/run-tpcds-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 137:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 138:
line_begin=$((line_end - 100))
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 139:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 140:
comment_body_detail="TPC-DS sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 142:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpcds-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 144:
echo "#### 4. comment result on tpcds"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 145:
comment_body_summary=$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 146:
comment_body_detail=$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g') # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 147:
create_an_issue_comment_tpcds "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 148:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 150:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 152:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 153:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 154:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 155:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 156:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 157:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 158:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpcds.sh line 162:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 37:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/doris-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 40:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/github-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 43:
source "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/oss-utils.sh
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 45:
if ${DEBUG:-false}; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 46:
pr_num_from_trigger="28431"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 47:
commit_id_from_trigger="5f5c4c80564c76ff4267fc4ce6a5408498ed1ab5"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 48:
target_branch="master"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 49:
SF="1"
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 51:
echo "#### Check env"
^-------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 52:
if [[ -z "${teamcity_build_checkoutDir}" ]]; then echo "ERROR: env teamcity_build_checkoutDir not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 53:
if [[ -z "${pr_num_from_trigger}" ]]; then echo "ERROR: env pr_num_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 54:
if [[ -z "${commit_id_from_trigger}" ]]; then echo "ERROR: env commit_id_from_trigger not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 55:
if [[ -z "${target_branch}" ]]; then echo "ERROR: env target_branch not set" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 58:
source "$(bash "${teamcity_build_checkoutDir}"/regression-test/pipeline/common/get-or-set-tmp-env.sh 'get')"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 59:
if ${skip_pipeline:=false}; then echo "INFO: skip build pipline" && exit 0; else echo "INFO: no skip"; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^---------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 61:
echo "#### Run tpch test on Doris ####"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 62:
DORIS_HOME="${teamcity_build_checkoutDir}/output"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 63:
export DORIS_HOME
^---------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 64:
exit_flag=0
^---------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 66:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 67:
set -e
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 68:
shopt -s inherit_errexit
^----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 70:
echo "#### 1. Restart doris"
^--------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 71:
if ! restart_doris; then echo "ERROR: Restart doris failed" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 73:
echo "#### 2. check if need to load data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 74:
SF=${SF:-"100"} # SCALE FACTOR
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 75:
TPCH_DATA_DIR="/data/tpch/sf_${SF}" # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 76:
TPCH_DATA_DIR_LINK="${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/tpch-data # no / at the end
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 77:
db_name="tpch_sf${SF}"
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 78:
sed -i "s|^export DB=.*$|export DB='${db_name}'|g" \
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 80:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 81:
echo "INFO: need to load tpch-sf${SF} data"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 82:
if ${force_load_data:-false}; then echo "INFO: force_load_data is true"; else echo "ERROR: force_load_data is false" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 84:
mkdir -p "${TPCH_DATA_DIR}"
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 85:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 86:
cd "${TPCH_DATA_DIR}" || exit 1
^--------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 87:
declare -A table_file_count
^-------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 88:
table_file_count=(['region']=1 ['nation']=1 ['supplier']=1 ['customer']=1 ['part']=1 ['partsupp']=10 ['orders']=10 ['lineitem']=10)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 89:
for table_name in ${!table_file_count[*]}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 90:
if [[ ${table_file_count[${table_name}]} -eq 1 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 91:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 92:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 93:
elif [[ ${table_file_count[${table_name}]} -eq 10 ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 94:
(
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 95:
for i in {1..10}; do
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 96:
url="https://doris-build-1308700295.cos.ap-beijing.myqcloud.com/regression/tpch/sf${SF}/${table_name}.tbl.${i}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 97:
if ! wget --continue -t3 -q "${url}"; then echo "ERROR: wget --continue ${url}" && exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 100:
wait
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 105:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/create-tpch-tables.sh -s "${SF}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 106:
rm -rf "${TPCH_DATA_DIR_LINK}"
^----------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 107:
ln -s "${TPCH_DATA_DIR}" "${TPCH_DATA_DIR_LINK}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 108:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/load-tpch-data.sh -c 2
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 109:
if ! check_tpch_table_rows "${db_name}" "${SF}"; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 110:
exit 1
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 112:
echo "INFO: sleep 10min to wait compaction done"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 113:
if ${DEBUG:-false}; then sleep 10s; else sleep 10m; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 114:
data_reload="true"
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 117:
echo "#### 3. run tpch-sf${SF} query"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 118:
set_session_variable runtime_filter_mode global
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 119:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh -s "${SF}" | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 120:
echo
^--^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 121:
cold_run_time_threshold=${cold_run_time_threshold_master:-120000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 122:
hot_run_time_threshold=${hot_run_time_threshold_master:-42000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 123:
if [[ "${target_branch}" == "branch-2.0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 124:
cold_run_time_threshold=${cold_run_time_threshold_branch20:-130000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 125:
hot_run_time_threshold=${hot_run_time_threshold_branch20:-55000} # ms
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 127:
echo "INFO: cold_run_time_threshold is ${cold_run_time_threshold}, hot_run_time_threshold is ${hot_run_time_threshold}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 128:
if ! check_tpch_result "${teamcity_build_checkoutDir}"/run-tpch-queries.log; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 129:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 130:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 131:
comment_body_summary="$(sed -n "${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 132:
comment_body_detail="Tpch sf${SF} test result on commit ${commit_id_from_trigger:-}, data reload: ${data_reload:-"false"}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 135:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 137:
echo "#### 4. run tpch-sf${SF} query with runtime_filter_mode=off"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 138:
set_session_variable runtime_filter_mode off
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 139:
bash "${teamcity_build_checkoutDir}"/tools/tpch-tools/bin/run-tpch-queries.sh | tee "${teamcity_build_checkoutDir}"/run-tpch-queries.log
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 140:
if ! grep '^Total hot run time' "${teamcity_build_checkoutDir}"/run-tpch-queries.log >/dev/null; then exit 1; fi
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 141:
line_end=$(sed -n '/^Total hot run time/=' "${teamcity_build_checkoutDir}"/run-tpch-queries.log)
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 142:
line_begin=$((line_end - 23))
^---------------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 143:
comment_body_detail="${comment_body_detail}
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 146:
$(sed -n "${line_begin},${line_end}p" "${teamcity_build_checkoutDir}"/run-tpch-queries.log)"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 148:
echo "#### 5. comment result on tpch"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 149:
comment_body_summary="$(echo "${comment_body_summary}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 150:
comment_body_detail="$(echo "${comment_body_detail}" | sed -e ':a;N;$!ba;s/\t/\\t/g;s/\n/\\n/g')" # 将所有的 Tab字符替换为\t 换行符替换为\n
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 151:
create_an_issue_comment_tpch "${pr_num_from_trigger:-}" "${comment_body_summary}" "${comment_body_detail}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 152:
rm -f result.csv
^--------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 154:
exit_flag="$?"
^------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 156:
echo "#### 5. check if need backup doris logs"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 157:
if [[ ${exit_flag} != "0" ]]; then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-----------------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 158:
stop_doris
^--------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 159:
print_doris_fe_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 160:
print_doris_be_log
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 161:
if file_name=$(archive_doris_logs "${pr_num_from_trigger}_${commit_id_from_trigger}_$(date +%Y%m%d%H%M%S)_doris_logs.tar.gz"); then
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
^----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 162:
upload_doris_log_to_oss "${file_name}"
^-- SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
In regression-test/pipeline/performance/run-tpch.sh line 166:
exit "${exit_flag}"
^-----------------^ SC2317 (info): Command appears to be unreachable. Check usage (or ignore if invoked indirectly).
For more information:
https://www.shellcheck.net/wiki/SC2317 -- Command appears to be unreachable...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
shfmt errors
'shfmt ' found no issues.