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 Risposta
1
Risposta accettata

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

con risposta un anno fa
AWS
ESPERTO
verificato un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande