Procedure for dropping the DB locks froma 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. This is accessible from https://uimon.cern.ch/twiki/bin/view/PSSGroup/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.
5. If you cannot find a particular session, check the other DB instance in the LCG RAC, LCG (lcgr2) from the other session manager.

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

Last edit: GavinMcCance on 2006-05-15 - 13:42

Maintainer: GavinMcCance