Closing idle sessions automatically

[rajasekhart]

Hi,

I want to close the sessions (which were unused for a long time say 48 hours) automatically.
But i dont want to close them explicitly by writting Close_Session command.
Is it possible in vertica?
Please help me.

Thanks in advance,
Raj.

[jpcavanaugh]

I do not believe this functionality exists in the current version but a simple cron script should be able to handle this for you.

[id10t]

I agree with @juniorfoo. You can set max session duration, but i don't know about any feature with IDLE.

For current max session duration:

Code: Select all

dbadmin=> show runtimecap;
    name    |  setting  
------------+-----------
 runtimecap | UNLIMITED
(1 row)

[billykopecki]

What do you guys think of this solution for closing idle sessions?

I created a shell script file containing the following commands:

Code: Select all

/opt/vertica/bin/vsql -U dbadmin -c "SELECT 'close_session(''' || session_id || ''');' FROM sessions s join users u on u.user_name = s.user_name WHERE s.login_timestamp <= timestampadd(minute, -45, sysdate) AND s.current_statement = '' AND u.is_super_user = 'f';" -o /home/usr/dbadmin/close_session.sql -t
/opt/vertica/bin/vsql -U dbadmin -f /root/vload/close_session.sql -o /home/usr/dbadmin/close_session.out

I run the script every 10 minutes as a cron job.

Anyone see any problems with this?

[fsalvelt]

billykopecki,

I need to also implement this functionality. Is what you did working ok? Another DBA told me that its a bad idea to close sessions without letting the user know first. Also, have you seen any performance problems with leaving idle session open?

Thanks!

[rajasekhart]

Hi fsalvelt,

Yes there is a performance issue , if the sessions were left idle..

Thanks,
Raj.

[piglet]

Can we close sessions that are active?