Subject RE: [firebird-support] Re: Firebird Restarting part 2
Author Alan McDonald
> Just to be sure.
> I have asked this before, but just assure me....
>
> When starting a transaction (as first connected user) I have the
> oldest active transactions.

correct
here's a discussion from Ann
http://www.meta.com.au/index.php?option=com_content&task=view&id=38&Itemid=3
1
on this subject.
The oldest active is the oldest transaction that was active when any
currently active transaction started. That's important because versions
created by that transaction and newer transactions are visible to some
active transaction and can not be garbage collected.

>
> If I never do anything again - the gab will grow.

correct - as long as you leave this transaction open

>
> But when the transaction commits, the oldest active is not this one
> anymore.
>
> Thats Correct, rigth ?
>
correct - its the next highest which is still open

>
>
>
> What if it is a rollback instead ?

same - it moves on

>
>
> Or a SavePiont (Using IBO) ?

savepopints are used to roll back to so it's the same as long as the
transaction gets committed or rollback or if app crashes, timeout on the
server will rollback

>
>
> Or a crash of an application ?

after a while, the transaction gets rolled back so it moves on

>
>
> Regards
> Michael
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>