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

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

2017-05-09 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
Hi Paul, that's the question, that I have: How to find out what causes the deadlock scans. I have thousands of transactions per minutes, doing all possible kind of things. What to look for? Where? Best regards Freddy Ertl Von: firebird-support@yahoogroups.com

AW: [firebird-support] Firebird SuperClassic hangs

2017-05-09 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
Hi Alexey, I have already changed the configuration, but it didn’t help. What I find strange is the fact, that the memory consumption drops like it would do when you close all connections. See my first description of the problem. And only to be clear when I say hang, basically it locks up

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 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] Firebird SuperClassic hangs

2017-05-04 Thread Freddy Ertl f.e...@speexx.com [firebird-support]
Hi, we're running Firebird 2.5.7 SuperClassic on Windows Server 2012R2 as part of a web application. Database is around 130GB with millions of transaction per day. From time to time Firebird hangs. It does not respond to any client. It's also not possible to connect locally to the server. The