[Vertica][VJDBC](100161) The connection is closed.

JunaidKhan

Hi Team,

I have 3 node vertica cluster and i receiving the below error in the logs. i am able to connect to the db normally and my cluster state is also normal, please guide.

2018-06-07 14:35:06,121 ERROR [com.hp.ossa.batch.batchlet.jdbc.CancellableJdbcBatchlet] (default task-31) Error when closing session v_ossa_node0001-315774:0x1210: java.sql.SQLException: [Vertica]VJDBC The connection is closed.
at com.vertica.io.ProtocolStream.ensureOpen(Unknown Source)
at com.vertica.io.ProtocolStream.sendMessage(Unknown Source)
at com.vertica.core.VConnection.handleError(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.dataengine.SimpleQueryExecutor.execute(Unknown Source)
at com.vertica.dataengine.SimpleQueryExecutor.execute(Unknown Source)
at com.vertica.core.VConnection.executeTransactionStatement(Unknown Source)
at com.vertica.core.VConnection.commit(Unknown Source)
at com.vertica.jdbc.common.SConnection.setAutoCommit(Unknown Source)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:905)
at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1918)
at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:447)
at com.hp.ossa.batch.batchlet.jdbc.CancellableJdbcBatchlet.cancel(CancellableJdbcBatchlet.java:69) [ossa-batch-ejb.jar:]
at com.hp.ossa.batch.batchlet.jdbc.CancellableJdbcBatchlet.stop(CancellableJdbcBatchlet.java:56) [ossa-batch-ejb.jar:]
at org.jberet.runtime.runner.BatchletRunner.stopRequested(BatchletRunner.java:47) [jberet-core-1.2.1.Final.jar:1.2.1.Final]
at org.jberet.runtime.JobExecutionImpl.stop(JobExecutionImpl.java:215) [jberet-core-1.2.1.Final.jar:1.2.1.Final]
at org.jberet.operations.JobOperatorImpl.stop(JobOperatorImpl.java:150) [jberet-core-1.2.1.Final.jar:1.2.1.Final]
at com.hp.ossa.batch.BatchBean.shutdown(BatchBean.java:174) [ossa-batch-ejb.jar:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_161]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_161]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_161]

Jim_Knicely

It looks like there was a "Close Session Request" that failed because the session was already closed... You should be able to find when that session ended:

SELECT session_end_timestamp FROM user_sessions WHERE session_id = 'v_ossa_node0001-315774:0x1210';