We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

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]

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    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';

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file