Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

openstack queens octavia load balancer

We have an all-in-one deployment of openstack queens using rdo. We have tried to set up octavia but the documentation is a bit weak. The horizon link to the load balancers page is visible on the dashboard but when we click on it, the page just keeps showing the spinning loading icon and then refreshing. It looks like the link in horizon is added after installing "openstack-octavia-ui" package from yum but im not sure and unable to find out if specific dashboard configuration needs to be done.

Secondly, we have been unable to activate a deployed load balancer even after configuring listener, pool and healthcheck

$ openstack loadbalancer show tplb
WARNING: Failed to import plugin orchestration.
WARNING: Failed to import plugin baremetal.
+---------------------+--------------------------------------+
| Field               | Value                                |
+---------------------+--------------------------------------+
| admin_state_up      | True                                 |
| created_at          | 2018-08-21T06:56:40                  |
| description         |                                      |
| flavor              |                                      |
| id                  | e13afbb7-5810-4a37-9a21-ef9b7290062e |
| listeners           | 6b31cd53-abec-46e7-ab60-ce2d30a580c6 |
| name                | tplb                                 |
| operating_status    | OFFLINE                              |
| pools               | 344147be-f3cf-4798-ad97-089fdfdf24f1 |
| project_id          | a3b5c4b6770c4d4dabbde06c55c5d0d1     |
| provider            | octavia                              |
| provisioning_status | ACTIVE                               |
| updated_at          | 2018-08-21T07:09:00                  |
| vip_address         | 172.16.1.106                         |
| vip_network_id      | None                                 |
| vip_port_id         | 18554215-345f-49c1-ba31-6bfaf2a9ad59 |
| vip_qos_policy_id   | None                                 |
| vip_subnet_id       | 9a3c0f05-4b58-41a8-bddb-11fa72683bc1 |
+---------------------+--------------------------------------+

The operating status always says offline. Checking the logs, we see this in the health-manager.log:

2018-08-21 13:35:06.813 196242 ERROR octavia.controller.healthmanager.update_db [-] update_health encountered an unknown error: DBError: (pymysql.err.InternalError) (1364, u"Field 'amphora_id' doesn't have a dault value") [SQL: u'INSERT INTO amphora_health (last_update, busy) VALUES (%(last_update)s, %(busy)s)'] [parameters: {'busy': 0, 'last_update': datetime.datetime(2018, 8, 21, 8, 5, 6, 805390)}] (Background onhis error at: http://sqlalche.me/e/2j85)

I didn't set this up but trying to go through an install guide for Queens has been difficult. I would say that could be a misconfiguration somewhere but for the lack of a proper guide I am a bit stuck.