Athena - Unable To Query PostgreSQL DB Data Via Athena - GENERIC_USER_ERROR

0

Hi all,

I have setup AWS Athena to query PostgreSQL DB data.

However, I encountered GENERIC_USER_ERROR when trying to query some data, with following messages: AWS Athena Generic User Error

Full Error Messages:

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

Since it mentioned about to post this error message, hence posted this error message in AWS re:Post forum.

Does anyone have any ideas on how to resolve this issue?

Thanks in advance!

Best Regards, Jerry Chong

1 Answer
1
Accepted Answer

Problem fixed.

Root Cause: VPC have no internet connection issue, causing Lambda can't access S3.

Solution: Add VPC Gateway Endpoint in Lambda associated VPC.

Best Regards, Jerry Chong

answered a year ago
AWS
EXPERT
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions