Compute Node not in database

ofrommel

While working on Lab 3.4 I tried to remove the "compute-node" from the Compute Hosts, but I couldn't find it in the database. The SQL select shows only one host "devstack-cc", but the other compute host "compute-node" is still listed in the BUI. What am I doing wrong?

mysql> select * from compute_nodes;

+---------------------+---------------------+------------+----+------------+-------

+-----------+----------+------------+----------------+---------------+-------------

----+--------------------+---------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

----------------------+----------------------+-------------+--------------+--------

----------+-------------+---------------------+---------+--------------+-----------

-------------------------------------------+-----------+---------+-----------------

+----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

------------------------------------------------+---------------+-------------+----

------------------+----------------------+

| created_at | updated_at | deleted_at | id | service_id | vcpus

| memory_mb | local_gb | vcpus_used | memory_mb_used | local_gb_used | hypervisor_t

ype | hypervisor_version | cpu_info

| disk_available_least | free_ram_mb | free_disk_gb | current

_workload | running_vms | hypervisor_hostname | deleted | host_ip | supported_

instances | pci_stats | metrics | extra_resources

| stats

| numa_topology | host | ram

_allocation_ratio | cpu_allocation_ratio |

+---------------------+---------------------+------------+----+------------+-------

+-----------+----------+------------+----------------+---------------+-------------

----+--------------------+---------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

----------------------+----------------------+-------------+--------------+--------

----------+-------------+---------------------+---------+--------------+-----------

-------------------------------------------+-----------+---------+-----------------

+----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

------------------------------------------------+---------------+-------------+----

------------------+----------------------+

| 2016-02-26 16:09:10 | 2016-02-26 16:38:40 | NULL | 1 | NULL | 2

| 3948 | 157 | 3 | 2048 | 3 | QEMU

| 2000000 | {"vendor": "AMD", "model": "qemu32", "arch": "x86_64", "

features": ["pge", "clflush", "sep", "syscall", "vme", "tsc", "cmov", "fpu", "pat",

"lm", "msr", "3dnowprefetch", "nx", "fxsr", "pae", "sse4a", "3dnowext", "mmx", "cx

8", "mce", "fxsr_opt", "cr8legacy", "mca", "pse", "pni", "abm", "popcnt", "apic", "

sse", "3dnow", "lahf_lm", "mmxext", "sse2", "hypervisor", "misalignsse", "tsc-deadl

ine", "de", "cx16", "mtrr", "x2apic"], "topology": {"cores": 1, "cells": 1, "thread

s": 1, "sockets": 2}} | 144 | 1900 | 154 |

0 | 3 | devstack-cc | 0 | 192.168.97.1 | [["i686",

"qemu", "hvm"], ["x86_64", "qemu", "hvm"[[ | NULL | [] | NULL

| {"num_task_None": "3", "num_proj_d5747ccbcd534da2b37084dabb945f7e": "1", "io_work

load": "0", "num_instances": "3", "num_proj_6f85bc7532044976a313fd35679d06f5": "2",

"num_os_type_None": "3", "num_vm_active": "3"} | NULL | devstack-cc |

0 | 0 |

+---------------------+---------------------+------------+----+------------+-------

+-----------+----------+------------+----------------+---------------+-------------

----+--------------------+---------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

----------------------+----------------------+-------------+--------------+--------

----------+-------------+---------------------+---------+--------------+-----------

-------------------------------------------+-----------+---------+-----------------

+----------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

------------------------------------------------+---------------+-------------+----

------------------+----------------------+

1 row in set (0.00 sec)

Another question on the preconfigured lab links: When I click on them I am supposed to get a preconfigured environment, right? Just to rule out I made a mistake while working up to that point ...

ofrommel

P.S. I tried to upload a screenshot of the BUI to this post. This seems to have failed with an error "Warning! - Failed to move file."

serewicz

Thank you for the feedback. I was able to reproduce the issue you are seeing, the compute node has not been added to the cluster as it should have been. I am contacting the infrastructure team to fix it.