Subject Re: [firebird-support] FB 2.1.1 - gstat x mon$ tables: which is correct?
Author Helen Borrie
At 12:55 PM 10/11/2008, you wrote:
>I am working on a Debian Linux, Etch, AMD 64 bits.
>FB SS 2.1.1.
>
>After all users have closed all systems (22:00), gstat says that my oldest active transaction (oat) is 191 and mon$ tables say that same oat is 21226. gstat reported as 191 during the whole day, but I could not find the command which generated this transaction.
>
>1. Which oat number is correct?

Probably both of them...

>2. I can not find transaction 191 via selecting mon$ tables. What select should I use for discovering the command (DDL, DML, DCL, TCL or DQL) which generated my last real oat (191 or 21226)?

Between the time when gstat stopped reading the header file and when the mon$ transaction started, the garbage collection thread committed and the transaction inventory page was updated. If you do another gstat after the mon$ transaction commits, you should see some nice clean numbers.

>3. FB 2.1.1 transactions have "time out"?

You have the option to set a timeout for WAIT transactions. I don't know whether this was the answer you wanted...

./heLen