dynamoDB NoSQL Workbench fails to commit all the items

1

I created a table and put 107 items by using NoSQL Workbench, and successfully commited the table with 107 items into my local dynamoDB.

However, I half failed to commit the same table into my remote dynamoDB. Workbench displays an error message saying only 45, 46, or 47 items are put instead of all 107 items. The number of successful transfers such as 45, 46, and 47 is also different each commit time.

Why only less than half items are successfully commited to remote dynamoDB? Why OK with local dynamoDB? Thanks much in advance for your help in this matter.

質問済み 2年前945ビュー
1回答
1
承認された回答

My assumption here is that your remote table does not have enough capacity to commit all the items and is failing due to excessive throttling. You do not have this issue when committing to local.

To diagnose, check your tables metrics section in the AWS web console and have a look for write throttling events. If you see a spike in throttles at the same time as your commit it indicates you must increase your tables capacity (WCU).

profile pictureAWS
エキスパート
回答済み 2年前
profile picture
エキスパート
レビュー済み 7ヶ月前
  • Thanks for your advice. I will check the metrics and increase the capacity.

  • I assume you're correct in that it's a throttling issue, but how do you fix this? NoSQL Workbench creates the table for you, and then automatically puts the items. If you try to 'Commit to Amazon DynamoDB' again, it fails because the table already exists. There is no "window" to increase the table capacity.

  • That is correct and its something the NoSQL Workbench team are aware of. It should be resolved in future releases.

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

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

質問に答えるためのガイドライン

関連するコンテンツ