MariaDB [octavia]>  select * from amphora where load_balancer_id = '983c9b7c-6874-40a0-b626-d7694ddd93e6';
+--------------------------------------+--------------------------------------+--------+--------------------------------------+---------------+--------------+--------------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+-------------+---------------------+---------------------+--------------------------------------+--------------------------------------+
| id                                   | compute_id                           | status | load_balancer_id                     | lb_network_ip | vrrp_ip      | ha_ip        | vrrp_port_id                         | ha_port_id                           | role       | cert_expiration     | cert_busy | vrrp_interface | vrrp_id | vrrp_priority | cached_zone | created_at          | updated_at          | image_id                             | compute_flavor                       |
+--------------------------------------+--------------------------------------+--------+--------------------------------------+---------------+--------------+--------------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+-------------+---------------------+---------------------+--------------------------------------+--------------------------------------+
| 153a6d53-a9cc-45f9-b189-5caf7f323609 | 5433c4c0-897f-41e0-862f-21b9597c9b50 | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.44    | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | STANDALONE | 2019-07-24 13:14:50 |         1 | NULL           |       1 |          NULL | pod04       | 2019-06-24 13:14:50 | 2019-08-05 13:06:40 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| 501f07c5-b430-4f77-bf0c-1ee7c8b9e696 | 38cd5075-88a9-43dc-ade5-5819f31460b9 | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.48    | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 08:49:23 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 08:49:23 | 2019-08-05 08:56:24 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| 7282e542-d38f-47eb-82cc-672cf23dc51a | 499804e0-7b98-4885-b600-2eb3a2569560 | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.5     | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 09:48:51 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 09:48:51 | 2019-08-05 13:07:40 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| 97f6535e-e4e5-4696-b179-89286f2ff62c | 34a571ab-9b0a-4e83-bf84-5199651216e5 | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.6     | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 08:55:40 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 08:55:40 | 2019-08-05 09:09:00 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| b5ebf719-77fa-4299-83c0-fe807601e224 | 56ae7c85-e1a6-4e7f-b595-b8b55abf0af6 | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.13    | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 08:03:44 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 08:03:44 | 2019-08-05 08:59:10 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| bbc43fef-1506-4341-b3a2-8805897ef27d | 2633f9dd-539f-4ea0-bf7c-977783e08ccc | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.5     | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 08:58:06 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 08:58:06 | 2019-08-05 09:13:54 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
| ec08d7b3-a261-4a0b-ad94-1e97e426ee7a | 9ef3090a-a249-4dc0-a7c3-077d3158dd1c | ERROR  | 983c9b7c-6874-40a0-b626-d7694ddd93e6 | 10.22.0.21    | 192.168.81.8 | 192.168.81.6 | 5891db34-622b-40c5-88ad-a08919ad0da0 | 42a01db7-0b95-49fd-afd1-cbe96c713b4a | NULL       | 2019-09-04 09:08:11 |         0 | NULL           |       1 |          NULL | pod04       | 2019-08-05 09:08:11 | 2019-08-05 13:10:19 | cfa02d63-4af0-4a7e-919a-b41ca7eb5a4c | d9f157b5-3f39-4a9a-99fc-5fe602904b27 |
+--------------------------------------+--------------------------------------+--------+--------------------------------------+---------------+--------------+--------------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+-------------+---------------------+---------------------+--------------------------------------+--------------------------------------+