More Info:
Identify any failed RDS Reserved Instances (RIs) available within your AWS account. A failed RDS RI is an unsuccessful reservation that received the “payment-failed” status during the purchase process.Risk Level
HighAddress
Cost OptimisationCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the misconfiguration of RDS Reserved Instances having a status of “Payment Failed” in AWS, you can follow these steps using the AWS Management Console:
-
Identify the RDS Reserved Instances with Payment Failed Status:
- Go to the AWS Management Console and navigate to the RDS service.
- Click on the “Reserved Instances” option in the left-hand menu to view all your reserved instances.
- Look for any instances with a status of “Payment Failed”.
-
Cancel the Reserved Instance with Payment Failed Status:
- Select the RDS Reserved Instance with the “Payment Failed” status that you want to remediate.
- Click on the “Actions” dropdown menu and select “Modify Reserved Instances”.
- In the Modify Reserved Instances wizard, select the option to “Cancel Reserved Instance” and follow the on-screen instructions to cancel the instance.
-
Purchase a New Reserved Instance:
- Once you have canceled the Reserved Instance with the Payment Failed status, you can purchase a new Reserved Instance to replace it.
- Click on the “Purchase Reserved Instances” button in the Reserved Instances dashboard.
- Follow the on-screen instructions to select the desired instance type, term length, and quantity for the new Reserved Instance.
-
Verify the New Reserved Instance Status:
- After purchasing the new Reserved Instance, verify that its status is “Active” and not “Payment Failed”.
- You can check the status of the new Reserved Instance in the Reserved Instances dashboard.
Using CLI
Using CLI
To remediate the misconfiguration of an RDS Reserved Instance having a status of “Payment Failed” in AWS using AWS CLI, follow these steps:Replace By following these steps, you should be able to remediate the misconfiguration of an RDS Reserved Instance with a status of “Payment Failed” in AWS using AWS CLI.
- Identify the RDS Reserved Instance with the “Payment Failed” status:
- Take note of the Reserved Instance ID of the RDS instance with the “Payment Failed” status.
- Modify the RDS Reserved Instance to update the payment method:
<RESERVED_INSTANCE_ID> with the Reserved Instance ID noted in step 2 and <OFFERING_ID> with the new offering ID for the Reserved Instance. You can find the available offering IDs by listing the available Reserved DB Instances offerings using the following command:- Confirm the changes by describing the updated Reserved Instance:
Using Python
Using Python
To remediate the issue of RDS Reserved Instances having a status of “Payment Failed” in AWS using Python, you can follow these steps:Make sure to replace the placeholders in the script with actual values as per your AWS account configuration. Also, ensure that you have the necessary permissions to modify RDS Reserved Instances in your AWS account.
-
Identify Reserved Instances with Payment Failed Status:
- Use the AWS SDK for Python (Boto3) to describe all the RDS Reserved Instances.
- Filter the instances that have a status of “Payment Failed”.
-
Modify the Reserved Instances:
- For each Reserved Instance with a status of “Payment Failed”, you can modify the instance to update the payment details.
- Use the
modify_reserved_db_instancesmethod from the Boto3 RDS client to update the payment details for the Reserved Instance.
-
Update Payment Information:
- You will need to provide valid payment information to update the status of the Reserved Instance.
- Use the
modify_db_instancemethod to update the payment details of the Reserved Instance.
-
Verify the Status:
- After updating the payment information, describe the Reserved Instance again to verify that the status is no longer “Payment Failed”.