Schema lock held by a user that is no longer in the database
|Title||Schema lock held by a user that is no longer in the database|
OS: Windows 2012 R2
|Steps to Reproduce||1. Start DB on DB server
2. Start client on client server and connect to DB remotely.
for each customer exclusive:
3. Cut the network
If using VM, the network interface can be disabled.
4. New client trying to hold a lock on this table will get error 2624.
5. promon will show the transaction is still active and FWD.
|Error Message||<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)|
|Last Modified Date||1/3/2020 1:58 PM|