Athena - Athena查询PostgreSQL数据库数据报错 - GENERIC_USER_ERROR

0

【以下的问题经过翻译处理】 我已经设置了AWS Athena以查询PostgreSQL数据库数据。

但是,在尝试查询某些数据时,我遇到了GENERIC_USER_ERROR,并且出现下列消息:

完整的错误消息如下:

GENERIC_USER_ERROR: Encountered an exception[com.amazonaws.SdkClientException] from your LambdaFunction[arn:aws:lambda:eu-west-1:XXXXXXXXXXXX:function:jdbc_postgres] executed in context[retrieving meta-data] with message[Unable to execute HTTP request: Connect to s3.eu-west-1.amazonaws.com:443 [s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX] failed: connect timed out]
This query ran against the "XXXXX" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: a01d4534-faad-4f4c-80b6-492c44fac1c4

大家有什么解决此问题的方法吗?

非常感谢!

1개 답변
0

【以下的回答经过翻译处理】 根本原因:VPC没有连接互联网,导致Lambda无法访问S3。

解决方案:在与Lambda相关的VPC中添加VPC网关端点。

profile picture
전문가
답변함 5달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인