[ https://issues.apache.org/jira/browse/PHOENIX-5812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17072203#comment-17072203 ]
Chinmay Kulkarni commented on PHOENIX-5812: ------------------------------------------- [~dbwong] Perhaps it's less destructive to just monitor and log connections kept "idle" for too long, rather than directly closing them. We can also add information to the connection object to indicate its current activity etc. to help figure out "idle-ness". > Automatically Close "Idle" Long Open Connections > ------------------------------------------------ > > Key: PHOENIX-5812 > URL: https://issues.apache.org/jira/browse/PHOENIX-5812 > Project: Phoenix > Issue Type: Improvement > Reporter: Daniel Wong > Priority: Major > > As Phoenix may keep a maximum default number of connections. Badly > performing client calls or internal errors (See PHOENIX-5802). Can cause > total available connections to go to 0. Proposing a client connection > monitor with a connection reaper like task to reap idle connections. > Definition of "Idle" > Simple may be simple time based say if a connection has been open for > configurable amount of minutes simply close. > More complicated solution may be keeping track of last interaction time. -- This message was sent by Atlassian Jira (v8.3.4#803005)