AW: AW: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-09 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
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

Re: AW: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-09 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
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 &

AW: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-09 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
<> Thats what a lock print is for - when it "hangs the next time" get a lock print fb_lock_print -a -d

AW: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-09 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
@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

RE: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-09 Thread 'Paul Beach' pabe...@waitrose.com [firebird-support]
> 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

RE: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-04 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
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'

RE: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-04 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
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”.

Re: [firebird-support] RE: Firebird SuperClassic hangs

2017-05-04 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
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

[firebird-support] RE: Firebird SuperClassic hangs

2017-05-04 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
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,