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

Question

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

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](https://support.console.aws.amazon.com/support/home#/case/create)

Thank you!

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

Contenuto pertinente