[firebird-support] connecting to firebird server

Hi All I have FB3 installed on a server. My DelphiXE6 application can access the database via TIBDatabase etc no problem but I cannot connect with the server to back up the database. So I installed Flamerobin on the workstation to check and it cannot connect to the firebird server (fails

Re: [firebird-support] Table Size

09.05.2017 21:59, dres...@tbinc.com [firebird-support] wrote: > Does anyone have any tools that they can recommend that could help me easily > manage this? gstat -- WBR, SD.

[firebird-support] Table Size

I have a number of growing databases on my server and would like to occasionally see how much space each table is taking in the database--there may be some log files that could be cleaned up now and then. Many of my tables include blob fields, so this becomes different than just doing record

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

Hi Ann, I'm not using any transaction level explicitly. I'm using JPA and what I see in the trace is always this: READ_COMMITTED | REC_VERSION | WAIT | READ_WRITE I will wait now until it happens again (maybe in five minutes or a week) and then I will perform a full lock print as suggested.

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

Hi, The only thing I can say that situation is not obvious, I suggest to ask for professional support: https://www.firebirdsql.org/en/support/ Regards, Alexey Hi Alexey, I have already changed the configuration, but it didn’t help. What I find strange is the fact, that the memory

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

> On May 9, 2017, at 9:10 AM, Freddy Ertl f.e...@speexx.com [firebird-support] > wrote > > 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.

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

<> 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

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

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 "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

[firebird-support] Potential Causes for Query to Slow Down

<> Garbage collection usually. Regards Paul Beach

AW: [firebird-support] Firebird SuperClassic hangs

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

Hi Freddy, Try to use optimized Firebird configuration https://ib-aid.com/en/optimized-firebird-configuration/ As Sean already told, hang could be caused by very long processing of some requests - extremely long queues in lock table, or related with excessive number of record versions (Max