hello,

User can't connect database when transaction id is over-flow.
I know transaction id is reset with back-ip/restore.

I would lilke to know FB 2.0 behavor.

Thanks.

Daiju

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
> Sent: Tuesday, March 14, 2006 7:46 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Transaction ID
>
> --- In firebird-support@yahoogroups.com, "Alan McDonald"
> <alan@...> wrote:
> >
> > > Hi,
> > >
> > > ODS 10.2 has 2^31 transaction id.
> > > I believe this spec is some limitation if Firebird is used under
> > > 24x7 web system.
> > > I know transaction id is reset when database is back-up/restoring.
> > >
> > > I would like to know how to avoid this limitation in your system.
> > > Please let me know whether FB2.0 change this limitation or not.
> > >
> > > Regards.
> > >
> > > Daiju
> >
> > if you ever do reach this limit, the transaction ID just rolls over.
> Don't
> > forget that in a web system the trasnactions are only as long as the
> page
> > that is delivered so there are no long running transactions and
> nothing gets
> > "stuck"
> > Alan
>
> What happens to the garbage collection when it rolls over? I
> was under the impression that this limit was a show-stopper
> that you had to backup-restore pre-emptively to prevent.
>
> Adam
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>