Hello, Alec!

Sunday, June 3, 2012, 10:17:05 PM, you wrote:

AS> Actually, FB correctly deletes fb_sort file used by a transaction after the
AS> transaction completes.

wrong. sort files being deleted when query that have plan sort fetched
to EOF, i.e. to the last record. Same happens, for example, when
group by query sort a huge resultset and result fits in memory.

If sort file left in temp, then application was terminated or failed,
or computer was powered off or reset.
Nothing to the transactions.

AS> However, we have a lot of long-running concurrent
AS> transactions which generate a lot of large fb_sort files.

long-running transactions is a different issue. Just fix your application.

AS> Moreover, when our customer rebuilt indexes they ran out of system disk space (since this
AS> is where %TEMP% points to) and left FB in corrupt state.

change %TEMP%.

--
Dmitry Kuzmenko, www.ib-aid.com