Redshift Serverless Timeout

0

We've been using AWS Redshift Serverless for a while (whilst it was in preview) with no issues. We've just added a new IAM user for one of our team to access Redshift for data analytics. The account has the exact same permissions as all other accounts with Redshift access. For some reason, when they try use the Query editor to access the DB they get this error:

Databases couldn't be listed.
Connection is not available, request timed out [ErrorId: 1-62e7d16e-2e1f6bb7012371163e34e2fe]

Other users have seen this temporarily in the past week, however after a refresh the error eventually goes away. However for this user no matter what they do they still see the error when opening the editor, blocking them from connecting. They have tried on multiple devices, as well as resetting browser cache & cookies, with no luck. They are in a different geographical location to most of the team, although this means they are actually closer to the AWS region we are using.

The Redshift Serverless instance is in a VPC, with the port 5439 open for all sources. This rule allows everyone else in the team to access the DB with no issues, so I don't think the firewall rules are the issue.

Has anyone seen this error before? Really odd its temperamental and does not affect all users. Thanks

bmechen
질문됨 2년 전1470회 조회
1개 답변
0

Looking into this more, the user with trouble accessing Redshift has their email as their username, whereas the other accounts are just their names. Could the presence of an @ symbol in the username (which has been added to a pg_group in Redshift) cause an issue?

bmechen
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠