スキップしてコンテンツを表示
AWS re:Postを使用することにより、以下に同意したことになります AWS re:Post 利用規約
AWS re:Postre:Post
re:Postに関して

ETL Connection reset error when pulling data from RDS DB

0

Looking for a little insight on this:

ETL job fails with the following error: “Connection reset on https://xxxxxx.com:9200 https://xxxxxxx.com:9200"

Basic information: *ETL job is pulling data from an RDS PostgresSQL database *This is a nightly job that starts at 6PM - error only happens on Thursday nights at 7pm (every thursday). Runs as expected every other night without issue *Job that has been running without issue for 5 years, and just starting 5 weeks ago.

  • AWS-User-0357409
    3年前

    Hi Jennifer,

    Any chance you may have your RDS maintenance window setup during that time? Any indication in logging or the RDS console that a failover might be happening during that (if multi-AZ)?

トピック
データベース
タグ
データの抽出、変換、ロード
言語
English
質問済み 3年前337ビュー
1回答
0

That was my first thought, but no, maintenance is scheduled for saturdays. Its not Multi-az. The only other thing i can think of was that maybe backups are happening but that is scheduled for 5 UTC. I havent worked much with DB's, could it be that there is more data on thursdays to query?

回答済み 3年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

関連するコンテンツ