Skip to main content
Version: Latest-3.3

SHOW BACKEND BLACKLIST

Description

Shows the BE nodes in the BE Blacklist.

This feature is supported from v3.3.0 onwards. For more information, see Manage BE Blacklist.

note

Only users with the SYSTEM-level BLACKLIST privilege can perform this operation.

Syntax

SHOW BACKEND BLACKLIST

Return value

ReturnDescription
AddBlackListTypeHow the BE node was added to the blacklist. MANUAL indicates it is manually blacklisted by the user. AUTO indicates it is automatically blacklisted by StarRocks.
LostConnectionTimeFor the MANUAL type, it indicates the time when the BE node was manually added to the blacklist.
For the AUTO type, it indicates the time when the last successful connection was established.
LostConnectionNumberInPeriodThe number of disconnections detected within CheckTimePeriod(s).
CheckTimePeriod(s)The interval at which StarRocks checks the connection status of the blacklisted BE nodes. Its value is evaluated to the value you specified for the FE configuration item black_host_history_sec. Unit: Seconds.

Examples

SHOW BACKEND BLACKLIST;
+-----------+------------------+---------------------+------------------------------+--------------------+
| BackendId | AddBlackListType | LostConnectionTime | LostConnectionNumberInPeriod | CheckTimePeriod(s) |
+-----------+------------------+---------------------+------------------------------+--------------------+
| 10001 | MANUAL | 2024-04-28 11:52:09 | 0 | 5 |
+-----------+------------------+---------------------+------------------------------+--------------------+

Relevant SQLs