Problem restoring large databases on Linux
When you restore large databases on Linux, you might see this kind of error:
I/O error for file "/tmp/fb_sort__xxxxxx"
-Error while trying to read from file
-No such file or directory
If usually happens when you have one big table and it takes a long time to build indexes. Firebird uses temporary file storage for this (/tmp by default) and some Linux distributions have cron jobs that clean up /tmp periodically. Turning off crond or changing the TempDirectories setting in firebird.conf should solve this issue.