cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Databricks - Simba SparkJDBCDriver 500550 exception

GKKarthi
New Contributor

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]

1 ACCEPTED SOLUTION

Accepted Solutions

Atanu
Esteemed Contributor

@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/)

View solution in original post

6 REPLIES 6

Anonymous
Not applicable

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.

Anonymous
Not applicable

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

Atanu
Esteemed Contributor

@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/)

Hi @Karthikeyan Gunasekaranโ€‹ ,

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

Atanu
Esteemed Contributor

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

PFBOLIVEIRA
New Contributor II

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group