[MDEV-14814] encryption.innodb_encryption-page-compression failed in buildbot with timeout on wait condition Created: 2017-12-29  Updated: 2018-02-25  Resolved: 2018-02-24

Status: Closed
Project: MariaDB Server
Component/s: Encryption, Tests
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: 10.1.32, 10.2.14, 10.3.6

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


 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar/builds/1466/steps/test/logs/stdio

encryption.innodb_encryption-page-compression 'innodb' w4 [ fail ]
        Test ended at 2017-12-29 07:03:30
 
CURRENT_TEST: encryption.innodb_encryption-page-compression
--- /home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/suite/encryption/r/innodb_encryption-page-compression.result	2017-12-28 21:25:20.470138126 -0500
+++ /home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/suite/encryption/r/innodb_encryption-page-compression.reject	2017-12-29 07:03:30.780138124 -0500
@@ -157,12 +157,20 @@
 update innodb_page_compressed7 set c1 = c1 + 1;
 update innodb_page_compressed8 set c1 = c1 + 1;
 update innodb_page_compressed9 set c1 = c1 + 1;
+Timeout in wait_condition.inc for select variable_value > 0 from information_schema.global_status where variable_name = 'INNODB_NUM_PAGES_DECRYPTED'
+Id	User	Host	db	Command	Time	State	Info	Progress
+1	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+2	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+3	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+4	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
+5	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
+9	root	localhost	test	Query	0	init	show full processlist	0.000
 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
 variable_value >= 0
 1
 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
 variable_value > 0
-1
+0
 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
 variable_value > 0
 1
 
mysqltest: Result length mismatch



 Comments   
Comment by Jan Lindström (Inactive) [ 2018-02-16 ]

commit d3fbff38b9e8d6395dccfde4388d46824e7152cd
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Fri Feb 16 08:21:19 2018 +0200

MDEV-14814: encryption.innodb_encryption-page-compression failed in buildbot with timeout on wait condition

Problem is that if pages are in buffer pool there is no need for
decrypt or page decompression operations.

Comment by Marko Mäkelä [ 2018-02-17 ]

The wait condition times out in 10.2 after the merge, and I disabled the test. Please re-enable and fix it.

Comment by Marko Mäkelä [ 2018-02-18 ]

The test is now disabled on 10.1 as well.

Comment by Jan Lindström (Inactive) [ 2018-02-20 ]

commit 7a84688e2c30a95297246b5dc3005854bcbd5bf0
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Sun Feb 18 07:47:47 2018 +0200

MDEV-14814: encryption.innodb_encryption-page-compression failed in buildbot with timeout on wait condition

Test changes only.

Comment by Marko Mäkelä [ 2018-02-20 ]

You did not remove the line from disabled.def, so the test is disabled.
I did a test merge to 10.2, and the test still fails, because it fails to restore the original value of the parameter INNODB_ENCRYPT_TABLES.

Comment by Marko Mäkelä [ 2018-02-23 ]

This has now been merged to 10.2 (not by me), and the test has not been enabled. The test also fails in the same way that it failed for me when I did the test merge:

./mtr --mem --enable-disabled encryption.innodb_encryption-page-compression

10.2.14 e92cc097658405fdb52c80254b933424f8c1f99e

encryption.innodb_encryption-page-compression 'innodb_plugin' [ pass ]   8329
 
MTR's internal check of the test case 'encryption.innodb_encryption-page-compression' failed.
--- /mariadb/10.2/bld/mysql-test/var/tmp/check-mysqld_1.result	2018-02-23 06:30:29.432058238 +0200
+++ /mariadb/10.2/bld/mysql-test/var/tmp/check-mysqld_1.reject	2018-02-23 06:30:37.948351182 +0200
@@ -236,7 +236,7 @@
 INNODB_ENCRYPTION_ROTATION_IOPS	100
 INNODB_ENCRYPTION_THREADS	4
 INNODB_ENCRYPT_LOG	ON
-INNODB_ENCRYPT_TABLES	ON
+INNODB_ENCRYPT_TABLES	OFF
 INNODB_FAKE_CHANGES	OFF
 INNODB_FAST_SHUTDOWN	1
 INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD	600

Comment by Jan Lindström (Inactive) [ 2018-02-24 ]

commit e826d1e64d4c03f2365763f64c180b67ed95bb53
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Sat Feb 24 18:03:41 2018 +0200

MDEV-14814: encryption.innodb_encryption-page-compression failed in buildbot with timeout on wait condition

Fix wrong wait condition.

Generated at Thu Feb 08 08:16:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.