| Subject | Re[2]: [firebird-support] oldest active transaction not available |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2013-10-09T19:10:46Z |
Hello!
Wednesday, October 9, 2013, 10:57:53 PM, you wrote:
mon$transactions. Also you may look into mon$database for it's number.
IP> "oldest active transaction" does not mean "oldest of currently running transactions",
IP> but "oldest transaction that was active when some other currently active transaction started".
You described Oldest Snapshot transaction, not Oldest Active.
OAT is a really oldest currently active transaction.
OST - is oldest transaction, that was active when oldest active
started, yes, and it does not exist anymore in mon$transactions.
--
Dmitry Kuzmenko, www.ib-aid.com
Wednesday, October 9, 2013, 10:57:53 PM, you wrote:
>> I can't find the oldest active transaction in mon$transactions and sweepoldest active transaction is the oldest one in
>> has no effect. Even Sinatica Monitor and IBExpert doesn't show this number.
>> How can I rollback this transaction?
mon$transactions. Also you may look into mon$database for it's number.
IP> "oldest active transaction" does not mean "oldest of currently running transactions",
IP> but "oldest transaction that was active when some other currently active transaction started".
You described Oldest Snapshot transaction, not Oldest Active.
OAT is a really oldest currently active transaction.
OST - is oldest transaction, that was active when oldest active
started, yes, and it does not exist anymore in mon$transactions.
--
Dmitry Kuzmenko, www.ib-aid.com