mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
c75bee9478
Remove calls to wsrep_append_fk_parent_table() during REPAIR/OPTIMIZE TABLE processing. It turns out that REPAIR or OPTIMIZE commands on table t, do not acquire MDL locks on parent tables of t (as shown in the included test). Thus making wsrep_append_fk_parent_table() unnecessary for OPTIMIZE and REPAIR. This also fixes MDEV-24446 and reenables test galera.mysql-wsrep#198. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
29 lines
748 B
Text
29 lines
748 B
Text
#
|
|
# MDL BF-BF lock conflict
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_debug_sync.inc
|
|
--source include/galera_have_debug_sync.inc
|
|
|
|
# sync point controlling session
|
|
--connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
|
|
--connection node_1a
|
|
SET SESSION wsrep_sync_wait=0;
|
|
|
|
# secondary conflicting DML victim session
|
|
--connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
|
|
--connection node_1b
|
|
SET SESSION wsrep_sync_wait=0;
|
|
|
|
--let $table_admin_command = ALTER
|
|
--let $table_admin_command_end = ENGINE=INNODB
|
|
--source galera_ddl_fk_conflict.inc
|
|
|
|
--let $table_admin_command = TRUNCATE
|
|
--let $table_admin_command_end =
|
|
--source galera_ddl_fk_conflict.inc
|
|
|
|
# CHECK and ANALYZE are not affected
|
|
|