Product Documentation

Appearance

7.1.2
7.0.2
6.9.3
5.4.17
5.2.31

sys.log_warning ​

This view logs warning messages returned by the system. This view does not log SQL warnings.

Column NameData TypeDescription
event_iduuidUnique ID for the event (warning).
event_timetimestamptzTimestamp when the event (warning) occurred.
acknowledgedbooleanWhether the user has acknowledged the warning on the SMC System Events screen, where this data is also visible.
warning_codetext
warning_msgtextText of the warning message.

Example ​

For example:

yellowbrick=# select * from sys.log_warning where warning_code like 'worker%';
              event_id               |         event_time         | query_id | acknowledged |                warning_code                 |                     warning_msg                     
--------------------------------------+----------------------------+----------+--------------+---------------------------------------------+-----------------------------------------------------
 3ed4d27a-d425-4f0a-899b-edd3f21e80ea | 2017-06-14 07:34:53.899-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd00721 | Worker 00000000-0000-0000-0000-38b8ebd00721 crashed
 d677f571-71c6-4b52-b8a5-c026f3ab9e35 | 2017-06-14 07:34:53.899-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd005aa | Worker 00000000-0000-0000-0000-38b8ebd005aa crashed
 904f5358-7358-4619-a4b4-922f4fa56935 | 2017-06-14 07:34:53.921-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd00505 | Worker 00000000-0000-0000-0000-38b8ebd00505 crashed
 cce7be2f-4765-49cf-bbe9-a04e3b5eedde | 2017-06-14 07:34:53.921-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd00631 | Worker 00000000-0000-0000-0000-38b8ebd00631 crashed
 49d0344d-2fcc-4651-a928-197b75b40ec8 | 2017-06-14 07:34:53.928-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd00640 | Worker 00000000-0000-0000-0000-38b8ebd00640 crashed
 db5db579-1b01-436f-883e-da6f0024d129 | 2017-06-14 07:34:53.928-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd0067c | Worker 00000000-0000-0000-0000-38b8ebd0067c crashed
 29461df0-8df4-47e1-ad0b-0533d04af1f4 | 2017-06-14 07:34:53.934-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd005d2 | Worker 00000000-0000-0000-0000-38b8ebd005d2 crashed
 af5b52af-735c-4fa9-b5bd-bed385f234a5 | 2017-06-14 07:34:53.935-07 |          | f            | worker:00000000-0000-0000-0000-38b8ebd00410 | Worker 00000000-0000-0000-0000-38b8ebd00410 crashed

Parent topic:System Views