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

main.order_by_pack_big fails sporadically with wrong result

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.5
    • Fix Version/s: 10.5.1
    • Component/s: Tests
    • Labels:
      None

      Description

      Out of two consequent runs of a single test, the first one passed for me and the second one failed.

      10.5 f52bf920

      elenst@asus:/data/src/10.5-bug/mysql-test$ perl ./mtr main.order_by_pack_big --mem
      Logging: ./mtr  main.order_by_pack_big --mem
      vardir: /data/src/10.5-bug/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/data/src/10.5-bug/mysql-test/var'...
       - symlinking 'var' to '/dev/shm/var_auto_jIWg'
      Checking supported features...
      MariaDB Version 10.5.1-MariaDB-debug
       - SSL connections supported
       - binaries are debug compiled
       - binaries built with wsrep patch
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      main.order_by_pack_big                   [ pass ]  17868
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 17.868 of 21 seconds executing testcases
       
      Completed: All 1 tests were successful.
       
      elenst@asus:/data/src/10.5-bug/mysql-test$ perl ./mtr main.order_by_pack_big --mem
      Logging: ./mtr  main.order_by_pack_big --mem
      vardir: /data/src/10.5-bug/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/data/src/10.5-bug/mysql-test/var'...
       - symlinking 'var' to '/dev/shm/var_auto_1PV7'
      Checking supported features...
      MariaDB Version 10.5.1-MariaDB-debug
       - SSL connections supported
       - binaries are debug compiled
       - binaries built with wsrep patch
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      main.order_by_pack_big                   [ fail ]
              Test ended at 2020-01-21 03:11:45
       
      CURRENT_TEST: main.order_by_pack_big
      --- /data/src/10.5-bug/mysql-test/main/order_by_pack_big.result	2020-01-21 03:04:23.233725174 +0200
      +++ /data/src/10.5-bug/mysql-test/main/order_by_pack_big.reject	2020-01-21 03:11:45.272192903 +0200
      @@ -130,7 +130,7 @@
       37	49062ade86448805b6a222707bf45ad0
       38	c94368aa13843cc892b75eb71683aaba
       39	483247b82751113caab96ea183a9ca3b
      -40	f6cf9046d05c13ae88ba7a5676b81f89
      +40	4c30f0f56eca5172861966337531e572
       41	1ca6c62cd730db36d49daca2d1b0ec7c
       42	2b519acd4877e780e7200659d01d43af
       43	eb59acd9a1bf374468b4986325ec2b83
      @@ -139,7 +139,7 @@
       46	3c5479be06f2262e8867e967299bbb3b
       47	2084e6be3e7b18019bd874cded1c8bd6
       48	efc7de387fa2399a35a59318052a06f4
      -49	8a734e334febc6f2ca45db6b846be5d4
      +49	4f4b59ce0e1253909693b5f6a7d8c0a9
       50	f53fafc0e8d431be62de75e0f16ee745
       51	53a0f5f1b88776c84fe22e2c3254444c
       52	9b53bc61795233850e5d958a9ba415f5
      @@ -164,7 +164,7 @@
       71	8bdd033aa314600e78585dc42a88c28b
       72	b2b70633781346cfa203e243319f6409
       73	cb158a725e4f3f1ef6f2053751db07d0
      -74	82f3963cfebe83618ea21af5fd38d164
      +74	21bcb99bf1d72f26a0ddda1616feb8fa
       75	cfb9e6e451c6855e1a7dce78d7b4cc5a
       76	eab0e37d16bbc78b21e234767f5056eb
       77	c76407fe3c50d02fba700da0011167cc
      @@ -183,7 +183,7 @@
       90	0414da13cd7ac8cc53ed97f9c12f52a8
       91	b862c11cc516d750ccac6e10436c6746
       92	0e7febc44370fd57a370d3fbdd9bf16c
      -93	85488f13dd47b028a9db94e136eae19d
      +93	895383d23332b50705958bce42b713c7
       94	f9605bb472f52d1775e669b86691e848
       95	33b4d6bc8f327e1a48328d5f5071d7e7
       96	917e41d300faaedfb5d1a67eafa85ef4
      @@ -251,7 +251,7 @@
       37	49062ade86448805b6a222707bf45ad0
       38	c94368aa13843cc892b75eb71683aaba
       39	483247b82751113caab96ea183a9ca3b
      -40	f6cf9046d05c13ae88ba7a5676b81f89
      +40	4c30f0f56eca5172861966337531e572
       41	1ca6c62cd730db36d49daca2d1b0ec7c
       42	2b519acd4877e780e7200659d01d43af
       43	eb59acd9a1bf374468b4986325ec2b83
      @@ -260,7 +260,7 @@
       46	3c5479be06f2262e8867e967299bbb3b
       47	2084e6be3e7b18019bd874cded1c8bd6
       48	efc7de387fa2399a35a59318052a06f4
      -49	8a734e334febc6f2ca45db6b846be5d4
      +49	4f4b59ce0e1253909693b5f6a7d8c0a9
       50	f53fafc0e8d431be62de75e0f16ee745
       51	53a0f5f1b88776c84fe22e2c3254444c
       52	9b53bc61795233850e5d958a9ba415f5
      @@ -285,7 +285,7 @@
       71	8bdd033aa314600e78585dc42a88c28b
       72	b2b70633781346cfa203e243319f6409
       73	cb158a725e4f3f1ef6f2053751db07d0
      -74	82f3963cfebe83618ea21af5fd38d164
      +74	21bcb99bf1d72f26a0ddda1616feb8fa
       75	cfb9e6e451c6855e1a7dce78d7b4cc5a
       76	eab0e37d16bbc78b21e234767f5056eb
       77	c76407fe3c50d02fba700da0011167cc
      @@ -304,7 +304,7 @@
       90	0414da13cd7ac8cc53ed97f9c12f52a8
       91	b862c11cc516d750ccac6e10436c6746
       92	0e7febc44370fd57a370d3fbdd9bf16c
      -93	85488f13dd47b028a9db94e136eae19d
      +93	895383d23332b50705958bce42b713c7
       94	f9605bb472f52d1775e669b86691e848
       95	33b4d6bc8f327e1a48328d5f5071d7e7
       96	917e41d300faaedfb5d1a67eafa85ef4
       
      mysqltest: Result content mismatch
      

      It also failed in my test run on a lab machine, so it's not just a local environment issue.

      The test was added by this commit

      commit f52bf92014efae6a1da9c2f26a7e3792ed5f5396
      Author: Varun Gupta
      Date:   Tue Jan 21 01:37:47 2020 +0530
       
          MDEV-21263: Allow packed values of non-sorted fields in the sort buffer
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              varun Varun Gupta
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: