|RE: [firebird-support] Problem Firebird Classic Server
|Svein Erling Tysvær
>> First my gstat -h statistics:I just wanted to emphasize what Thomas said here, with this big a gap after five days, I'm surprised that you actually manage to run several months before the problems gets too big. At the time you got these statistics, there were still an open transaction that were amongst the first 1000 transactions started. To me, that indicates something very wrong in how you handle your transactions (theoretically, that could mean 228000 versions of each record in your database - in reality it will be a lot less, but still too many). Transactions should be short, how short depends on your particular situation, but five days is far too long in all cases.
>> Oldest transaction 833
>> Oldest active 961
>> Next transaction 229603
> First of all, you have a transaction management problem, because during
> 5 days of operation, the gap between OIT/OAT and next transaction grow
> and will probably grow further.
Do you use CommitRetaining - that at least wasn't a proper commit and could hold up OIT/OAT (I don't know whether Fb 2.0 can have improved that or not) or open one or more transactions that you do not close (that may even be a transaction that doesn't update anything)?
The other advice you've been given may be useful, but - unless you put some gas into your car, replacing the flat tire, washing your lights and repairing the broken mirror doesn't help much.