[MDEV-21542] main.order_by_pack_big fails sporadically with wrong result Created: 2020-01-21  Updated: 2020-01-28  Resolved: 2020-01-22

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5
Fix Version/s: 10.5.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Varun Gupta (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-21263 Allow packed values of non-sorted fie... Closed

 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


Generated at Thu Feb 08 09:07:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.