SQL Error [D;600]: ERROR: timeout expired


Querying from redshift to serverless aurora in cross account facing error as Timeout Expired,Debug Driver logs from

com.amazon.redshift.core.v3.QueryExecutorImpl.receiveErrorResponse: <=BE ErrorMessage(ERROR: timeout expired

Location: File: ../src/external_catalog/external_catalog_api.cpp, Routine: localize_external_table, Line: 1267 Server SQLState: D;600)

Cross account set up well verified:Anoynomus details below

nc -vz auroradnsname.rds.amazonaws.com 5432 Connection to auroradnsname.rds.amazonaws.com 5432 port [tcp/postgres] succeeded!

P.S :Instead of VPC peering using aws transit gateway

1 Answer

Hi there,

Thank you for posting the question and the detailed explanation. To answer your question, we require details that are non-public information. Please open a support case with AWS using the following link

Thank you!

answered 12 days 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