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

7 REPLIES 7

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.

Kaniz_Fatma
Community Manager
Community Manager

Hi @Karthikeyan Gunasekaran​ , the problem might be in the file format. Can you please check the file format?

Atanu
Esteemed Contributor
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
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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!