diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-06-12 19:02:08 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-06-12 19:08:49 +0300 |
| commit | 56c60b2fc5d006206f54b93be401570837f2f312 (patch) | |
| tree | 10dfeb0fd23648580f2e8b197596e8b7461c04b2 /mysql-test/unstable-tests | |
| parent | efc3cb9322df26e957f55dcd42f679251e273c68 (diff) | |
| download | mariadb-git-56c60b2fc5d006206f54b93be401570837f2f312.tar.gz | |
MDEV-16111 encryption.innodb_lotoftables failed in buildbot with wrong result
Remove the test, because it easily fails with a result difference.
Analysis by Thirunarayanan Balathandayuthapani:
By default, innodb_encrypt_tables=0.
1) Test case creates 100 tables in innodb_encrypt_1.
2) creates another 100 unencrypted tables (encryption=off) in innodb_encrypt_2
3) creates another 100 encrypted tables (encryption=on) in innodb_encrypt_3
4) enabling innodb_encrypt_tables=1 and checking that only
100 encrypted tables exist. (already we have 100 in dictionary)
5) opening all tables again (no idea why)
6) After that, set innodb_encrypt_tables=0 and wait for 100 tables
to be decrypted (already we have 100 unencrypted tables)
7) dropping all databases
Sporadic failure happens because after step 4, it could encrypt the
normal table too, because innodb_encryption_threads=4.
This test was added in MDEV-9931, which was about InnoDB startup being
slow due to all .ibd files being opened. There have been a number of
later fixes to this problem. Currently the latest one is
commit cad56fbabaea7b5dab0ccfbabb98d0a9c61f3dc3, in which some tests
(in particular the test innodb.alter_kill) could fail if all InnoDB
.ibd files are read during startup. That could make this test redundant.
Let us remove the test, because it is big, slow, unreliable, and
does not seem to reliably catch the problem that all files are being
read on InnoDB startup.
Diffstat (limited to 'mysql-test/unstable-tests')
| -rw-r--r-- | mysql-test/unstable-tests | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/mysql-test/unstable-tests b/mysql-test/unstable-tests index b400c4e971e..87f836a84e1 100644 --- a/mysql-test/unstable-tests +++ b/mysql-test/unstable-tests @@ -213,7 +213,6 @@ encryption.innodb_encryption_row_compressed : MDEV-16113 - Crash encryption.innodb_first_page : MDEV-10689 - Crash encryption.innodb-first-page-read : MDEV-14356 - Timeout on wait condition encryption.innodb-force-corrupt : Modified in 10.1.38 -encryption.innodb_lotoftables : MDEV-16111 - Wrong result encryption.innodb-page_encryption : MDEV-10641 - mutex problem encryption.innodb-read-only : MDEV-14728 - Unable to get certificate; MDEV-16563 - Crash on startup encryption.innodb-redo-badkey : MDEV-12898 - Server hang on startup |