Aws Redshift Maintenance Is Killing My Jobs What A Waste Of Time
The concern is documenting the practice of AWS Redshift maintenance windows and the fact is it killing my load-jobs
When trying to perform a data-loading job I am getting the following error and need to… resume manually !
Data loading error [Amazon](500150) Error setting/closing connection: Connection refused.
1. on maintenance
If a scheduled maintenance occurs while a query is running, the query is terminated and rolled back and you need to restart it. Schedule long-running operations, such as large data loads or VACUUM operation, to avoid maintenance windows. You can also minimize the risk, and make restarts easier when they are needed, by performing data loads in smaller increments and managing the size of your VACUUM operations. For more information, see Load data in sequential blocks and Vacuuming tables.
Amazon Redshift assigns a 30-minute maintenance window at random from an 8-hour block of time per AWS Region, occurring on a random day of the week (Monday through Sunday, inclusive).
The following list shows the time blocks for each AWS Region from which the default maintenance windows are assigned:REGION | TIME
US East (N. Virginia) Region | 03:00–11:00 UTC
US East (Ohio) Region | 03:00–11:00 UTC
US West (N. California) Region | 06:00–14:00 UTC
Gets and sets the property PreferredMaintenanceWindow. The weekly time range (in UTC) during which system maintenance can occur, if necessary. If system maintenance is necessary during the window, it may result in an outage. This maintenance window change is made immediately. If the new maintenance window indicates the current time, there must be at least 120 minutes between the current time and end of the window in order to ensure that pending changes are applied.
"preferredMaintenanceWindow" : "tue:06:30-tue:07:00",
- this is exactly the time I am getting the “outage”