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.

질문됨 일 년 전751회 조회
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
전문가
답변함 일 년 전
profile picture
전문가
검토됨 한 달 전
  • 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.

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

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

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

관련 콘텐츠