Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39704

mroonga tests fail sporadically with a wrong result

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • N/A
    • 13.1
    • Tests, MTR
    • None

    Description

      Note:
      These tests fail non-deterministically, run with --repeat=N. They usually fail for me within 5-10 attempts on a plain debug build (no sanitizers), but it can vary on different machines and builds.

      While it is apparently only a test problem, and if so, not even the fault of the new feature but the tests are written in a non-deterministic way (no sufficient result sorting), still, they have to be fixed before the feature can be released, otherwise they will be causing problems in the buildbot, where they are now failing frequently.

      There may be more tests like this, so far I've encountered two.

      bb-blob-monty 4d3e5d05080a4663ec33dea982ce4022c12a86ed

      mroonga/storage.fulltext_order_boolean_mode_different_against [ pass ]     35
      mroonga/storage.fulltext_order_boolean_mode_different_against [ 2 pass ]      9
      mroonga/storage.fulltext_order_boolean_mode_different_against [ 3 pass ]     14
      mroonga/storage.fulltext_order_boolean_mode_different_against [ 4 fail ]
              Test ended at 2026-05-21 18:05:56
       
      CURRENT_TEST: mroonga/storage.fulltext_order_boolean_mode_different_against
      --- /share8t/bld/testing/bb-blob-monty-debug/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_boolean_mode_different_against.result  2026-05-20 16:55:19.335569197 +0300
      +++ /share8t/bld/testing/bb-blob-monty-debug/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_boolean_mode_different_against.reject  2026-05-21 18:05:56.415758811 +0300
      @@ -18,6 +18,6 @@
       ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE);
       title  score
       Start mroonga  0
      -Start groonga  1
       Start groonga and Ruby 1
      +Start groonga  1
       DROP TABLE diaries;
       
      Result content mismatch
      

      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ pass ]     48
      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ 2 pass ]      9
      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ 3 pass ]     14
      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ 4 pass ]     10
      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ 5 pass ]     10
      mroonga/storage.fulltext_order_boolean_mode_same_match_against [ 6 fail ]
              Test ended at 2026-05-21 18:10:00
       
      CURRENT_TEST: mroonga/storage.fulltext_order_boolean_mode_same_match_against
      --- /share8t/bld/testing/bb-blob-monty-debug/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_boolean_mode_same_match_against.result 2026-05-20 16:55:19.335569197 +0300
      +++ /share8t/bld/testing/bb-blob-monty-debug/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_boolean_mode_same_match_against.reject 2026-05-21 18:09:59.870711674 +0300
      @@ -17,6 +17,6 @@
       WHERE    MATCH(title) AGAINST("groonga" IN BOOLEAN MODE)
       ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE);
       title  score
      -Start groonga  1
       Start groonga and Ruby 1
      +Start groonga  1
       DROP TABLE diaries;
       
      Result content mismatch
      

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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