MV_REBALANCE_STATUS

This view contains information about the status of REBALANCE commands such as REBALANCE ALL DATABASES and REBALANCE PARTITIONS.

Column Name

Description

DATABASE_NAME

The name of the database the REBALANCE command is running on or within.

ACTION

The action being performed: either COPY PARTITION or PROMOTE PARTITION.

ORDINAL

The ID of the related partition.

The Ordinal is the target partition’s ordinal, and the Target_Host and Target_Port correspond to the destination leaf. Any two operations in the same Phase can be run in parallel and phases are run in order. For example, the aggregator can run COPY PARTITION on partitions test:1 and test:3 in parallel. The exact meaning of what each phase means is arbitrary and depends on the particular rebalance operation. The Estimated_Time_Remaining_Ms is the estimated total time (in milliseconds) that each low-level command will take to complete.

TARGET_HOST

The target hostname or IP address of a REBALANCE command.

TARGET_PORT

The target port number of a REBALANCE command.

PHASE

The phase (group of actions occurring at the same time) that a given action is part of.

STATUS

The status of the REBALANCE. A REBALANCE consists of multiple commands that are run in phases. Can be one of:

  • cancelled - the command was cancelled (can happen if a rebalance is terminated)

  • failed - the command failed to complete

  • running - the command is currently in process

  • scheduled - the command is scheduled to run

  • success - the command ran successfully

Querying rebalance status during an ongoing rebalance will show some combination of success, running, and scheduled rows where the phases that completed already will show 'success', the phase that is currently ongoing will show that they are 'running', and the phases that must come next will show that they are 'scheduled'.

RUNNING_TIME_MS

The amount of time in milliseconds spent on a given action.

ESTIMATED_TIME_REMAINING_MS

The estimated amount of time in milliseconds remaining for a given action.

Last modified: November 16, 2022

Was this article helpful?