Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error encountered when restoring a table with Global Secondary Index using --billingMode PAY_PER_REQUEST #200

Closed
onion1984 opened this issue Mar 7, 2023 · 1 comment
Labels

Comments

@onion1984
Copy link

I try to restore a table using this command: dynamodump -m restore -r ap-northeast-1 --billingMode PAY_PER_REQUEST -s demo2 --schemaOnly --log DEBUG
The source table has a global secondary index(attribute2-3-index) configured, and both read and write capacity are on-demand.
I encountered the following error message:

DEBUG:botocore.endpoint:Sending http request: <AWSPreparedRequest stream_output=False, method=POST, url=https://dynamodb.ap-northeast-1.amazonaws.com/, headers={'X-Amz-Target': b'DynamoDB_20120810.CreateTable', 'Content-Type': b'application/x-amz-json-1.0', 'User-Agent': b'Boto3/1.24.90 Python/3.7.16 Linux/5.10.165-143.735.amzn2.x86_64 Botocore/1.27.96', 'X-Amz-Date': b'20230307T094011Z', 'X-Amz-Security-Token': b'IQoJb3JpZ2luX2VjEHEaCXVzLWVhc3QtMSJHMEUCIH65HH7LPsAOQGdibadIbyTqvf202wOAI0LCi+fzChXYAiEAvEcni1AWU4IfIq+7rCG5QhkBz2ofcN5BQCeEl+W3tJIqngIIKhAAGgw5Mzc2MjYyNTY1ODkiDGmaiHuauEuMbrmgXir7Add4/L/lxG2ppONGJLsiVYbpD4koRfojVSMZZLZxc5YIAKI5HJoAxXCQXP1dG68x9D52t5au6Ct147HqY2XLmdUYffSdqxReSlT4l4XAT/vQcXaaRgL2KoeTCfEJmamOt/d/tBTabaqJ4vGFlzRVTC1RrHZBUONrfpCe4bZlExpS1sTAMwRQddAzmRStf2nY5sZdD8A2WJ+pah1bp3NduFJXb+/i2aW4HRQp1E9awwLKbkqdu76Po84NH46wCVIPdTv3pHgli5Wf2FJvPK0h3CV0zvWZoTdUVXTStqTIf/+82eE/qW9P8byFEKeHtKQtZrIkTWoWGKVOfp+wMKH3m6AGOp0Belqc019kneOi/ITzhsbcwGfJjbXRBfd188ztwMMtNcU9TIeNozCUbE5ZOgAycoDGUwkMbIjS3ZXLJxxE6n9BsUg5ciqd01wYZFEK0wLIkQT4o81gIGuyNrnXQ2oZDXT8+41yUwRJWI84B0/7DVbkNiLs3o9HQSazrceG8MgbI2eQQsRRnuAmbUQhfl5oIocWha09sT0hIxkBvUpx9Q==', 'Authorization': b'AWS4-HMAC-SHA256 Credential=ASIA5UTXBITGW7I4SFUF/20230307/ap-northeast-1/dynamodb/aws4_request, SignedHeaders=content-type;host;x-amz-date;x-amz-security-token;x-amz-target, Signature=dcf0d126229ff693964a9dd8933d62c10d6ea10baf436a7e89bcfddfd73db46e', 'amz-sdk-invocation-id': b'fa21e345-390f-4076-982e-65c35bd0b388', 'amz-sdk-request': b'attempt=1', 'Content-Length': '630'}>
DEBUG:botocore.httpsession:Certificate path: /home/ec2-user/.local/lib/python3.7/site-packages/botocore/cacert.pem
DEBUG:urllib3.connectionpool:https://dynamodb.ap-northeast-1.amazonaws.com:443 "POST / HTTP/1.1" 400 225
DEBUG:botocore.parsers:Response headers: {'Server': 'Server', 'Date': 'Tue, 07 Mar 2023 09:40:11 GMT', 'Content-Type': 'application/x-amz-json-1.0', 'Content-Length': '225', 'Connection': 'keep-alive', 'x-amzn-RequestId': 'KS01FNVA0DCAVUT114ED3TKH7BVV4KQNSO5AEMVJF66Q9ASUAAJG', 'x-amz-crc32': '791733731'}
DEBUG:botocore.parsers:Response body:
b'{"__type":"com.amazon.coral.validate#ValidationException","message":"One or more parameter values were invalid: ProvisionedThroughput should not be specified for index: attribute2-3-index when BillingMode is PAY_PER_REQUEST"}'
DEBUG:botocore.hooks:Event needs-retry.dynamodb.CreateTable: calling handler <botocore.retryhandler.RetryHandler object at 0x7f375217afd0>
DEBUG:botocore.retryhandler:No retry needed.
ERROR:root:An error occurred (ValidationException) when calling the CreateTable operation: One or more parameter values were invalid: ProvisionedThroughput should not be specified for index: attribute2-3-index when BillingMode is PAY_PER_REQUEST
Traceback (most recent call last):
File "/home/ec2-user/.local/lib/python3.7/site-packages/dynamodump/dynamodump.py", line 924, in do_restore
**optional_args
File "/home/ec2-user/.local/lib/python3.7/site-packages/botocore/client.py", line 514, in _api_call
return self._make_api_call(operation_name, kwargs)
File "/home/ec2-user/.local/lib/python3.7/site-packages/botocore/client.py", line 938, in _make_api_call
raise error_class(parsed_response, operation_name)
botocore.exceptions.ClientError: An error occurred (ValidationException) when calling the CreateTable operation: One or more parameter values were invalid: ProvisionedThroughput should not be specified for index: attribute2-3-index when BillingMode is PAY_PER_REQUEST

@github-actions github-actions bot added the Stale label May 7, 2023
@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale May 15, 2023
@bchew bchew closed this as completed Apr 24, 2024
@bchew
Copy link
Owner

bchew commented Apr 24, 2024

Fixed by #266

@bchew bchew reopened this Apr 24, 2024
@bchew bchew closed this as completed Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants