Product DocumentationAppearance
sys.blade
This system view returns status information about the blades in an appliance.
| Column Name | Data Type | Description |
|---|---|---|
| blade_id | text | UUID for the blade |
| chassis_id | integer | 0 for a single-chassis appliance; 0 or 1 for a dual-chassis appliance. |
| name | text | Name: dm1, dm2, and so on. |
| status | text | Current status, such as ok or not_installed. |
| blade_state | text | Current state, such as WORKER_REGISTERED or NOT_INSTALLED. |
| blade_state_timestamp | timestamptz | When the blade went into the current state |
| powered_on | boolean | True or false |
| bios_version | text | BIOS version |
| ip_address | text | IP address |
| mac_address | text | MAC address |
| bay_slot | bigint | Bay number |
| led_yellow | boolean | True or false |
| led_blue | boolean | True or false |
| led_red | boolean | True or false |
| operating_system | text | ybos or off |
Example
For example:
yellowbrick_test=# select * from sys.blade where chassis_id=1;
-[ RECORD 1 ]---------+-------------------------------------
blade_id | 00000000-0000-0000-0000-38b8ebd00cad
chassis_id | 1
name | dm1
status | ok
blade_state | WORKER_REGISTERED
blade_state_timestamp | 2018-07-07 01:27:44.031-07
powered_on | t
bios_version | 05.04.21.0038.00.004
ip_address | 192.168.10.10
mac_address | 38:b8:eb:d0:0c:ad
bay_slot | 1
led_yellow | t
led_blue | f
led_red | f
operating_system | ybos
-[ RECORD 2 ]---------+-------------------------------------
blade_id | 00000000-0000-0000-0000-38b8ebd00c76
chassis_id | 1
name | dm10
status | ok
blade_state | WORKER_REGISTERED
blade_state_timestamp | 2018-07-07 01:27:50.399-07
powered_on | t
bios_version | 05.04.21.0038.00.004
ip_address | 192.168.10.19
mac_address | 38:b8:eb:d0:0c:76
bay_slot | 10
led_yellow | t
led_blue | f
led_red | f
operating_system | ybos
...Blade States
- NOT_INSTALLED
- The blade is not installed and the bay is empty.
- POWERED_ON
- The blade is booting up, but is not ready yet.
- POWERED_ON_OFFLINE
- The blade is powered on but is unavailable.
- POST
- Performing self-test after powering on.
- YBOS_BOOTING
- The operating system is booting up.
- YBOS_BOOTED
- The operating system is booted and running.
- KERNEL_BOOTED
- System is booted, freeing unused memory.
- FLASHING_BIOS
- Maintenance state only.
- FLASHING_INFINIBAND
- Maintenance state only.
- WORKER_STARTING
- The worker is starting up.
- NETWORK_READY
- The network link is ready.
- WORKER_FAILED
- Worker failed and is restarting.
- WORKER_FAILED_REGISTRATION
- The worker was unable to register with the cluster manager.
- WORKER_ERROR
- Worker error, reported from the Lime compiler.
- WORKER_REGISTERED
- The worker is registered with the cluster manager and is ready.
- POWERED_OFF
- The blade is stopped.
- ERROR
- The Chassis Manager Processor is reporting that the blade is in an error state.
- UNKNOWN_EVENT
- Unable to determine state.