Help Center/ Data Warehouse Service/ User Guide/ DWS Cluster O&M/ Handling Abnormal DWS Clusters
Updated on 2026-07-08 GMT+08:00

Handling Abnormal DWS Clusters

Application Scenarios

  • Canceling the Read-only Status: A cluster in read-only status does not allow write operations. You can remove this status on the management console. Triggering the read-only status may be due to high disk usage, so you need to clean up the cluster data. For details, see Solution to High Disk Usage and Cluster Read-Only.
  • Performing a Primary/Standby Switchback: In the Unbalanced state, the number of primary instances on some nodes increases. As a result, the load pressure is high. In this case, the cluster can be operated, but the overall performance is not as good as that in a balanced state. You can perform a switchback to change the cluster status to Available.

Canceling the Read-only Status

You can cancel the read-only status of a cluster:

Notes and Constraints

  • The read-only status can be canceled for version 1.7.2 or later.
  • In 8.2.0 and later versions, you can free up disk space by using DROP/TRUNCATE TABLE in a read-only cluster.

Impact on the System

  • You can cancel the read-only status only when a cluster is read-only.
  • When a cluster is in read-only status, stop the write tasks to prevent data loss caused by used up disk space.
  • After the read-only status is canceled, clear the data as soon as possible to prevent the cluster from entering the read-only status again after a period of time.

Procedure

  1. Log in to the DWS console.
  2. In the navigation pane on the left, choose Cluster > Cluster List. All clusters are displayed by default.
  3. In the row containing the cluster whose cluster status is Read-only, click Cancel Read-only.
  4. In the dialog box that is displayed, click OK to confirm and remove the read-only status for the cluster.

Performing a Primary/Standby Switchback

You can perform a primary/standby switchback for a cluster.

Notes and Constraints

  • Only clusters running version 8.1.1.202 or later support primary/standby switchback.
  • The primary/standby switchback for a cluster interrupts services for a short period of time. The interruption duration depends on the service volume. You are advised to perform this operation during off-peak hours.

Procedure

  1. Log in to the DWS console.
  2. Choose Cluster > Cluster List and locate the cluster whose load is unbalanced.
  3. In the Cluster Status column of the cluster, click Fix under Unbalanced.

  4. In the dialog box that is displayed, confirm that the service is in off-peak hours, and click Yes. A message will be displayed in the upper right corner, indicating that the switchback request is being processed.
  5. Check the cluster status. During the switchback, the cluster status is Switching back. After the switchback, the cluster status will change to Available.