Product DocumentationAppearance
sys.log_warning
This view logs system-level warning messages logged on the appliance. This view does not log SQL warnings.
| Column Name | Data Type | Description |
|---|---|---|
| event_id | uuid | Unique ID for the event (warning). |
| event_time | timestamptz | Timestamp when the event (warning) occurred. |
| acknowledged | boolean | Whether the user has acknowledged the warning on the SMC System Events screen, where this data is also visible. |
| warning_code | text | Warning code, such as system. |
| warning_msg | text | Text of the warning message. |
Example
For example:
yellowbrick=# select * from sys.log_warning where warning_code='system';
-[ RECORD 1 ]+------------------------------------------------------------------------------------------------
event_id | e138fda6-e691-4825-834c-3e25be2829bb
event_time | 2020-10-09 09:23:47.713-07
query_id | [NULL]
acknowledged | f
warning_code | system
warning_msg | Worker 00000000-0000-0000-0000-38b8ebd002a3 logical id: 17 has gone offline at 7858526678238244
-[ RECORD 2 ]+------------------------------------------------------------------------------------------------
event_id | 75a6fe72-c0e3-49fd-9a43-53baf1a95d9f
event_time | 2020-10-11 14:34:00.662-07
query_id | [NULL]
acknowledged | f
warning_code | system
warning_msg | Worker 00000000-0000-0000-0000-38b8ebd002a3 logical id: 17 has gone offline at 8049939633529310
-[ RECORD 3 ]+------------------------------------------------------------------------------------------------
event_id | 0890c719-2613-4a48-8f8d-a84cc29ac840
event_time | 2020-10-21 23:47:12.386-07
query_id | [NULL]
acknowledged | f
warning_code | system
warning_msg | Worker 00000000-0000-0000-0000-38b8ebd002a3 logical id: 17 has gone offline at 8947131356151761
-[ RECORD 4 ]+------------------------------------------------------------------------------------------------
event_id | d75affa6-d29b-4a23-a2e1-966d45a6116e
event_time | 2020-10-22 18:16:43.571-07
query_id | [NULL]
acknowledged | f
warning_code | system
warning_msg | Worker 00000000-0000-0000-0000-38b8ebd002a3 logical id: 17 has gone offline at 9013702550085108
-[ RECORD 5 ]+------------------------------------------------------------------------------------------------
event_id | de63aeea-cd4e-4aa1-85be-bd93ff9ccdf5
event_time | 2020-10-22 18:53:35.607-07
query_id | [NULL]
acknowledged | f
warning_code | system
warning_msg | Worker 00000000-0000-0000-0000-38b8ebd002a3 logical id: 17 has gone offline at 9015914587018051