I have Amazon Relational Database Service (Amazon RDS) or Amazon Redshift queries that are running during a maintenance window. What happens to queries that are running during a maintenance window?

Amazon RDS maintenance

The Amazon RDS Maintenance Window usually involves updates to the DB instance's operating system (OS), to the database engine version, or to the cluster version. If maintenance requires an instance reboot or an engine restart, then queries and transactions that are running are terminated and uncommitted transactions are rolled back during the engine restart to ensure Atomicity, Consistency, Isolation, and Durability (ACID) compliance. You must re-run the queries or transactions that are terminated.

Amazon Redshift maintenance

Amazon Redshift Maintenance Windows require the cluster to go offline or to restart during scheduled maintenance. If queries are running during scheduled maintenance, then queries are terminated and rolled back. To view which queries were terminated, see SVL_QLOG. It's a best practice to Schedule Around Maintenance Windows—especially long-running operations, such as large data loads or VACUUM operations. For more information, see Amazon Redshift Best Practices.

Note: If the maintenance does not require a restart for the DB engine, cluster, or instance, then queries are not affected.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2018-08-24