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.

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.

Last modified: November 16, 2022

Was this article helpful?