[firebird-support] RE: nbackup questions

[hvlad]

 From your earlier postings, I gather that in May 2013 nbackup failed to 
  complete, so the main database file has been frozen for 8 months, and 
 all the changes since May 2013 have accumulated in the delta.
 
  This is too strong statement. To verify it we need to know physical backup
state of the database. gstat -h will show it (and it not requires admin 
privileges).

Regards,
Vlad

 

RE: [firebird-support] RE: nbackup questions

[Leyne, Sean]

 From your earlier postings, I gather that in May 2013 nbackup failed to
 complete, so the main database file has been frozen for 8 months, and
 all the changes since May 2013 have accumulated in the delta.

  This is too strong statement.

SL Agreed.  In fact, AFAIR, while the main database file would be frozen, the 
delta file should only contain the latest/un-garbagecollected row versions.

SL Garbage collections should still be running/following the standard rules 
(i.e. long running transactions).  The only effect should be that the new 
rows/pages would be written to the delta file.

Re: [firebird-support] RE: nbackup questions

[Paul Vinkenoog]

Vlad wrote:

 From your earlier postings, I gather that in May 2013 nbackup failed to
 complete, so the main database file has been frozen for 8 months, and
 all the changes since May 2013 have accumulated in the delta.

 This is too strong statement. To verify it we need to know physical backup
 state of the database. gstat -h will show it (and it not requires admin 
 privileges).

I based my assumption on what Maury wrote in the earlier thread 
Confused about delta files:

   The date of the FDB is May 2nd, 2013. The date of the delta is today.

...combined with his later statement that the system's Scheduler 
function, without any warning or errors, stopped making these nbackups 
last May.


Cheers,
Paul Vinkenoog

Re: [firebird-support] RE: nbackup questions

[Maury Markowitz]

On 2014-01-15, at 6:31 PM, Paul Vinkenoog wrote:
 
 The date of the FDB is May 2nd, 2013. The date of the delta is today.
 
 ...combined with his later statement that the system's Scheduler 
 function, without any warning or errors, stopped making these nbackups 
 last May.

Indeed. Perhaps file sizes may be of interest. The original FDB is ~68MB, and 
holds data for about three years. The FDB.delta is 70MB and holds data for 8 
months.

I suspect the implication here is that we've touched so many rows of the 
original db that practically everything had to be duplicated, and that we've 
added about 2MB of new material since then.