How can I get my connection to Vertica to stay alive?

Comments

• pviennea

  March 2014

  The timeout out period for Vertica and/or the JDBC driver does not get set at the database level.
  
  However, it is advisable to keep the TCP Keep Alive settings at the OS level lower than the timeout parameter at the client level or at firewall to avoid such connection timeouts.
  
  Please check with your network admin for firewall timeout value, or any timeout value set at the client level. Then modify kernel parameter tcp_keepalive_time to a value lower than the firewall timeout values. This should give the TCP keepalive a chance to keep the connection alive.
  
  Here is a forum post that may help as well: http://vertica-forums.com/viewtopic.php?t=252
  
  Thanks,
  
  Pat
  
  

  0
• Prasanta_Pal - Select Field - Employee

  March 2014

  Below command may be useful to set the time interval to 10 mins
  
  # echo 600 > /proc/sys/net/ipv4/tcp_keepalive_time
  
  

  0
• Nicholas_Chamma_1

  March 2014

  Yes, I used something along those lines to get it working. 

  0
• Sarkunan_Hari

  February 2015

  Hi Nicholas, 
  I am also facing same issue, can you please explain that, what are the steps u follow to solve this issue.
  
  Thanks,
  Guna

  0
• [Deleted User]

  February 2015

  Hey Guna,

   

  Take a look at my response to this post. It goes over the commands you can use to check your current settings as well as to set new values for your keepalive settings:

   

  https://community.dev.hp.com/t5/Vertica-Forum/how-to-set-connection-to-vertica-keep-alive/m-p/222903#M8707

   

  Let me know if you have any questions.

  - Mitch

  0