Ask Your Question
0

openstack queens octavia load balancer

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

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

edit retag flag offensive close merge delete

Comments

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 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
0

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

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,

Michael

edit flag offensive delete link more

Comments

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 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

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

Seen: 60 times

Last updated: Sep 04