MAN page from Mandrake Other db-2.4.14-1.i386.rpm

DB_DEADLOCK

Section: User Commands (1)
Updated: April 10, 1998
Index

NAME

db_deadlock - the DB database deadlock detector

SYNOPSIS

db_deadlock [-vw] [-a m | o | y] [-h home] [-L file ] [-t sec ]

DESCRIPTION

Thedb_deadlockutility traverses the database lock structures and aborts a transactioneach time it detects a deadlock.This utility should be run as a background daemon whenever multiple threadsor processes are using locking.By default,a random transaction involved in the deadlock is aborted.

The options are as follows:

-a: When a deadlock is detected,abort the oldest (``o'') transaction, the youngest (``y'') transaction,or the transaction with the minimum number of locks (``m'').
-h: Specify a home directory for the database.
-LLog the execution of the db_deadlock utility to the specified file in thefollowing format, where ``###'' is the process ID, and the date isthe time the utility starting running. db_deadlock: ### Wed Jun 15 01:23:45 EDT 1995 This file will be removed if the db_deadlock utility exits gracefully.
-t: Initiate a pass over the database locks at least everysecseconds.
-v: Run in verbose mode, generating messages each time the detector runs.
-w: Make a single pass over the database locks every time a process is forcedto wait for a lock.

At least one of the-tand-woptions must be specified.

Thedb_deadlockutility attaches to DB shared memory regions.In order to avoid region corruption,it should always be given the chance to detach and exit gracefully.To causedb_deadlockto clean up after itself and exit,send it an interrupt signal (SIGINT).

Thedb_deadlockutility exits 0 on success, and >0 if an error occurs.

ENVIRONMENT VARIABLES

The following environment variables affect the execution ofdb_deadlock:

DB_HOMEIf the-hoption is not specified and the environment variableDB_HOMEis set, it is used as the path of the database home, as described indb_appinit(3).

The DB library is a family of classes that provides a modularprogramming interface to transactions and record-oriented file access.The library includes support for transactions, locking, logging and filepage caching, as well as various indexed access methods.Many of the classes (e.g., the file page caching class)are useful independent of the other DB classes,although some classes are explicitly based on other classes(e.g., transactions and logging).For a general description of the DB package, seedb_intro(3).

db_archive(1),db_checkpoint(1),db_deadlock(1),db_dump(1),db_load(1),db_recover(1),db_stat(1),db_intro(3),db_internal(3),db_thread(3),Db(3),Dbc(3),DbEnv(3),DbException(3),DbInfo(3),DbLock(3),DbLockTab(3),DbLog(3),DbLsn(3),DbMpool(3),{DbMpoolFile(3),Dbt(3),DbTxn(3),DbTxnMgr(3)

This document was created byman2html,using the manual pages.