[MDEV-8209] encryption.encrypt_and_grep fails in buildbot and outside Created: 2015-05-22  Updated: 2015-05-26  Resolved: 2015-05-26

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: 10.1.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/2493/steps/test/logs/stdio

encryption.encrypt_and_grep 'xtradb'     w1 [ fail ]
 
        Test ended at 2015-05-21 18:17:28
 
 
 
CURRENT_TEST: encryption.encrypt_and_grep
 
--- /opt/buildbot-slave/mariadb/dan_demeter2/build/mysql-test/suite/encryption/r/encrypt_and_grep.result	2015-05-21 11:29:18.561315509 +0300
 
+++ /opt/buildbot-slave/mariadb/dan_demeter2/build/mysql-test/suite/encryption/r/encrypt_and_grep.reject	2015-05-21 18:17:28.771705446 +0300
 
@@ -21,7 +21,7 @@
 
 # t1 yes on expecting NOT FOUND
 
 NOT FOUND /foobar/ in t1.ibd
 
 # t2 ... on expecting FOUND
 
-FOUND /temp/ in t2.ibd
 
+NOT FOUND /temp/ in t2.ibd
 
 # t3 no  on expecting FOUND
 
 FOUND /dummy/ in t3.ibd
 
 # ibdata1 expecting NOT FOUND
 
@@ -33,7 +33,7 @@
 
 # t1 yes on expecting NOT FOUND
 
 NOT FOUND /foobar/ in t1.ibd
 
 # t2 ... on expecting NOT FOUND
 
-NOT FOUND /temp/ in t2.ibd
 
+FOUND /temp/ in t2.ibd
 
 # t3 no  on expecting FOUND
 
 FOUND /dummy/ in t3.ibd
 
 # ibdata1 expecting NOT FOUND
 
 
 
mysqltest: Result content mismatch

Fails for me locally as well, but sporadically – sometimes at line 24, sometimes at line 36, sometimes both.

 Comments   
Comment by Jan Lindström (Inactive) [ 2015-05-22 ]

Repeating the problem does not seem to be very easy:

jan@jan-GE70-0NC-0ND ~/mysql/10.1-encryption/mysql-test $ ./mysql-test-run --vardir=/dev/shm encrypt_and_grep --parallel=4 --repeat=10
 
Logging: ./mysql-test-run  --vardir=/dev/shm encrypt_and_grep --parallel=4 --repeat=10
 
 
 
 
 
==============================================================================
 
 
 
TEST                                  WORKER RESULT   TIME (ms) or COMMENT
 
--------------------------------------------------------------------------
 
 
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
 
worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
 
worker[2] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
 
worker[4] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  18383
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  18392
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12295
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12296
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12286
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12285
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  18002
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  18004
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12318
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12352
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12362
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12399
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12289
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12292
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12306
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12375
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12301
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12311
 
encryption.encrypt_and_grep 'xtradb'     w3 [ pass ]  12387
 
encryption.encrypt_and_grep 'innodb_plugin' w1 [ pass ]  12410
 
--------------------------------------------------------------------------
 
The servers were restarted 0 times
 
Spent 270.045 of 147 seconds executing testcases

Comment by Jan Lindström (Inactive) [ 2015-05-22 ]

Perro with 20 iterations does not repeat, decreasing the priority.

Comment by Elena Stepanova [ 2015-05-22 ]

We've had over 50 buildbot failures in the last 4 days, so it being not reproducible on Perro does not really make it any less important.
Please feel free to set the priority as you like, but fix it.
Besides, if something does not get encrypted only on certain machines, it makes the problem even more important, since it's harder to catch.

Comment by Elena Stepanova [ 2015-05-25 ]

In fact, it fails just fine on perro.
I created a setup in the usual manner, please feel free to use it. 

cd mdev8209/mysql-test
 
perl ./mtr encryption.encrypt_and_grep --repeat=10

1st run: 8 failures out of 20 tests.
2nd run: 15 railures out of 20 tests.

Output of these runs can be found in mdev8209/mysql-test/test.out and mdev8209/mysql-test/test2.out

It's a normal debug build (cmake . -DCMAKE_BUILD_TYPE=Debug).

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