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'
Hi,
first potential thing – transaction management.
Probably you have transaction long running and it stop garbage collector to
process old record versions
Look into MON$TRANSACTIONS
regards,
Karol Bieniaszewski
From: craig_...@coxcolvin.com [firebird-support]
Sent: Thursday, May 4, 2017
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,
> My problem is the increase in RAM when I start using my application under
> Firebird 3 which is much more greedy, I switch from a usual 50mo
> consumption to 200mo and more.
Actually, your stats shows v2.5 using 174MB of RAM, whereas v3 uses 215MB
> fb 2.5 :
> • Memory
> Current: 174 393 144
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
I just migrated my Firebird 2.5 server to Firebird 3, using NodeJS 4.2.2
server and node-firebird.
My problem is the increase in RAM when I start using my application under
Firebird 3 which is much more greedy, I switch from a usual 50mo
consumption to 200mo and more.
Is this normal? Is
I have a Delphi Application that uses FireDac to communicate with Firebird 2.5.
I have a query that periodically slows down fro about 5 secs to many minutes.
If I backup and restore the database, I get my original performance back.
What kind of things could cause this behavior.
Thanks in
Problem solved.
Strange behavior of lazarus 1.6.2 IDE for linux, project settings like "use
ansistrings" are not correctly propagated ...
I had to set it in custom fpc settings -Sh to fix this..
--
Regards,
Michał Kurczabiński
> Hello,
>
> at the moment, I’m in struggle with a CTE:
>
> for with recursive ok as
> (select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner
> join t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom =
> :id_kom union all select c.pos, d.kennzeichen, d.price, d.id from
>
11 matches
Mail list logo
