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.
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 Posts
Re: SOLID Sorter Error 24002 : Sort failed due to insufficient physical TmpDir2012-12-03T10:07:26ZThis is the accepted answer. This is the accepted answer.Hello,
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.