Subject | RE: [firebird-support] Re: Firebird Restarting part 2 |
---|---|
Author | Alan McDonald |
Post date | 2006-12-22T12:08:49Z |
> Just to be sure.correct
> I have asked this before, but just assure me....
>
> When starting a transaction (as first connected user) I have the
> oldest active transactions.
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.
>correct - as long as you leave this transaction open
> If I never do anything again - the gab will grow.
>correct - its the next highest which is still open
> But when the transaction commits, the oldest active is not this one
> anymore.
>
> Thats Correct, rigth ?
>
>same - it moves on
>
>
> What if it is a rollback instead ?
>savepopints are used to roll back to so it's the same as long as the
>
> Or a SavePiont (Using IBO) ?
transaction gets committed or rollback or if app crashes, timeout on the
server will rollback
>after a while, the transaction gets rolled back so it moves on
>
> Or a crash of an application ?
>
>
> 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
>
>
>
>