Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
-
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
|
Attachments
Activity
The wait condition times out in 10.2 after the merge, and I disabled the test. Please re-enable and fix it.
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.
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.
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
|
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.
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 conditionProblem is that if pages are in buffer pool there is no need for
decrypt or page decompression operations.