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 Resposta
1
Resposta aceita

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

respondido há um ano
AWS
ESPECIALISTA
avaliado há um ano

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas