Subject RE: [firebird-support] Re: pointer page vanished from mark_full (256)
Author Alan McDonald
> If we move to Firebird 2 do we need to do a backup/restore cycle
> to remove this limitation?
>
> Regards,
>
> Robert

if you move from 1.5 to 2.0 then backup/restore is absolutely essential. New
On-Disk-Structure!
backup with 1.5 tools and restore with 2.0 tools
Alan

>
> --- In firebird-support@yahoogroups.com, "Ann W. Harrison"
> <aharrison@...> wrote:
> >
> > robertgilland wrote:
> > >
> > > gbak: ERROR: internal gds software consistency check (pointer
> page
> > > vanished from mark_full (256))
> >
> > The problem your seeing is probably a limit in Firebird prior to V2
> > that restricts the record space for a table to about 70 million KB,
> > including record headers and back versions - large blobs don't
> count.
> > You've got somewhat more than 29 million records so you may have
> > run into that problem. A backup/restore will fix the problem
> > temporarily, but the better intermediate solution is to archive some
> > of the records in another table. V2.0 corrects the problem totally.
> >
> >
> > Regards,
> >
> >
> > Ann