Skip to main content
  • EN

Hello,

I have a workbench which includes Databrick JDBC Connection. It was working fine with FME 2024.0.3.0. However, after upgrading to FME 2024.1.2.1, it starts throwing error “java.sql.SQLException: iDatabricks]iDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.”

Feels like something is missing with the upgrade. Has anybody seen the same problem? Could Safe support team please check? thank you.

Full error attached below.

java.sql.SQLException: pDatabricks]bDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.
	at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)
	at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)
	at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)
	at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)
	at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)
	at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)
	at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)
	at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)
	at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
	at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)
	at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:590)
	at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:198)
Caused by: com.databricks.client.support.exceptions.GeneralException: pDatabricks]bDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.
	... 13 more
Caused by: java.lang.IllegalStateException: Connection not obtained from this manager
	at com.databricks.client.jdbc42.internal.apache.http.util.Asserts.check(Asserts.java:34)
	at com.databricks.client.jdbc42.internal.apache.http.impl.conn.BasicHttpClientConnectionManager.releaseConnection(BasicHttpClientConnectionManager.java:260)
	at com.databricks.client.jdbc42.internal.apache.http.impl.execchain.ConnectionHolder.abortConnection(ConnectionHolder.java:135)
	at com.databricks.client.jdbc42.internal.apache.http.impl.execchain.ConnectionHolder.cancel(ConnectionHolder.java:146)
	at com.databricks.client.jdbc42.internal.apache.http.client.methods.AbstractExecutionAwareRequest.reset(AbstractExecutionAwareRequest.java:144)
	at com.databricks.client.jdbc42.internal.apache.http.client.methods.HttpRequestBase.releaseConnection(HttpRequestBase.java:119)
	at com.databricks.client.hivecommon.api.TETHttpClient.flushUsingHttpClient(Unknown Source)
	at com.databricks.client.hivecommon.api.TETHttpClient.flush(Unknown Source)
	at com.databricks.client.jdbc42.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:73)
	at com.databricks.client.jdbc42.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:62)
	at com.databricks.client.jdbc42.internal.apache.hive.service.rpc.thrift.TCLIService$Client.send_OpenSession(TCLIService.java:147)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper.send_OpenSession(Unknown Source)
	at com.databricks.client.jdbc42.internal.apache.hive.service.rpc.thrift.TCLIService$Client.OpenSession(TCLIService.java:139)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper.callOpenSession(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper.access$1700(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper$18.clientCall(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper$18.clientCall(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper.executeWithRetry(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2ClientWrapper.OpenSession(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)
	at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)
	at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)
	at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)
	at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)
	at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)
	at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)
	at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)
	at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)
	at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
	at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)
	at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:590)
	at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:198)
	at COM.safe.fme.jdbc.JdbcReader.open(JdbcReader.java:167)

 

This is primarily a community forum, if you do believe this to be a bug, it’s best to submit a support case with Safe so they can triage it and assign to the appropriate team to investigate.

Reply


Community Stats

30,149
Posts
114,438
Replies
37,793
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.