Subject AW: [firebird-support] Two complicated questions firebird 2.5 cs
Author Olaf Kluge
Post date 2011-09-23T12:14:10Z
Hello Ann,

>I'm sure there's a limit somewhere, varying with operating system
resources,
>but I'm equally sure it's not five. And the normal failure mode when
>there's a conflict (suggested by the IBExpert holding a transaction open)
is
>for the whole system to lock up with nothing using CPU at all. So...

>What are you doing that's different from everyone who's using Classic 2.5
64
>bit on 64 bit Windows? One starting place would be to attach a debugger to
>the process that's using huge amounts of CPU and not finishing. Stop the
>process and get a call stack. Not terribly useful, but better than what
>we've got now. And of course, take the vital signs*. Get a list of the
>header page information (gstat -h is one way). Get a lockprint (look in the
>firebird/bin directory for a file with a name like fb_lock_print.exe. I
>think it prints the lock table header with no switches, but -h should tell
>you what to use) . If you've got a working connection from which you can
>query the MON$ tables check the state of other activity.

>Good luck,

>Ann

many thanks for your help.



I have check that. First, we have closed an application "A". After this, the
5-minutely executing isql-script does not work and hangs (dos-box) The
transactions stops! Oldest for example 500000 and next 510000, a difference
of 10000 but next transaction does not count continuous. The difference can
be a result of our developing with IBEXPERT. At this time, we cannot connect
again or new connect to our database! One fb_inet_server process uses 50%
cpu capacity. If I kill this process, it works fine again!



At this moment I have test this again. But if the Application "A" runs not a
long time, the problem does not occur.



Can you see the problem in the look_print?: What's wrong, that our database
froze?







C:\Users\Administrator>"C:\Program
Files\Firebird\Firebird_2_5\bin\fb_lock_print

.exe" -d d:\datenbank\ilvs.fdb |more

LOCK_HEADER BLOCK

Version: 145, Active owner: 0, Length: 1048576, Used: 127112

Flags: 0x0001

Enqs: 7016370, Converts: 23392, Rejects: 779648, Blocks: 1827

Deadlock scans: 241, Deadlocks: 0, Scan interval: 10

Acquires: 9666334, Acquire blocks: 12198, Spin count: 0

Mutex wait: 0.1%

Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 4

Remove node: 0, Insert queue: 0, Insert prior: 0

Owners (7): forward: 62432, backward: 118952

Free owners (1): forward: 125976, backward: 125976

Free locks (90): forward: 21896, backward: 33016

Free requests (101): forward: 28112, backward: 121176

Lock Ordering: Enabled



OWNER BLOCK 62432

Owner id: 7249904795681, type: 1, pending: 0

Process id: 1688 (Alive), thread id: 2924

Flags: 0x08 wake

Requests (165): forward: 75920, backward: 125016

Blocks: *empty*



OWNER BLOCK 20824

Owner id: 4741643894817, type: 1, pending: 64784

Process id: 1104 (Alive), thread id: 2760

Flags: 0x04 wait infn

Requests (197): forward: 56136, backward: 64784

Blocks: *empty*



OWNER BLOCK 118784

Owner id: 5617817223201, type: 1, pending: 0

Process id: 1308 (Alive), thread id: 1584

Flags: 0x08 wake

Requests (83): forward: 63888, backward: 75984

Blocks: *empty*



OWNER BLOCK 96608

Owner id: 12592844111905, type: 1, pending: 0

Process id: 2932 (Alive), thread id: 676

Flags: 0x18 wake sgnl

Requests (136): forward: 40504, backward: 98576

Blocks (2): forward: 63824, backward: 24488



OWNER BLOCK 82520

Owner id: 2164663517217, type: 1, pending: 35768

Process id: 504 (Alive), thread id: 2704

Flags: 0x04 wait infn

Requests (102): forward: 76496, backward: 35768

Blocks: *empty*



OWNER BLOCK 32520

Owner id: 5274219839521, type: 1, pending: 106728

Process id: 1228 (Alive), thread id: 1696

Flags: 0x04 wait infn

Requests (110): forward: 68224, backward: 106728

Blocks: *empty*

Owner id: 4741643894817, type: 1, pending: 64784

Process id: 1104 (Alive), thread id: 2760

Flags: 0x04 wait infn

Requests (197): forward: 56136, backward: 64784

Blocks: *empty*



OWNER BLOCK 118784

Owner id: 5617817223201, type: 1, pending: 0

Process id: 1308 (Alive), thread id: 1584

Flags: 0x08 wake

Requests (83): forward: 63888, backward: 75984

Blocks: *empty*



OWNER BLOCK 96608

Owner id: 12592844111905, type: 1, pending: 0

Process id: 2932 (Alive), thread id: 676

Flags: 0x18 wake sgnl

Requests (136): forward: 40504, backward: 98576

Blocks (2): forward: 63824, backward: 24488



OWNER BLOCK 82520

Owner id: 2164663517217, type: 1, pending: 35768

Process id: 504 (Alive), thread id: 2704

Flags: 0x04 wait infn

Requests (102): forward: 76496, backward: 35768

Blocks: *empty*



OWNER BLOCK 32520

Owner id: 5274219839521, type: 1, pending: 106728

Process id: 1228 (Alive), thread id: 1696

Flags: 0x04 wait infn

Requests (110): forward: 68224, backward: 106728

Blocks: *empty*



OWNER BLOCK 118952

Owner id: 7782480740385, type: 1, pending: 63568

Process id: 1812 (Alive), thread id: 1112

Flags: 0x04 wait infn

Requests (98): forward: 95912, backward: 63568

Blocks: *empty*



Event log:

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0

DEL_OWNER: owner = 96608, lock = 96608, request = 0

DEL_OWNER: owner = 82520, lock = 82520, request = 0

DEL_OWNER: owner = 32520, lock = 32520, request = 0

DEL_OWNER: owner = 118952, lock = 118952, request = 0

DEL_OWNER: owner = 125976, lock = 125976, request = 0



Thank you!





[Non-text portions of this message have been removed]