--- In ib-support@y..., Aage Johansen <aagjohan@o...> wrote:

> > I have a problem with a database:
> > - gfix -v -full reports no problem
> > - gbak can backup the database with or without data with no
> > problems
> > - gbak can't restore the database without the engine crashing
> > (with or without data in the backup)
> > ...
>
> Did you recently create a new field with a 'NOT NULL' constraint
> without filling it with data? This may cause problems with
> backup/restore, but maybe not the problems you have got.

I don't think I did.. but would that problem also appear when only
backing up/restoring metadata? As this also causes the engine to crash.

> Can you restore when you deactivate indexes?

Forgot to mention that I did test that and it still didn't work.

> If you use VERBOSE mode you can see where the restore stops - does
> that give you any clues?

No clue at all, it crash just before going home:

gbak: restoring index RDB$FOREIGN54
gbak: ERROR: Unable to complete network request to host "localhost".
gbak: ERROR: Error reading data from the connection.
gbak: Exiting before completion due to errors

RDB$FOREIGN54 being I believe the last index to restore. And when
disabling indexes:

gbak: creating indexes
gbak: ERROR: Unable to complete network request to host "localhost".
gbak: ERROR: Error reading data from the connection.
gbak: Exiting before completion due to errors

Confirming that it's after the index creation. (Those tests were done
with metadata backup only, so the data should not be at fault.)

And in interbase.log, there is only a line about bin/ibserver
terminating abnormally (-1) and another about it being restarted.
Nothing on the cause of the crash.

Thanks,

Patrice Fournier