Procedure for dropping the DB locks from given machine
What is it?
This is the procedure for removing the database locks from a given machine. It is CERN specific.
When to run it?
This should only be done in the very specific case of a manual agent failover, when you cannot cleanly stop the primary agent in order to start the backup one.
Procedure
- Got to the session manager for the database. SessionsManager.
- Log onto the LCG (lcgr1) session manager.
- Identify the session you wish to kill. Each session lists the process anme (which will be the agent name) and the machine from which it is connecting to the DB.
- Click kill.
Typically, you will repeat steps 3 to 4 for every session from the bad machine.
Maintainer:
GavinMcCance