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

Number of topics: 1

Maintainer: GavinMcCance


Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2006-05-15 - GavinMcCance
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback