Why am I unable to change the maintenance track for my Amazon Redshift provisioned cluster?
4 minute read
I'm unable to change the maintenance track for my Amazon Redshift provisioned cluster.
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.
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.
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.