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

1. Got to the session manager for the database. SessionsManager.
2. Log onto the LCG (lcgr1) session manager.
3. 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.
4. Click kill.

Typically, you will repeat steps 3 to 4 for every session from the bad machine.

Maintainer: GavinMcCance