> I have an FB 2.1.2 classic installation running a 70GB database with
> the sweep interval set to 0 that runs gbak every night. I just
> discovered last week that gbak was being run without garbage
> collection (-g), probably to speed up the backup process. This led to
> a gap between OAT and OI
Cheers,
On Aug 18, 2011, at 12:45 PM, "Bob Murdoch" wrote:
> I have an FB 2.1.2 classic installation running a 70GB database ... I just
> discovered last week that gbak was being run without garbage
> collection (-g), probably to speed up the backup process. This led to
> a gap between OAT
Anne -
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Thursday, August 18, 2011 4:50 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Oldest transaction stuck
>>
>&
>Database dialect1
>Creation date May 2, 2009 22:22:39
>
>The server has been rebooted a number of times since the database was
>last restored from a backup (which occurred more than a year ago).
Actually, more than two years ago. Out of curiosity, why do you stil
Ann,
> On Aug 18, 2011, at 12:45 PM, "Bob Murdoch" wrote:
>
>> I have an FB 2.1.2 classic installation running a 70GB database ... I just
>> discovered last week that gbak was being run without garbage
>> collection (-g), probably to speed up the backup process. This led to
>> a gap between OAT
Thomas,
>
> So you say that a gap OAT-OIT of 24 mio in this case doesn't harm server
> performance? I thought, each transaction start has to read the TIP pages
> starting from the OIT to the OAT, which is quite a number here.
>
superserver reads that list on startup and keeps a single bit vect
Set,
> -Original Message-
> From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling
Tysvær
> Sent: Friday, August 19, 2011 2:18 AM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Oldest tr
Thomas,
> -Original Message-
> From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
> Sent: Thursday, August 18, 2011 2:35 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Oldest transact
>> -Original Message-
>> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
> Steinmaurer
>> Sent: Thursday, August 18, 2011 2:35 PM
>> To: firebird-support@yahoogroups.com
>> Subject: Re: [firebi