Why am I unable to change the maintenance track for my Amazon Redshift provisioned cluster?

Short description

Amazon Redshift periodically performs maintenance to apply upgrades to your cluster hardware or to perform software patches. During these updates, your Amazon Redshift cluster isn't available for normal operations. If a scheduled maintenance occurs while a query is running, then the query is terminated and rolled back.

Note: The following is applicable to only provisioned Amazon Redshift clusters.

If you have planned deployments for large data loads, ANALYZE, or VACUUM operations, you can defer maintenance for up to 45 days.

Important: You can't defer maintenance after the maintenance window has started.

You can make changes to the maintenance track to control the cluster version applied during a maintenance window. There are three maintenance tracks to choose from:

• Current – Use the most current approved cluster version.
• Trailing – Use the cluster version before the current version.
• Preview – Use the cluster version that contains new features available for preview.

Changes to maintenance tracks aren't allowed for the following situations:

• A Redshift cluster requires a hardware upgrade or a node of a Redshift cluster needs to be replaced.
• Mandatory upgrades or patches are required for a Redshift cluster.
• The maintenance track can't be set to Trailing for a Redshift cluster with the most current cluster version.
• If the Redshift provisioned cluster maintenance track is set to Preview, then changes from one Preview to another Preview track isn’t allowed.
• If the Redshift provisioned cluster track is set to Current or Trailing, then you can't change the maintenance track to Preview.

Resolution

Note: If a mandatory maintenance window is required for your Redshift cluster, AWS will send a notification before the start of the maintenance window.

Redshift cluster requires hardware upgrade or a node of a Redshift cluster needs to be replaced

Each new version change can include updates to the operating system, security, and functionality. AWS will send a notification and make the required changes. This happens automatically when there's a hardware update, or another mandatory update, and the cluster maintenance track is set to Current.

Your Amazon Redshift cluster isn't available during the maintenance window.

Mandatory upgrades or patches are required for Redshift cluster

Mandatory upgrades or patches are deployed for a particular cluster or for all clusters in an AWS Region. You will receive a notification before the mandatory upgrade or required patch.

AWS requires at least a 30-minute window in your instance's weekly schedule to confirm that all instances have the latest patches and upgrades. During the maintenance window, tasks are performed on clusters and instances. For the security and stability of your data, maintenance can cause instances to be unavailable.

Maintenance track can't be set to trailing for a Redshift cluster with the most current cluster version

If your cluster maintenance track isn't changing to Trailing, it's because your cluster is already using the most current approved cluster version. You must wait until the next new release becomes available for the current version to trail. After a new cluster version is released, you can change your cluster's maintenance track to Trailing and it will stay in Trailing for future maintenance. For more information, see Choosing cluster maintenance tracks.

Redshift provisioned cluster maintenance track set to preview

If your cluster maintenance track is set to use the Preview track, then switching from one Preview track to another isn't allowed.

If you restore a new Redshift cluster from a snapshot of an older cluster that used the Preview track, the following happens:

• The restored Redshift cluster inherits the source cluster’s maintenance track.
• The restored Redshift cluster can’t be changed to a different type of Preview maintenance track.

Redshift provisioned cluster maintenance track set to current or trailing

If Current or Trailing is selected for a provisioned Redshift cluster, then the maintenance track can't be changed to the Preview track.

---

Related information

Rolling back the cluster version

Why didn't Amazon Redshift perform any upgrades during the maintenance window?