What TmpDir exactly needed to free-up to avoid this error? I only have 2.2MB in my /tmp directory but I still have this error.
I am using java to connect to soliddb using solidjdbc, I was able to connect before then suddenly this error occurred and I'm having a problem solving it. Need your help please.
This topic has been locked.
1 reply Latest Post - 2012-12-03T10:07:26Z by pete_s
Pinned topic SOLID Sorter Error 24002 : Sort failed due to insufficient physical TmpDir
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-03T10:07:26Z at 2012-12-03T10:07:26Z by pete_s
pete_s 270005QS362 PostsACCEPTED ANSWER
Re: SOLID Sorter Error 24002 : Sort failed due to insufficient physical TmpDir2012-12-03T10:07:26Z in response to vinzon_11Hello,
The temporary directory for external sorter is a server side setting.
In server side solid.ini file you can define the location for external
sorter temporary files, eg.
There needs to be enough space to store the sorted result set twice.
(Because the external sort algorithm peaks at twice the size of result set).
The client side settings do not affect the external sorter at all.