Discussion:
No free space found in temporary directories operating system ..WriteFile failed
wan30032
12 years ago
Permalink
hello,

I create index .

the message in FlameRobin:

*** IBPP::SQLException ***
Context: Transaction::Commit

SQL Message : -901
can't format message 13:99 -- message file C:\Windows\firebird.msg not found

Engine Code : 335544675
Engine Message :
sort error
No free space found in temporary directories
operating system directive WriteFile failed


Rolling back the transaction...
Done.

sql :
CREATE INDEX INDEX1 ON T1 (I1,I2,I3,I4,I5,I6,I7,I8,I19,I10,I11,I12,I13,I14,I15,I16);
COMMIT;

The Database is : D:\FB\DB.FDB

There are 881GB in "D:" and DB.FDB is "372GB" ,and "508GB" is free.


(win7 64 + Firebird 2.5.2.26540 64)

tks.
Mark Rotteveel
12 years ago
Permalink
...
It could also mean that the user running the Firebird server does not have
access to the temporary file folder, or the temporary file folder is not
defined.

Mark
wan30032
12 years ago
Permalink
Post by Mark Rotteveel
It could also mean that the user running the Firebird server does not have
access to the temporary file folder, or the temporary file folder is not
defined.
Mark
change file :firebird.conf

#TempDirectories =

TempDirectories = D:\
wan30032
12 years ago
Permalink
Post by wan30032
Post by Mark Rotteveel
It could also mean that the user running the Firebird server does not have
access to the temporary file folder, or the temporary file folder is not
defined.
Mark
change file :firebird.conf
#TempDirectories =
TempDirectories = D:\
is that right? tks
wan30032
12 years ago
Permalink
The right is :


firebird.conf

TempDirectories = D:\

Loading...