cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
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
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

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.