Subject | Re: How to release or kill deadlock process ? |
---|---|
Author | Mohd. Jeffry |
Post date | 2005-08-23T03:51:25Z |
I've already restarted the server but the deadlock count is still the same. :(
On 8/19/05, Mohd. Jeffry <linuxlah@...> wrote:
> Here is my output from fb_lock_print...
>
> LOCK_HEADER BLOCK
> Version: 15, Active owner: 0, Length: 36896768, Used: 36883652
> Lock manager pid: 1958
> Semmask: 0x6904, Flags: 0x0001
> Enqs: 1644978588, Converts: 1144012, Rejects: 7129637, Blocks: 2581127
> Deadlock scans: 313, Deadlocks: 55, Scan interval: 10
> Acquires: 2050345641, Acquire blocks: 294394149, Spin count: 0
> Mutex wait: 14.4%
> Hash slots: 2039, Hash lengths (min/avg/max): 21/ 31/ 46
> Remove node: 0, Insert queue: 0, Insert prior: 0
> Owners (18): forward: 27580, backward: 22061436
> Free owners (61): forward: 22062272, backward: 12176256
> Free locks (110726): forward: 31096816, backward: 4781640
> Free requests (408845): forward: 24276128, backward: 16494776
> Lock Ordering: Enabled
>
> It shows that there are 55 deadlocks. How to troubleshoot this ?
>
> --
> Malaysian Java Online Community ( www.kampungjawa.cjb.net )
>
--
Malaysian Java Online Community ( www.kampungjawa.cjb.net )