Subject Re: [ib-support] FB 1.0 and GBAK problems
Author Daniel Rail
Claudio, thank you, for your reply. Comments below.

At 20/03/2002 01:00 AM, you wrote:
>"Daniel Rail" <daniel@...> wrote in message
>news:5.1.0.14.2.20020319203114.00bd9568@......
> >
> > This error pops up in an automated process at a given point that doesn't
> > make sense to me. Here are the steps of the process in question:
> > 1. Backup database
> > 2. Make a copy of the database by using the copy command
>
>I assume nobody is connected at this time.

Correct. This is on a test machine and I'm the only user.


> > 3. Restore the database
> > 4. Apply any changes that needs to be made to the database
>
>Are you changing THAT table with your program?

I checked and yes I do. I add a varchar(30) unicode field.


> > 5. Backup database <<----- This is where the error occurs
>
>Gbak does in GDML the equivalent of SQL's
>select field1, ..., fieldN from tbl;
>but excluding computed fields. At this stage, try a plain
>SELECT * from tbl;
>with isql and see what happens. Do you get the same error message?

Yes. I see after which record the error occurs. Is it the record that is
shown or the next one that might contain the error.



> > The initial database in step 1 was created with IB 6 and backup is made
> > transportable, then restored in FB 1.0 final release. Once the error
> > occurs once, it persists time and time again for that GDB file.
>
>And you don't get a problem if you do the whole process with IB6.0?

I just checked it against FB 0.9.4 and I do get the error as well.

Is there something that I might be missing?

The last status line in gbak before the error occurs is:

"writing data for table INVOICE"


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)