Bug #87294 Test innodb.undo_encrypt_bootstrap is unstable
Submitted: 3 Aug 2017 8:08 Modified: 27 Nov 2017 14:12
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: encryption, innodb, mtr

[3 Aug 2017 8:08] Laurynas Biveinis
Description:
innodb.undo_encrypt_bootstrap fails in one of two ways intermittently:

1)

innodb.undo_encrypt_bootstrap            [ fail ]
        Test ended at 2017-08-03 10:49:42

CURRENT_TEST: innodb.undo_encrypt_bootstrap
--- /Users/laurynas/percona/mysql-8.0.2/mysql-test/suite/innodb/r/undo_encrypt_bootstrap.result	2017-06-27 14:00:43.000000000 +0300
+++ /Users/laurynas/percona/obj-mysql-8.0.2-asan-debug-openssl/mysql-test/var/log/undo_encrypt_bootstrap.reject	2017-08-03 10:49:41.000000000 +0300
@@ -27,6 +27,8 @@
 300	aaaaa
 400	bbbbb
 UNINSTALL PLUGIN keyring_file;
+Warnings:
+Warning	1620	Plugin is busy and will be uninstalled on shutdown
 DROP TABLE tab1;
 Pattern "lCB" found
 Pattern "lCB" found

mysqltest: Result length mismatch

2)

innodb.undo_encrypt_bootstrap            [ fail ]  Found warnings/errors in server log file!
        Test ended at 2017-08-03 11:03:55
line
2017-08-03T08:03:47.255765Z 0 [ERROR] InnoDB: Can't rotate encryption on undo tablespace number 1.
2017-08-03T08:03:47.255855Z 0 [ERROR] InnoDB: Can't rotate encryption on undo tablespace number 2.
^ Found warnings in /Users/laurynas/percona/obj-mysql-8.0.2-asan-debug-openssl/mysql-test/var/log/mysqld.1.err

How to repeat:
Mac, CMake options for these particular runs are -DBUILD_CONFIG=mysql_release -DWITH_DEBUG=ON -DWITH_ASAN=ON -DWITH_BOOST=... -DWITH_OPENSSL=/path/to/homebrew/OpenSSL -DWITH_ZLIB=system -DWITH_LZ4=system -DENABLE_DOWNLOADS=ON

./mtr --debug-server undo_encrypt_bootstrap --repeat=50 --big-test
(here it fails on ~10th-20th attempt)
[3 Aug 2017 8:19] MySQL Verification Team
Hello Laurynas,

Thank you for the report.

Thanks,
Umesh
[27 Nov 2017 14:12] Paul DuBois
Posted by developer:
 
Fixed in 8.0.4, 9.0.0.

Work was done for test suite. No changelog entry needed.