openstack queens octavia load balancer

asked 2018-08-21 19:57:03 -0600

tony.pearce gravatar image

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         |                         |
| 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:

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.

edit retag flag offensive close merge delete


I logged into the db and ran some checks. My db skills are a bit weak but the table has a default of 'NULL'. From what I can find out from Mrs. Google was that this is normal but I do not understand why it's throwing an error.

tony.pearce gravatar imagetony.pearce ( 2018-08-21 20:53:11 -0600 )edit

2 answers

Sort by ยป oldest newest most voted

answered 2018-09-04 10:06:00 -0600

johnsom gravatar image

Hi there,

I am not an RDO expert, so I'm going to take some guesses here.

From the look of the bottom error, it appears that the database migration did not occur. In basic devstack deployments we use a tool to do this migration:

octavia-db-manage --config-file /etc/octavia/octavia.conf upgrade head

Give that a try,


edit flag offensive delete link more


Hi, thanks for your message. Is octavia LB only a feature of RDO? We managed to fix the issue somehow. I did run the db upgrade command again previously, seemed to go ok. It may have been an amphorae issue. The appalling documentation has been the main issue here. Still unable to get horizon working

tony.pearce gravatar imagetony.pearce ( 2018-09-04 18:06:22 -0600 )edit

answered 2018-10-01 22:15:37 -0600

easy gravatar image

I have same issue in horizon dashboard, the load balancer page keep loading. I upgraded to queens from pike via openstack-ansible.

I fixed it by recompressing static and restarting apache2

/openstack/venvs/horizon-17.1.0/bin/ collectstatic
/openstack/venvs/horizon-17.1.0/bin/ compress
systemctl reload apache2
edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools



Asked: 2018-08-21 19:57:03 -0600

Seen: 784 times

Last updated: Oct 01 '18