Subject | Restore error (no space left on /tmp) |
---|---|
Author | Paweł Sulkowski |
Post date | 2004-11-10T22:37:11Z |
Hello,
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?
---
Regards,
Pawel Sulkowski
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?
---
Regards,
Pawel Sulkowski