Topic
1 reply Latest Post - ‏2012-12-03T10:07:26Z by pete_s
vinzon_11
vinzon_11
1 Post
ACCEPTED ANSWER

Pinned topic SOLID Sorter Error 24002 : Sort failed due to insufficient physical TmpDir

‏2012-11-12T03:41:15Z |
Hi Guys,

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.

Thanks
Updated on 2012-12-03T10:07:26Z at 2012-12-03T10:07:26Z by pete_s
  • pete_s
    pete_s
    2 Posts
    ACCEPTED ANSWER

    Re: SOLID Sorter Error 24002 : Sort failed due to insufficient physical TmpDir

    ‏2012-12-03T10:07:26Z  in response to vinzon_11
    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.

    [Sorter]
    TmpDir_1=/tmp

    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.