Athena Error No: 100, HTTP Response Code: 502, Error Message: Failed to parse error payload

3

I have an app that has been connecting to Athena via OBDC with no previous issues. All of a sudden I am getting the following error as of Monday Oct 3rd:

Warning: Error in : nanodbc/nanodbc.cpp:1655: 00000: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 100, HTTP Response Code: 502, Error Message: Failed to parse error payload [Execution ID: c6c6a1bc-d7ea-4f79-bccd-e90aa6e767f7]

When I look up the execution ID in athena, there is no error. The query runs successfully on athena and it looks like the issue is between the Athena Client and Athena. Unfortunately the error message is really ambiguous but the Error No: 100 suggests that it is an internal service error. Any advice on how to debug this further would be much appreciated.

Thanks!

  • in every forum that i looking for this issue the solution is the same. Like SSTENS However, this slows the query speed down a lot so a permanent solution needs to be found. Something definitely changed in the last 24 hours as I had never seen this error before yesterday. Like Alejandro_aviles muy issue started since Oct3rd. Any solution that solve this issue without lost query speed??

benk
已提問 2 年前檢視次數 701 次
3 個答案
4

There is an internal issue going on in the backend which is giving rise to the error for many of the users. Confirmed this with the internal team as well. They are actively working towards it's resolution. Currently, as a immediate workaround please try setting the UseResultsetStreaming=0 as suggested by @sstens. Any inconvenience caused due to this is deeply regretted.

profile pictureAWS
支援工程師
Chaitu
已回答 2 年前
AWS
專家
已審閱 2 年前
  • The internal issue has been resolved October 4 6:18 PM PDT

  • @Fabrizio@aws which solution that solve the issue and not create slows the query speed dow. could you explain please?

2

Exact same issue as you, please post if you find a solution. As a temp fix, you can add UseResultsetStreaming=0 to the connection string (or configure it in Advanced Settings in the DSN). However, this slows the query speed down a lot so a permanent solution needs to be found. Something definitely changed in the last 24 hours as I had never seen this error before yesterday.

sstens
已回答 2 年前
  • Thanks sstens! Setting UseResultsetStreaming=0 is working as a workaround for now, but it is indeed slower.

0

Same error here, searching for an answer everywhere, but clueless about solution. ResultsetStreaming=0 worked for me, but waiting to understand what happened. It started since Oct3rd, so I think it can be general.

If you find any solution, please post here!

已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南