Subject Re: [firebird-support] Restore error (no space left on /tmp)
Author Helen Borrie
At 11:37 PM 10/11/2004 +0100, you 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?

You can't predict how much space in /tmp is being used by other
applications. You can (and should) configure sort space explicitly into one
or more directories that do have space available, leaving /tmp for
applications that can't pre-configure their temp space. See the
TempDirectories parameter in firebird.conf.