Subject Re: [firebird-support] Restore error (no space left on /tmp)
Author Alexandre Benson Smith
Hi, Pawel!

PaweĊ‚ Sulkowski wrote:

>Recently I've encoutered following problem while restoring database:
>gbak: cannot commit index RDB$PRIMARY93
>gbak: ERROR: I/O error for file "/tmp/fb_sort__GaEcCk"
>gbak: ERROR: Error while trying to write to file
>gbak: ERROR: No space left on device
>gbak: ERROR: sort error
>gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
>gbak: ERROR: Cannot deactivate primary index
>gbak: Exiting before completion due to errors
>The db I've tried to restore was so huge (3GB) that tmp partition ran
>out of space while restoring indexes.
>To restore database I had to umount the tmp partition (umount /tmp), run
>restore and mount tmp partition again.
>It's worth to mention that I've tmp directory on separate partition (due
>to security issues) and I've allocated only 1GB for it.
>Have you ever had similar problem?
>Pawel Sulkowski

you don't need to umount the partition, you could change the temp file
location on firebird.conf

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil