Skip to main content

about vertica ERROR 5001

  • October 23, 2013
  • 1 reply
  • 11 views
Jian_Zhou
Hi,
   today, I got a   error 'ERROR 5001' when running a sql in vertica. please refer the below info

test=> select * from resource_usage;

ERROR 5001:  ThreadManager failed to create thread EEcmdq: boost::thread_resource_error

HINT:  Please raise the number of processes per user

My question is how to raise the number of processes per user? which database parameter should i change?


    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • October 24, 2013
    Hi,

    First thing to check would be the nproc kernel setting in the /etc/security/limits.conf file. That controls the number of threads available to a user. See the Installation Guide section on Kernel parameters for complete details. extract from the table of kernel params: 
    /etc/security/limits.conf
    NPROC

    Total RAM on the node in MB (e.g., on 1GB machine, set NPROC to 1000) Controls the maximum number of threads and processes for each user.

    During install Vertica will add a couple entries in the limits file. So look for the current setting and see if it's in line with the formula above or not. If not adjust accordingly.

    # Added by Vertica
    dbadmin soft nproc 65536
    # Added by Vertica
    dbadmin hard nproc 65536

    Hope it helps.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement