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
已提问 1 年前682 查看次数
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
已回答 1 年前
AWS
专家
已审核 1 年前
  • 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
已回答 1 年前
  • 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!

已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则