remove the test for MDEV-16962mariadb-10.4.19

after b9d64989 the test for MDEV-16962 is not suitable anymore
(and probably the bug is not reproducible).

2 files changed, 0 insertions, 75 deletions

diff --git a/mysql-test/suite/gcol/r/innodb_virtual_debug_purge.result b/mysql-test/suite/gcol/r/innodb_virtual_debug_purge.result
index 9228a5f63c6..2ed1f917ca6 100644
--- a/mysql-test/suite/gcol/r/innodb_virtual_debug_purge.result
+++ b/mysql-test/suite/gcol/r/innodb_virtual_debug_purge.result
@@ -277,32 +277,4 @@ pk	b	v
 DROP TABLE t1;
 SET debug_sync= reset;
 set global debug_dbug= @old_dbug;
-# MDEV-16962 Assertion '!error || !ot_ctx.can_recover_from_failed_open()'
-# failed in open_purge_table upon concurrent ALTER and FLUSH
-CREATE TABLE t1 (
-pk SERIAL,
-c VARCHAR(128),
-d DATE,
-vd DATE AS (d) VIRTUAL,
-PRIMARY KEY(pk),
-KEY(vd,c)
-) ENGINE=InnoDB;
-INSERT IGNORE INTO t1 (pk,c) VALUES (1,'foo');
-set debug_sync="now WAIT_FOR purge";
-connect  con1,localhost,root,,test;
-SET GLOBAL innodb_debug_sync="after_open_table_mdl_shared SIGNAL purge WAIT_FOR flush";
-SET global debug_dbug="d,ib_purge_virtual_index_callback";
-REPLACE INTO t1 (pk,c) VALUES (1,'bar');
-connection default;
-SET debug_sync="alter_table_before_rename_result_table WAIT_FOR flush";
-ALTER TABLE t1 ADD FULLTEXT KEY(c), ALGORITHM=COPY;
-connection con1;
-SET debug_sync="after_flush_unlock SIGNAL flush ";
-FLUSH TABLES;
-disconnect con1;
-connection default;
-InnoDB		0 transactions not purged
-DROP TABLE t1;
-SET debug_sync= reset;
-SET global debug_dbug=@old_dbug;
 SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;
diff --git a/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test b/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
index da203f118a8..9549c2f0f10 100644
--- a/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
+++ b/mysql-test/suite/gcol/t/innodb_virtual_debug_purge.test
@@ -374,51 +374,4 @@ DROP TABLE t1;
 SET debug_sync= reset;
 set global debug_dbug= @old_dbug;
 
-
---echo # MDEV-16962 Assertion '!error || !ot_ctx.can_recover_from_failed_open()'
---echo # failed in open_purge_table upon concurrent ALTER and FLUSH
-
-CREATE TABLE t1 (
-  pk SERIAL,
-  c VARCHAR(128),
-  d DATE,
-  vd DATE AS (d) VIRTUAL,
-  PRIMARY KEY(pk),
-  KEY(vd,c)
-) ENGINE=InnoDB;
-INSERT IGNORE INTO t1 (pk,c) VALUES (1,'foo');
-
---send
-set debug_sync="now WAIT_FOR purge";
---connect (con1,localhost,root,,test)
-# Will break innodb purge thread inside open_purge_table after mdl
-# acquired, but before tdc->flushed check
-SET GLOBAL innodb_debug_sync="after_open_table_mdl_shared SIGNAL purge WAIT_FOR flush";
-
-# Workaround to pass trx_undo_roll_ptr_is_insert() in 10.2
-SET global debug_dbug="d,ib_purge_virtual_index_callback";
-
-REPLACE INTO t1 (pk,c) VALUES (1,'bar');
-
---connection default
-# wait for MDL acquired by purge
---reap
-# MDL_SHARED will be acquired, but will hang before MDL upgrade started.
-SET debug_sync="alter_table_before_rename_result_table WAIT_FOR flush";
---send
-ALTER TABLE t1 ADD FULLTEXT KEY(c), ALGORITHM=COPY;
---connection con1
-# Will hang after tdc->flushed is set, but before emptying tdc cache.
-SET debug_sync="after_flush_unlock SIGNAL flush ";
-FLUSH TABLES;
-
-# Cleanup
---disconnect con1
---connection default
---reap
---source ../../innodb/include/wait_all_purged.inc
-DROP TABLE t1;
-SET debug_sync= reset;
-SET global debug_dbug=@old_dbug;
-
 SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;