<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi,</p>
    <p>i run into a issue where one of the Octavia LB amphora VMs was
      crashed and since the loadbalancer operating_status become
      PENDING_UPDATE (or ERROR) it is no longer possible to use the
      OpenStack CLI tools to manage the LB:<br>
    </p>
    <p>openstack loadbalancer amphora list --loadbalancer
      0ce30f0e-1d75-486c-a09f-79125abf44b8<br>
+--------------------------------------+--------------------------------------+-----------+--------+---------------+-------------+<br>
      | id                                   |
      loadbalancer_id                      | status    | role   |
      lb_network_ip | ha_ip       |<br>
+--------------------------------------+--------------------------------------+-----------+--------+---------------+-------------+<br>
      | daee2f88-01fd-4ffa-b80d-15c63771d99d |
      0ce30f0e-1d75-486c-a09f-79125abf44b8 | ERROR     | BACKUP |
      172.10.10.30 | 172.11.12.26 |<br>
      | f22186b1-2865-4f4a-aae2-7f869b7aae12 |
      0ce30f0e-1d75-486c-a09f-79125abf44b8 | ALLOCATED | MASTER |
      172.10.10.5  | 172.11.12.26 |<br>
+--------------------------------------+--------------------------------------+-----------+--------+---------------+-------------+</p>
    <p>openstack loadbalancer show 0ce30f0e-1d75-486c-a09f-79125abf44b8<br>
      +---------------------+--------------------------------------+<br>
      | Field               | Value                                |<br>
      +---------------------+--------------------------------------+<br>
      | admin_state_up      | True                                 |<br>
      | created_at          | 2019-05-19T09:48:12                  |<br>
      | description         |                                      |<br>
      | flavor              |                                      |<br>
      | id                  | 0ce30f0e-1d75-486c-a09f-79125abf44b8 |<br>
      | listeners           | 12745a48-7277-405f-98da-e7b9fbaf93cc |<br>
      | name                | foo-lb1                      |<br>
      | operating_status    | ONLINE                               |<br>
      | pools               | 482985f9-2804-4960-bd93-6bbb798b57f7 |<br>
      | project_id          | 76e81458c81f6e2xebbbfc81f6bb76e008d |<br>
      | provider            | amphora                              |<br>
      | provisioning_status | PENDING_UPDATE                       |<br>
      | updated_at          | 2019-06-25T16:58:33                  |<br>
      | vip_address         | 172.11.12.26                          |<br>
      | vip_network_id      | 8cc0f284-613c-40a7-ac72-c83ffdc26a93 |<br>
      | vip_port_id         | f598aac4-4bd0-472b-9b9c-e4e305cb561b |<br>
      | vip_qos_policy_id   | None                                 |<br>
      | vip_subnet_id       | e1478576-23b0-40e8-b4f2-5b284f2b23c4 |<br>
      +---------------------+--------------------------------------+</p>
    <p>I was able to fix this by update the load_balancer state to
      'ACTIVE' directly in the Octavia Database and trigger a failover:<br>
    </p>
    <p><span style="color: rgb(0, 0, 0); font-family: Consolas,
        "Bitstream Vera Sans Mono", "Courier New",
        Courier, monospace; font-size: 14px; font-style: normal;
        font-variant-ligatures: normal; font-variant-caps: normal;
        font-weight: 400; letter-spacing: normal; orphans: 2;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: nowrap; widows: 2; word-spacing: 0px;
        -webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
        255); text-decoration-style: initial; text-decoration-color:
        initial; display: inline !important; float: none;">MySQL
        [octavia]><span> </span></span>update load_balancer set
      provisioning_status = 'ACTIVE' where id =
      '0ce30f0e-1d75-486c-a09f-79125abf44b8';<br>
      <br>
      <span style="color: rgb(0, 0, 0); font-family: Consolas,
        "Bitstream Vera Sans Mono", "Courier New",
        Courier, monospace; font-size: 14px; font-style: normal;
        font-variant-ligatures: normal; font-variant-caps: normal;
        font-weight: 400; letter-spacing: normal; orphans: 2;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: nowrap; widows: 2; word-spacing: 0px;
        -webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
        255); text-decoration-style: initial; text-decoration-color:
        initial; display: inline !important; float: none;">openstack
        loadbalancer failover 0ce30f0e-1d75-486c-a09f-79125abf44b8</span></p>
    <p><span style="color: rgb(0, 0, 0); font-family: Consolas,
        "Bitstream Vera Sans Mono", "Courier New",
        Courier, monospace; font-size: 14px; font-style: normal;
        font-variant-ligatures: normal; font-variant-caps: normal;
        font-weight: 400; letter-spacing: normal; orphans: 2;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: nowrap; widows: 2; word-spacing: 0px;
        -webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
        255); text-decoration-style: initial; text-decoration-color:
        initial; display: inline !important; float: none;"><br>
        But this seams to by more a workaround the a proper way to </span><span
        style="color: rgb(0, 0, 0); font-family: Consolas,
        "Bitstream Vera Sans Mono", "Courier New",
        Courier, monospace; font-size: 14px; font-style: normal;
        font-variant-ligatures: normal; font-variant-caps: normal;
        font-weight: 400; letter-spacing: normal; orphans: 2;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: nowrap; widows: 2; word-spacing: 0px;
        -webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
        255); text-decoration-style: initial; text-decoration-color:
        initial; display: inline !important; float: none;"><span
          style="color: rgb(0, 0, 0); font-family: Consolas,
          "Bitstream Vera Sans Mono", "Courier New",
          Courier, monospace; font-size: 14px; font-style: normal;
          font-variant-ligatures: normal; font-variant-caps: normal;
          font-weight: 400; letter-spacing: normal; orphans: 2;
          text-align: left; text-indent: 0px; text-transform: none;
          white-space: nowrap; widows: 2; word-spacing: 0px;
          -webkit-text-stroke-width: 0px; background-color: rgb(255,
          255, 255); text-decoration-style: initial;
          text-decoration-color: initial; display: inline !important;
          float: none;">restart / repair the loadbalancer without a
          interfare in the OpenStack DB manually.</span></span></p>
    <p><span style="color: rgb(0, 0, 0); font-family: Consolas,
        "Bitstream Vera Sans Mono", "Courier New",
        Courier, monospace; font-size: 14px; font-style: normal;
        font-variant-ligatures: normal; font-variant-caps: normal;
        font-weight: 400; letter-spacing: normal; orphans: 2;
        text-align: left; text-indent: 0px; text-transform: none;
        white-space: nowrap; widows: 2; word-spacing: 0px;
        -webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
        255); text-decoration-style: initial; text-decoration-color:
        initial; display: inline !important; float: none;"><span
          style="color: rgb(0, 0, 0); font-family: Consolas,
          "Bitstream Vera Sans Mono", "Courier New",
          Courier, monospace; font-size: 14px; font-style: normal;
          font-variant-ligatures: normal; font-variant-caps: normal;
          font-weight: 400; letter-spacing: normal; orphans: 2;
          text-align: left; text-indent: 0px; text-transform: none;
          white-space: nowrap; widows: 2; word-spacing: 0px;
          -webkit-text-stroke-width: 0px; background-color: rgb(255,
          255, 255); text-decoration-style: initial;
          text-decoration-color: initial; display: inline !important;
          float: none;">Is there a another way accomplish this with the
          CLI?</span></span><span style="color: rgb(0, 0, 0);
        font-family: Consolas, "Bitstream Vera Sans Mono",
        "Courier New", Courier, monospace; font-size: 14px;
        font-style: normal; font-variant-ligatures: normal;
        font-variant-caps: normal; font-weight: 400; letter-spacing:
        normal; orphans: 2; text-align: left; text-indent: 0px;
        text-transform: none; white-space: nowrap; widows: 2;
        word-spacing: 0px; -webkit-text-stroke-width: 0px;
        background-color: rgb(255, 255, 255); text-decoration-style:
        initial; text-decoration-color: initial; display: inline
        !important; float: none;"><br>
      </span></p>
    <p>BR</p>
    <p>Pawel</p>
  </body>
</html>