Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to check max session count? and current session count??

Hello, I'm managing a vertica database cluster and more and more projects will use vertica database.
today, connection timeout exception is occured when i run another project which use vertica database.

so.. i doubt that the connection session count reach max connection session count

How to check max session count? and current session count??

Answers

  • moshegmosheg Employee
    edited October 6

    • To determine the original value for the MaxClientSessions parameter:
    => SELECT CURRENT_VALUE FROM CONFIGURATION_PARAMETERS WHERE parameter_name='MaxClientSessions';

    CURRENT_VALUE

    50
    (1 row)
    • To increase the MaxClientSessions parameter to 100 (for example) do:
    => SELECT SET_CONFIG_PARAMETER('MaxClientSessions', 100);

    BTW, I would expect to see an error like: "New session rejected due to limit, already 55 sessions activ"
    To monitor requests for resources that are rejected by the Resource Manager do: SELECT * FROM resource_rejections;
    The V_MONITOR.ERROR_MESSAGES system table tracks error and warning messages encountered while processing queries.
    SELECT event_timestamp, user_name, message FROM error_messages ORDER BY event_timestamp DESC;
    and check also dc_errors;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.