session is not closed after losing connection
We use vertica-jdbc for connection. When connection is lost session is not closed on the server. It's critical when some tables are locked in the session. So we can't access tables in new session. It's easily reproduced by the next steps: 1. Open connection/transaction/run queries 2. Turn off internet When you run "select * from sessions" you still see the open session, tables are not unlocked. Some sessions hang for days while we manually kill them.