Logo of Trend Micro
Use the Conformity Knowledge Base AI to help improve your Cloud Posture

Redshift Reserved Node Payment Failed

Trend Cloud One™ – Conformity is a continuous assurance tool that provides peace of mind for your cloud infrastructure, delivering over 1000 automated best practice checks.

Risk Level: High (not acceptable risk)
Rule ID: RS-012

Identify any failed Amazon Redshift Reserved Nodes (RNs) available within your account and follow Cloud Conformity guidelines for remediation in order to receive a significant discount (up to 75% depending on the commitment term, 1-year or 3-years) on the Redshift hourly charges. A failed Redshift RN is an unsuccessful reservation that received the "payment-failed" status after the purchase payment processing failed.

This rule can help you work with the AWS Well-Architected Framework.

This rule resolution is part of the Conformity Security & Compliance tool for AWS.

Cost
optimisation

Using Reserved Nodes to cut down on computing costs is one of the most used cost optimization strategies when working with AWS Redshift. To fully receive the discount benefit you need to make sure that all your Redshift reservation purchases have been successfully completed (i.e. the RNs status is "active").

Audit

To identify any failed Redshift RN purchases available in your AWS account, perform the following:

Using AWS Console

01 Sign in to the AWS Management Console.

02 Navigate to Redshift dashboard at https://console.aws.amazon.com/redshift/.

03 In the navigation panel choose Reserved Nodes.

04 Open the dashboard Show/Hide Columns dialog box by clicking the configuration icon from the right menu:

Show/Hide Columns

05 Inside the Show/Hide Columns dialog box, select Status checkbox:

Show/Hide Columns

then click Save to apply the changes.

06 On Redshift Reserved Nodes listing page, verify the status value displayed for each RN within the Status column to determine the node reservation status. If one or more AWS Redshift RNs have the status set to payment-failed, the purchase payment processing for the listed Reserved Node(s) has failed, therefore you need to retry your failed reservation(s) payment by contacting AWS Support Center (see Remediation/Resolution section for more information).

07 Change the AWS region from the navigation bar and repeat the entire audit process for other regions.

Using AWS CLI

01 Run describe-reserved-nodes command (OSX/Linux/UNIX) using custom query filters to list the IDs of all Redshift RN purchases, available in the selected AWS region: 

aws redshift describe-reserved-nodes
    --region us-east-1
    --output table
    --query 'ReservedNodes[*].ReservedNodeId'

02 The command output should return a table with the requested Reserved Node(s) ID(s): 

----------------------------------------
|           ReservedNodeIds            |
+--------------------------------------+
| a4d03e93-422a-b61d-af5b-a8e2e3093d5e |
| 5bda8e2e-bc01-4d65-b35d-a4a3e931bd3d |
+--------------------------------------+

03 Run again describe-reserved-nodes command (OSX/Linux/UNIX) using the ID of the AWS Redshift RN returned at the previous step as identifier and custom query filters to describe the purchase status for the selected Reserved Node: 

aws redshift describe-reserved-nodes
    --region us-east-1
    --reserved-node-id a4d03e93-422a-b61d-af5b-a8e2e3093d5e
    --query 'ReservedNodes[*].State'

04 The command output should return the requested RN purchase payment status: 

[
    "payment-failed"
]

If the status value returned by the command output is "payment-failed", the selected Redshift Reserved Node purchase has failed, therefore you must retry your failed RN(s) payment by contacting AWS Support Center using the support console available at https://console.aws.amazon.com/support/.

05 Change the AWS region by updating the --region command parameter value and repeat steps no. 1 – 4 to perform the entire process for other regions.

Remediation / Resolution

To resolve any unsuccessful AWS Redshift reservations you need to retry your failed Redshift Reserved Node(s) purchases payment by contacting Amazon Web Services. To create the required support case through the AWS Support Center, perform the following:

Note 1: Failed AWS Redshift Reserved Node (RN) purchases from previous billing periods cannot be retried.
Note 2: Requesting Amazon to retry your failed Redshift Reserved Node(s) payment using AWS Billing and Cost Management console or AWS API via Command Line Interface (CLI) is not currently supported.

Using AWS Console

01 Sign in to the AWS Management Console.

02 Navigate to AWS Support Center page at https://console.aws.amazon.com/support/.

03 On Support Center page, click Create case to access the support case form.

04 On the Create Case page, perform the following:

  1. Under Regarding, select Account and Billing Support option.
  2. Choose Billing from the Service dropdown list to send your request to AWS Billing and Cost Management service.
  3. Select Reserved Instances from the Category dropdown list.
  4. Inside the Subject box, enter a subject for your request such as "Retry failed Redshift Reserved Node payment".
  5. Within Description textbox, enter a small description for your request so that AWS support can evaluate faster your request.
  6. Under Contact method, select a preferred contact method that AWS support team can use to respond to your request. If your need is urgent, choose Phone as contact method to request a direct phone call.
  7. Click Submit to send the payment retry request for your Redshift Reserved Node(s) to Amazon Web Services.

References

Publication date Mar 7, 2017

Related Redshift rules