Firebird News

Friday, May 23, 2008

geting firebird locks

sudo /usr/lib/firebird/2.1/bin/fb_lock_print
[sudo] password for xxxx:
LOCK_HEADER BLOCK
Version: 244, Active owner: 0, Length: 1048576, Used: 25208
Semmask: 0x0, Flags: 0x0001
Enqs: 1530, Converts: 0, Rejects: 342, Blocks: 42
Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
Acquires: 0, Acquire blocks: 60060822667264, Spin count: 0
Mutex wait: inf%
Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 0
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners: *empty*
Free owners (9): forward: 20848, backward: 21040
Free locks (21): forward: 24384, backward: 21752
Free requests (20): forward: 23872, backward: 21560
Lock Ordering: Enabled

Event log:
DEL_OWNER: owner = 20848, lock = 20848, request = 0
DEL_OWNER: owner = 22200, lock = 22200, request = 0
DEL_OWNER: owner = 21368, lock = 21368, request = 0
DEL_OWNER: owner = 21040, lock = 21040, request = 0


The tool for checking the lock table is fb_lock_print, which is a command line utility in the bin directory of the Firebird installation tree. The full lock print describes the entire state of the lock table and is of limited interest. When your system is under load and behaving badly, invoke the utility with no options or switches, directing the output to a file

Read more on this page
http://ibdeveloper.com/issues/issue-2-oct-17-2005/locking-firebird-and-the-lock-table/

.:():..:():..:():.

No comments: