topic Re: Databricks - Simba SparkJDBCDriver 500550 exception in Data Engineering

Databricks - Simba SparkJDBCDriver 500550 exception

GKKarthi — Thu, 27 Jan 2022 10:29:09 GMT

We have a Denodo big data platform hosted on Databricks. Recently we have been facing the exception with message '[Simba][SparkJDBCDriver](500550)' with the Databricks which interrupts the Databricks connection after the certain time Interval usually b/w 12 to 15 mins). The SQL query returns the results fine. But when integrating with other platforms, the connection is getting closed with this exception.

Any guidance you have will be much appreciated.

QUERY [VIRTUAL] [ERROR]

QUERY [JDBC WRAPPER] [ERROR]

QUERY [JDBC ROUTE] [ERROR] Received exception with message '[Simba][SparkJDBCDriver](500550);

Error fetching next row]

Re: Databricks - Simba SparkJDBCDriver 500550 exception

Anonymous — Thu, 27 Jan 2022 22:48:44 GMT

Hello, @Karthikeyan Gunasekaran! My name is Piper, and I'm one of the Databricks moderators. It's nice to meet you. Thank you for bringing your question to us. Let's give it a bit longer to give the other members of the community a chance to respond before we circle back around to this.

Re: Databricks - Simba SparkJDBCDriver 500550 exception

Anonymous — Mon, 07 Feb 2022 16:27:23 GMT

@Karthikeyan Gunasekaran - We are looking for someone to help you.

Re: Databricks - Simba SparkJDBCDriver 500550 exception

Atanu — Sat, 12 Feb 2022 16:00:19 GMT

@Karthikeyan Gunasekaran

Could you please enable logging and see if you can collect more information on this (https://simba.wpengine.com/resources/drivers/enable-logging-odbc-driver/)

Re: Databricks - Simba SparkJDBCDriver 500550 exception

jose_gonzalez — Wed, 02 Mar 2022 02:12:20 GMT

Hi @Karthikeyan Gunasekaran ,

Did you enable the extra logging and narrow down the issue? do you still need help?

Re: Databricks - Simba SparkJDBCDriver 500550 exception

Atanu — Thu, 03 Mar 2022 14:58:09 GMT

@Karthikeyan Gunasekaran please let us know if you got a chance to go through our earlier comment

Re: Databricks - Simba SparkJDBCDriver 500550 exception

PFBOLIVEIRA — Tue, 02 Aug 2022 18:10:27 GMT

Hi All,

We are also experiencing the same behavior:

[Simba][SimbaSparkJDBCDriver] (500550) The next rowset buffer is already marked as consumed. The fetch thread might have terminated unexpectedly. Foreground thread ID: xxxx. Background thread ID: yyyy.

It does not happen all the time, so we are really not sure on what may be happening here...

Wonder if @Karthikeyan Gunasekaran was able to fix or at least understand it?

Thanks