Subject | Re: Restoring database > 4 GB |
---|---|
Author | jeffshoaf |
Post date | 2003-05-02T19:05:14Z |
Even more info:
I tried to restore to multiple files rather than one large database
file. It filled the first file, started on the 2nd file, and then
stopped with the same message.
I'm not sure what to think - I can think through this and deduce that
the GBAK backup process is writing a corrupt .gbk file, and I think
through this and deduce that the restore process is messing up. \
Has anyone used GBAK to backup and restore large single-file
databases that are larger than 4GB?
I tried to restore to multiple files rather than one large database
file. It filled the first file, started on the 2nd file, and then
stopped with the same message.
I'm not sure what to think - I can think through this and deduce that
the GBAK backup process is writing a corrupt .gbk file, and I think
through this and deduce that the restore process is messing up. \
Has anyone used GBAK to backup and restore large single-file
databases that are larger than 4GB?
--- In ib-support@yahoogroups.com, "jeffshoaf" <jeffshoaf@a...> wrote:
> More information:
>
> The earlier attempts to do a restore on the .gbk file were made via
> IBExpert. I just tried it using the command line. It stopped at the
> same point (1,570,000 records), but GBAK displays the following
> message:
>
> Done with volume #1, "labels.gbk"
> Press return to reopen that file, or type a new
> name followed by return to open a different file.
> Name:
>
> Since I don't have another file, I pressed "Return". GBAK responded
> with:
>
> Expected volume number 2, found volume 1
> gbak:
>
> Could not read from file "labels.gbk"
>
> GBAK then repeated the "Done with volume #1" etc.
>
> Could this be a problem with the backup stuff in GBAK rather than
the
> restore stuff? This has happened with the last two backups of this
> database.
>
>
> --- In ib-support@yahoogroups.com, "jeffshoaf" <jeffshoaf@a...>
wrote:
> > We have a Firebird 1.0 database that has exceeded 6GB. Since the
> > server is running Windows 2000 with NTFS as the file system,
we're
> > trying to restore a backup made with GBAK to a single file using
> the
> > Localhost connection.
> >
> > Whenever the file gets to 4GB, the server shuts itself down and
the
> > restore fails with a lost connection. The server log lists the
> > following problems with the same timestamp:
> >
> > INET/inet_error: accept errno - 10093
> > INET/select_wait: select failed, errno = 10093
> > SRVR_multi_thread/RECEIVE: error on main_port, shutting down
> >
> > Then, 2 seconds later:
> >
> > C:\Program Files\Firebird\bin\ibserver.exe: terminated abnormally
(-
> 1)
> >
> > The guardian then restarts the server.
> >
> > This always happens at the 15,700,000th record and the
> resulting .gdb
> > database file is exactly 4GB in size.
> >
> > Can't a database that's larger than 4GB be restored into a single
> > file database?