mysql-test/main/mdl_sync.test

118 --echo # Check that SNW lock is compatible with it. To do this use ALTER TABLE
119 --echo # which will fail during copying the table and thus obtaining SNW metadata
149 --echo # Check that upgrade from SNW to X is blocked by presence of S lock.
195 --echo # Check that SNW lock is compatible with it. To do this use ALTER TABLE
196 --echo # which will fail during copying the table and thus obtaining SNW metadata
235 --echo # Check that upgrade from SNW to X is blocked by presence of SH lock.
314 --echo # Check that SNW lock is compatible with it. To do this use ALTER TABLE
315 --echo # which will fail during copying the table and thus obtaining SNW metadata
371 --echo # Check that upgrade from SNW to X is blocked by presence of SR lock.
423 --echo # Check that SNW lock is not compatible with SW lock.
425 --echo # the table to avoid upgrade of SNW -> X.
496 --echo # There is no need to check that upgrade from SNW/SNRW to X is
497 --echo # blocked by presence of SW lock because SNW/SNRW is incompatible
598 --echo # Now we have ALTER TABLE with SU->SNW and RENAME TABLE with pending
610 --echo # There is no need to check that upgrade from SNW/SNRW to X is
611 --echo # blocked by presence of another SU lock because SNW/SNRW is
617 --echo # 6) Acquire SNW lock on the table. We have to use DEBUG_SYNC for
618 --echo #    this, to prevent SNW from being immediately upgraded to X.
632 --echo # Check that SW lock is incompatible with SNW lock.
637 --echo # Check that the above DELETE is blocked because of SNW lock.
662 --echo # Check that SU lock is incompatible with SNW lock.
667 --echo # Check that the above ALTER is blocked because of SNW lock.
686 --echo # Note that we can't easily check SNW vs SNW locks since
687 --echo # SNW is only used by ALTER TABLE after upgrading from SU
688 --echo # and SU is also incompatible with SNW.
697 --echo # Check that SNRW lock is incompatible with SNW lock.
702 --echo # Check that the above LOCK TABLES is blocked because of SNW lock.
729 --echo # Check that X lock is incompatible with SNW lock.
734 --echo # Check that the above RENAME is blocked because of SNW lock.
754 --echo # There is no need to check that upgrade from SNW/SNRW to X is
755 --echo # blocked by presence of another SNW lock because SNW/SNRW is
756 --echo # incompatible with SNW anyway.
833 --echo # Note that we can't easily check SNW vs SNRW locks since
834 --echo # SNW is only used by ALTER TABLE after upgrading from SU
885 --echo # There is no need to check that upgrade from SNW/SNRW to X is
886 --echo # blocked by presence of another SNRW lock because SNW/SNRW is
1094 --echo # Note that we can't easily check SNW vs X locks since
1095 --echo # SNW is only used by ALTER TABLE after upgrading from SU
1190 --echo # 1) Check compatibility for pending SNW lock.
1192 --echo # Acquire SW lock in order to create pending SNW lock later.
1197 --echo # Add pending SNW lock.
1202 --echo # Check that ALTER TABLE is waiting with pending SNW lock.
1208 --echo # Check that S, SH and SR locks are compatible with pending SNW
1214 --echo # Check that SW is incompatible with pending SNW
1219 --echo # Check that the above DELETE is blocked because of pending SNW lock.
1237 --echo # We can't do similar check for SNW, SNRW and X locks because
1342 --echo # Check that SNW is compatible with pending SNRW
1504 --echo # Check that SNW is incompatible with pending X
1584 --echo #    context interact with active/pending SNW lock.
1592 --echo # Create an active SNW lock on t2.
1593 --echo # We have to use DEBUG_SYNC facility as otherwise SNW lock
1635 --echo #    locked in SNW mode acquires yet another SR lock and then tries
1641 --echo # Create an active SNW lock on t1.
1650 --echo # Since the above ALTER TABLE is not upgrading SNW lock to X by waiting
1677 --echo #     against which there is pending SNW lock acquires SR and SW
1684 --echo # Create pending SNW lock on t1.
1689 --echo # Wait until ALTER TABLE starts waiting for SNW lock.
1708 --echo # 2) Now similar tests for active SNW lock which is being upgraded
1717 --echo # Start transaction which will prevent SNW -> X upgrade from
1723 --echo # Create SNW lock pending upgrade to X on t2.
1761 --echo # Start transaction which will prevent SNW -> X upgrade from
1767 --echo # Create SNW lock pending upgrade to X on t2.
1808 --echo # Create SNW lock pending upgrade to X.
2431 --echo # Ensure that ALTER waits once it has acquired SNW lock.
2438 --echo # Wait till ALTER acquires SNW lock and stops.
2460 --echo # Add a new request for SNW lock to waiting graph.
2478 --echo # for SW lock; which is not granted because of pending SNW lock from
2480 --echo # for SW and SNW locks have same weight ALTER was selected as a victim
2522 --echo # SNW locks on t1 and t2 and wait till SELECT closes t1.
2560 --echo # SNW locks on t1 and t2 and wait on debug sync point.
2612 --echo # SNW locks on t2 and wait till SELECT closes t2.
2685 --echo # SNW locks on t1 and t2, open table t1 and block on the debug
2712 --echo # Such reopen should not cause releasing of SNW metadata locks
3496 --echo # Start ALTER TABLE which will acquire SNW lock and
3520 --echo # Unblock ALTER TABLE. Since it will try to upgrade SNW to X lock
4084 --echo # We need EXECUTE 2 since ALTER TABLE does SU => SNW => X and we want