An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] RE: Firebird SuperClassic hangs
> On May 9, 2017, at 9:10 AM, Freddy Ertl f.e...@speexx.com [firebird-support]
> <firebird-support@yahoogroups.com> wrote
>
> that's the question, that I have: How to fi
ve said it before, wha transaction isolation level
are you using?
Good luck,
Ann
>
> Best regards
> Freddy Ertl
>
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Dienstag, 9. Mai 2017 15:05
> An: firebird-support@yahoogroups.com
&
<>
Thats what a lock print is for - when it "hangs the next time" get a lock print
fb_lock_print -a -d
@yahoogroups.com]
Gesendet: Dienstag, 9. Mai 2017 15:05
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] RE: Firebird SuperClassic hangs
> Deadlock scans: 289, Deadlocks: 1, Scan interval: 10
Is probably the culprit, 289 deadlock scans, one actual deadlock found
"Deadlo
> Deadlock scans:289, Deadlocks: 1, Scan interval: 10
Is probably the culprit, 289 deadlock scans, one actual deadlock found
"Deadlock scans. The number of times that the lock manager walked a chain of
locks and owners looking for deadlocks. The lock manager initiates a deadlock
With "hang" I really mean stop working, not just slow. There is absolutely
nothing in the log file that indicates an error. It just does not respond
anymore. I also waited a couple of minutes to see if it recovers, but it does
not.
Am 04.05.2017 11:21 nachm. schrieb "'Leyne, Sean'
Thank you for your suggestion. I know that our configuration is not optimal and
I will change this. But my understanding was, that this is only a performance
problem and not something that can cause Firebird to hang. Or is this a known
behavior?
The problem is in the definition of “hang”.
Hi Sean,
Thank you for your suggestion. I know that our configuration is not optimal and
I will change this. But my understanding was, that this is only a performance
problem and not something that can cause Firebird to hang. Or is this a known
behavior?
Cheers
Freddy
Am 04.05.2017 10:07
Freddie,
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 25165824, Used:
24798216
Flags: 0x0001
Enqs: 17157097538, Converts: 22693011, Rejects: 12135777,
Blocks: 93039760
Deadlock scans:289, Deadlocks: 1,