diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-25 14:03:20 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-25 14:03:20 +0200 |
| commit | 71e10ba3bbda3f969df9c2918c3c1598c940638c (patch) | |
| tree | b1b2a328e1e53769334e5a812e7230999f04df20 | |
| parent | 3cfbfa58de20057c07ddcc066b6eb4956f77c9e1 (diff) | |
| download | mariadb-git-71e10ba3bbda3f969df9c2918c3c1598c940638c.tar.gz | |
Make innodb.innodb-table-online more stable
Occasionally, the test would fail with a result difference for
ddl_log_file_alter_table (0 instead of 1) due to some
nondeterminism in the test. Let us remove that nondeterminism.
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-table-online.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb-table-online.test | 5 |
2 files changed, 3 insertions, 4 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-table-online.result b/mysql-test/suite/innodb/r/innodb-table-online.result index 9ef5316e17d..91d9b355125 100644 --- a/mysql-test/suite/innodb/r/innodb-table-online.result +++ b/mysql-test/suite/innodb/r/innodb-table-online.result @@ -202,10 +202,10 @@ SET lock_wait_timeout = 10; ALTER TABLE t1 ROW_FORMAT=COMPACT PAGE_COMPRESSED = YES PAGE_COMPRESSION_LEVEL = 1, ALGORITHM = INPLACE; connection default; +SET DEBUG_SYNC = 'now WAIT_FOR rebuilt2'; INSERT INTO t1 SELECT 80 + c1, c2, c3 FROM t1; INSERT INTO t1 SELECT 160 + c1, c2, c3 FROM t1; UPDATE t1 SET c2 = c2 + 1; -SET DEBUG_SYNC = 'now WAIT_FOR rebuilt2'; SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl'; name count ddl_background_drop_indexes 0 diff --git a/mysql-test/suite/innodb/t/innodb-table-online.test b/mysql-test/suite/innodb/t/innodb-table-online.test index 978af891157..7ed87fcc26b 100644 --- a/mysql-test/suite/innodb/t/innodb-table-online.test +++ b/mysql-test/suite/innodb/t/innodb-table-online.test @@ -195,13 +195,12 @@ ALTER TABLE t1 ROW_FORMAT=COMPACT PAGE_COMPRESSED = YES PAGE_COMPRESSION_LEVEL = 1, ALGORITHM = INPLACE; # Generate some log (delete-mark, delete-unmark, insert etc.) -# while the index creation is blocked. Some of this may run -# in parallel with the clustered index scan. +# while the index creation is blocked. connection default; +SET DEBUG_SYNC = 'now WAIT_FOR rebuilt2'; INSERT INTO t1 SELECT 80 + c1, c2, c3 FROM t1; INSERT INTO t1 SELECT 160 + c1, c2, c3 FROM t1; UPDATE t1 SET c2 = c2 + 1; -SET DEBUG_SYNC = 'now WAIT_FOR rebuilt2'; # At this point, the clustered index scan must have completed, # but the modification log keeps accumulating due to the DEBUG_SYNC. eval $innodb_metrics_select; |