| Subject | Re: [firebird-support] Problem with FB database that freezes |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2015-07-24T16:40:46Z |
Hi,
OAT is an active transaction. You can see it alive if you analyze MON$ snaphot (you can use trial of our FBMonLogger).
So, disconnects are not related with Next-OAT gap - because this gap is caused by some open transaction which you can easily identify.
However, disconnects can lead to forced rollback, and as a result, OIT could stuck, and it will lead to increased gap OIT-OST, which is also not good.
For more details about OIT, OST and OAT read this ppt
http://www.slideshare.net/ibsurgeon/3-how-transactionswork
Regards,
Alexey Kovyazin
IBSurgeon
OAT is an active transaction. You can see it alive if you analyze MON$ snaphot (you can use trial of our FBMonLogger).
So, disconnects are not related with Next-OAT gap - because this gap is caused by some open transaction which you can easily identify.
However, disconnects can lead to forced rollback, and as a result, OIT could stuck, and it will lead to increased gap OIT-OST, which is also not good.
For more details about OIT, OST and OAT read this ppt
http://www.slideshare.net/ibsurgeon/3-how-transactionswork
Regards,
Alexey Kovyazin
IBSurgeon
Hi there,
Can the connection errors in the log contribute to the increasing gap between the OAT and NT?
Regards,
-Eduardo