Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6164

basic.cal_named_udfs test is unstable

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • Tests
    • None
    • 2025-8

    Description

      basic.cal_named_udfs fails randomly in Jenkins https://server-test.mariadb.net/?product_ids=2&show_skipped_results=false&only_last_commits=false&time_interval=-2&dates=2025-08-05T21%3A00%3A00.000Z&dates=2026-02-27T22%3A00%3A00.000Z&test_name=columnstore&commit_id=&columnstore_commit_id=&target_name=&ci_service_ids=9&runs_with_additional_tools=false

      and locally - running MTR with --repeat=10000 gives a number of random failures

       
      columnstore/basic.cal_named_udfs         [ 1319 pass ]    326
      columnstore/basic.cal_named_udfs         [ 1320 pass ]    337
      columnstore/basic.cal_named_udfs         [ 1321 fail ]
              Test ended at 2025-09-08 23:17:04
       
      CURRENT_TEST: columnstore/basic.cal_named_udfs
      --- /usr/share/mariadb-test/plugin/columnstore/columnstore/basic/r/cal_named_udfs.result	2025-08-07 14:43:37.000000000 +0200
      +++ /usr/share/mariadb-test/plugin/columnstore/columnstore/basic/r/cal_named_udfs.reject	2025-09-08 23:17:04.039115200 +0200
      @@ -28,6 +28,6 @@
       0
       select calgetsqlcount();
       calgetsqlcount()
      -Running SQL statements 0, Waiting SQL statments 0
      +Running SQL statements 1, Waiting SQL statments 0
       DROP TABLE t1;
       DROP DATABASE cal_test_db;
       
      Result content mismatch
       
       - skipping '/var/tmp/mtr/log/columnstore/basic.cal_named_udfs/'
      worker[01] > Restart  - not started
      columnstore/basic.cal_named_udfs         [ 1322 pass ]    345
      columnstore/basic.cal_named_udfs         [ 1323 pass ]    326
      columnstore/basic.cal_named_udfs         [ 1324 pass ]    327
      columnstore/basic.cal_named_udfs         [ 1325 pass ]    320
      columnstore/basic.cal_named_udfs         [ 1326 pass ]    332
      columnstore/basic.cal_named_udfs         [ 1327 pass ]    316
      columnstore/basic.cal_named_udfs         [ 1328 pass ]    316
      columnstore/basic.cal_named_udfs         [ 1329 pass ]    330
      columnstore/basic.cal_named_udfs         [ 1330 pass ]    321
      columnstore/basic.cal_named_udfs         [ 1331 pass ]    318
      columnstore/basic.cal_named_udfs         [ 1332 pass ]    313
      columnstore/basic.cal_named_udfs         [ 1333 pass ]    325
      columnstore/basic.cal_named_udfs         [ 1334 pass ]    311
      columnstore/basic.cal_named_udfs         [ 1335 pass ]    320
      columnstore/basic.cal_named_udfs         [ 1336 pass ]    320
      columnstore/basic.cal_named_udfs         [ 1337 pass ]    313
      columnstore/basic.cal_named_udfs         [ 1338 pass ]    341
      columnstore/basic.cal_named_udfs         [ 1339 pass ]    314
      columnstore/basic.cal_named_udfs         [ 1340 pass ]    323
      columnstore/basic.cal_named_udfs         [ 1341 pass ]    321
      columnstore/basic.cal_named_udfs         [ 1342 pass ]    335
      columnstore/basic.cal_named_udfs         [ 1343 pass ]    324
      columnstore/basic.cal_named_udfs         [ 1344 pass ]    316
      columnstore/basic.cal_named_udfs         [ 1345 pass ]    315
      columnstore/basic.cal_named_udfs         [ 1346 pass ]    320
      columnstore/basic.cal_named_udfs         [ 1347 pass ]    317
      columnstore/basic.cal_named_udfs         [ 1348 pass ]    316
      columnstore/basic.cal_named_udfs         [ 1349 pass ]    319
      columnstore/basic.cal_named_udfs         [ 1350 pass ]    319
      columnstore/basic.cal_named_udfs         [ 1351 pass ]    312
      columnstore/basic.cal_named_udfs         [ 1352 pass ]    321
      columnstore/basic.cal_named_udfs         [ 1353 pass ]    310
      columnstore/basic.cal_named_udfs         [ 1354 pass ]    319
      columnstore/basic.cal_named_udfs         [ 1355 pass ]    332
      columnstore/basic.cal_named_udfs         [ 1356 pass ]    319
      columnstore/basic.cal_named_udfs         [ 1357 pass ]    341
      columnstore/basic.cal_named_udfs         [ 1358 pass ]    332
      columnstore/basic.cal_named_udfs         [ 1359 pass ]    328
      columnstore/basic.cal_named_udfs         [ 1360 pass ]    340
      columnstore/basic.cal_named_udfs         [ 1361 fail ]
              Test ended at 2025-09-08 23:17:20
       
      CURRENT_TEST: columnstore/basic.cal_named_udfs
      --- /usr/share/mariadb-test/plugin/columnstore/columnstore/basic/r/cal_named_udfs.result	2025-08-07 14:43:37.000000000 +0200
      +++ /usr/share/mariadb-test/plugin/columnstore/columnstore/basic/r/cal_named_udfs.reject	2025-09-08 23:17:20.476310229 +0200
      @@ -28,6 +28,6 @@
       0
       select calgetsqlcount();
       calgetsqlcount()
      -Running SQL statements 0, Waiting SQL statments 0
      +Running SQL statements 1, Waiting SQL statments 0
       DROP TABLE t1;
       DROP DATABASE cal_test_db;
       
      Result content mismatch
       
       - skipping '/var/tmp/mtr/log/columnstore/basic.cal_named_udfs/'
      worker[01] > Restart  - not started
      columnstore/basic.cal_named_udfs         [ 1362 pass ]    345
      columnstore/basic.cal_named_udfs         [ 1363 pass ]    337
      columnstore/basic.cal_named_udfs         [ 1364 pass ]    329
      
      

      Attachments

        Issue Links

          Activity

            People

              tturenko Timofey Turenko
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.