yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1782296] [NEW] nova [ERROR (ClientException): Unexpected API Error.]

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: alexandrina <1782296@xxxxxxxxxxxxxxxxxx>
Date: Wed, 18 Jul 2018 06:28:29 -0000
Reply-to: Bug 1782296 <1782296@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

I tried to build instance using nova boot but when I do nova list there
unexpected API is error

Steps to reproduce
==================
(kolla-toolbox) nova boot --flavor b7da5913-7ff0-4758-971a-e9265dd4e261 --image c68f931b-47b2-4657-acf8-4e52aaafd75f --key-name Ubuntu-16QCOW2 --user-data /var/lib/kolla/config_files/myfile.txt --security-groups default Cirros
+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| Property                             | Value                                                                                                    |
+--------------------------------------+----------------------------------------------------------------------------------------------------------+
| OS-DCF:diskConfig                    | MANUAL                                                                                                   |
| OS-EXT-AZ:availability_zone          |                                                                                                          |
| OS-EXT-SRV-ATTR:host                 | -                                                                                                        |
| OS-EXT-SRV-ATTR:hostname             | cirros                                                                                                   |
| OS-EXT-SRV-ATTR:hypervisor_hostname  | -                                                                                                        |
| OS-EXT-SRV-ATTR:instance_name        |                                                                                                          |
| OS-EXT-SRV-ATTR:kernel_id            |                                                                                                          |
| OS-EXT-SRV-ATTR:launch_index         | 0                                                                                                        |
| OS-EXT-SRV-ATTR:ramdisk_id           |                                                                                                          |
| OS-EXT-SRV-ATTR:reservation_id       | r-yjv4w0nv                                                                                               |
| OS-EXT-SRV-ATTR:root_device_name     | -                                                                                                        |
| OS-EXT-SRV-ATTR:user_data            | I2Nsb3VkLWNvbmZpZwpwYXNzd29yZDogcHNpMTIzCmNocGFzc3dkOiB7IGV4cGlyZTogRmFsc2UgfQpzc2hfcHdhdXRoOiBUcnVlCg== |
| OS-EXT-STS:power_state               | 0                                                                                                        |
| OS-EXT-STS:task_state                | scheduling                                                                                               |
| OS-EXT-STS:vm_state                  | building                                                                                                 |
| OS-SRV-USG:launched_at               | -                                                                                                        |
| OS-SRV-USG:terminated_at             | -                                                                                                        |
| accessIPv4                           |                                                                                                          |
| accessIPv6                           |                                                                                                          |
| adminPass                            | pE2eMP6sv2Ay                                                                                             |
| config_drive                         |                                                                                                          |
| created                              | 2018-07-17T09:59:27Z                                                                                     |
| description                          | -                                                                                                        |
| flavor                               | Ubuntu (b7da5913-7ff0-4758-971a-e9265dd4e261)                                                            |
| hostId                               |                                                                                                          |
| host_status                          |                                                                                                          |
| id                                   | 7de09170-ce9d-4908-9f26-d573d4488821                                                                     |
| image                                | cirros2 (c68f931b-47b2-4657-acf8-4e52aaafd75f)                                                           |
| key_name                             | Ubuntu-16QCOW2                                                                                           |
| locked                               | False                                                                                                    |
| metadata                             | {}                                                                                                       |
| name                                 | Cirros                                                                                                   |
| os-extended-volumes:volumes_attached | []                                                                                                       |
| progress                             | 0                                                                                                        |
| security_groups                      | default                                                                                                  |
| status                               | BUILD                                                                                                    |
| tags                                 | []                                                                                                       |
| tenant_id                            | b76de65cb28f465d957ce2e76f284542                                                                         |
| updated                              | 2018-07-17T09:59:27Z                                                                                     |
| user_id                              | ca80261d88834979bb91ba17748facf2                                                                         |
+--------------------------------------+----------------------------------------------------------------------------------------------------------+

(kolla-toolbox)[root@centos-7 ~]# nova list
ERROR (ClientException): Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.ProgrammingError'> (HTTP 500) (Request-ID: req-62a92b16-6212-4f00-9b35-51a06e004cdd)

===============================================================================

Below are my nova-api.log
2018-07-18 13:23:36.179 29 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.180 25 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.181 27 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.182 29 INFO nova.metadata.wsgi.server [req-a1645f58-4f34-4075-83c9-f1720f508567 - - - - -] (29) wsgi exited, is_accepting=True
2018-07-18 13:23:36.182 25 INFO nova.osapi_compute.wsgi.server [req-051561e2-7640-4c3c-9650-e600b8728c75 - - - - -] (25) wsgi exited, is_accepting=True
2018-07-18 13:23:36.182 27 INFO nova.metadata.wsgi.server [req-a95696db-5302-4048-a376-e5bc63d2a615 - - - - -] (27) wsgi exited, is_accepting=True
2018-07-18 13:23:36.184 25 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.184 29 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.184 27 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.183 22 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.186 23 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.187 26 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.188 26 INFO nova.metadata.wsgi.server [req-6b76722b-d72d-449b-a18e-c06030c11df2 - - - - -] (26) wsgi exited, is_accepting=True
2018-07-18 13:23:36.179 28 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.189 24 INFO nova.wsgi [-] Stopping WSGI server.
2018-07-18 13:23:36.190 28 INFO nova.metadata.wsgi.server [req-da204b35-4cfa-44ad-a7b2-c989fbaa58e1 - - - - -] (28) wsgi exited, is_accepting=True
2018-07-18 13:23:36.191 24 INFO nova.osapi_compute.wsgi.server [req-15dd44c5-fca7-4cfb-8397-94c8574d5814 - - - - -] (24) wsgi exited, is_accepting=True
2018-07-18 13:23:36.192 28 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.192 22 INFO nova.osapi_compute.wsgi.server [req-831901fd-50eb-4c06-8793-1c9b0c5d81fa - - - - -] (22) wsgi exited, is_accepting=True
2018-07-18 13:23:36.193 22 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.193 26 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.195 23 INFO nova.osapi_compute.wsgi.server [req-83abb04d-d326-4309-aa36-53dd03f6a14b - - - - -] (23) wsgi exited, is_accepting=True
2018-07-18 13:23:36.196 23 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.200 24 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
2018-07-18 13:23:36.209 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Caught SIGTERM, stopping children
2018-07-18 13:23:36.211 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
2018-07-18 13:23:36.212 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
2018-07-18 13:23:36.212 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Waiting on 8 children to exit
2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 25 exited with status 0
2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 29 exited with status 0
2018-07-18 13:23:36.217 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 26 exited with status 0
2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 28 exited with status 0
2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 27 exited with status 0
2018-07-18 13:23:36.222 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 23 exited with status 0
2018-07-18 13:23:36.224 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 24 exited with status 0
2018-07-18 13:23:36.235 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 22 exited with status 0
2018-07-18 13:23:40.437 7 WARNING oslo_reports.guru_meditation_report [-] Guru meditation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
2018-07-18 13:23:40.625 7 WARNING oslo_config.cfg [-] Option "use_neutron" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
2018-07-18 13:23:40.668 7 INFO nova.compute.rpcapi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Automatically selected compute RPC version 4.13 from minimum service version 16
2018-07-18 13:23:41.099 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
2018-07-18 13:23:41.104 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
2018-07-18 13:23:41.464 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
2018-07-18 13:23:41.467 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
2018-07-18 13:23:41.480 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] osapi_compute listening on 192.168.100.14:8774
2018-07-18 13:23:41.480 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
2018-07-18 13:23:41.529 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] metadata listening on 192.168.100.14:8775
2018-07-18 13:23:41.530 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
2018-07-18 13:23:41.549 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "force_dhcp_release" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
2018-07-18 13:23:41.581 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_available_filters" from group "DEFAULT" is deprecated. Use option "available_filters" from group "filter_scheduler".
2018-07-18 13:23:41.582 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_default_filters" from group "DEFAULT" is deprecated. Use option "enabled_filters" from group "filter_scheduler".
2018-07-18 13:23:41.649 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_host_manager" from group "DEFAULT" is deprecated. Use option "host_manager" from group "scheduler".
2018-07-18 13:23:41.769 25 INFO nova.osapi_compute.wsgi.server [req-396e69be-d9c8-4499-a386-780e8f31c2d8 - - - - -] (25) wsgi starting up on http://192.168.100.14:8774
2018-07-18 13:23:41.812 23 INFO nova.osapi_compute.wsgi.server [req-3daefbdf-83d4-409e-878c-ff71bf342b32 - - - - -] (23) wsgi starting up on http://192.168.100.14:8774
2018-07-18 13:23:41.882 28 INFO nova.metadata.wsgi.server [req-7644075f-065f-4d8e-9b6b-363001ba7c38 - - - - -] (28) wsgi starting up on http://192.168.100.14:8775
2018-07-18 13:23:41.959 26 INFO nova.osapi_compute.wsgi.server [req-33a80f66-fe91-480c-80fe-bb99b81fceb2 - - - - -] (26) wsgi starting up on http://192.168.100.14:8774
2018-07-18 13:23:41.976 24 INFO nova.osapi_compute.wsgi.server [req-31b25d2c-8831-431e-950f-e68056c81da3 - - - - -] (24) wsgi starting up on http://192.168.100.14:8774
2018-07-18 13:23:41.983 30 INFO nova.metadata.wsgi.server [req-fece6f3c-3669-40c5-995f-0a20d6e08c2a - - - - -] (30) wsgi starting up on http://192.168.100.14:8775
2018-07-18 13:23:41.984 29 INFO nova.metadata.wsgi.server [req-1c855bc2-8d5b-49c3-8b1c-9992a6370139 - - - - -] (29) wsgi starting up on http://192.168.100.14:8775
2018-07-18 13:23:41.986 27 INFO nova.metadata.wsgi.server [req-37fa90b5-cd9e-47d3-8b52-31ff65019e63 - - - - -] (27) wsgi starting up on http://192.168.100.14:8775
2018-07-18 13:23:48.307 25 INFO nova.osapi_compute.wsgi.server [req-faeb3aad-646b-40a3-a448-939eca0fdbcd ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542 HTTP/1.1" status: 404 len: 331 time: 1.2246220
2018-07-18 13:23:48.318 25 INFO nova.osapi_compute.wsgi.server [req-caec31f0-3a56-4df8-9b01-3244ea647063 ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/ HTTP/1.1" status: 200 len: 721 time: 0.0084748
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] Unexpected exception in API method
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions Traceback (most recent call last):
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/extensions.py", line 338, in wrapped
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 214, in detail
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     servers = self._get_servers(req, is_detail=True)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 357, in _get_servers
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2488, in get_all
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2631, in _get_instances_by_filters
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     expected_attrs=fields, sort_keys=sort_keys, sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = fn(cls, context, *args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1227, in get_by_filters
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     use_slave=use_slave, sort_keys=sort_keys, sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 236, in wrapper
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1211, in _get_by_filters_impl
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 763, in instance_get_all_by_filters_sort
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 180, in wrapper
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 281, in wrapped
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(context, *args, **kwargs)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 2262, in instance_get_all_by_filters_sort
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return _instances_fill_metadata(context, query_prefix.all(), manual_joins)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2588, in all
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return list(self)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return self._execute_and_instances(context)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = conn.execute(querycontext.statement, self._params)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return meth(self, multiparams, params)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return connection._execute_clauseelement(self, multiparams, params)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     compiled_sql, distilled_params
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     util.raise_from_cause(newraise, exc_info)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     reraise(type(exception), exception, tb=exc_tb)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     cursor.execute(statement, parameters)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = self._query(query)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     conn.query(q)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 893, in query
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1103, in _read_query_result
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result.read()
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1396, in read
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     first_packet = self.connection._read_packet()
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1059, in _read_packet
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     packet.check_error()
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     err.raise_mysql_exception(self._data)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     raise errorclass(errno, errval)
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova_cell0.instances' doesn't exist") [SQL: u'SELECT anon_1.instances_created_at AS anon_1_instances_created_at, anon_1.instances_updated_at AS anon_1_instances_updated_at, anon_1.instances_deleted_at AS anon_1_instances_deleted_at, anon_1.instances_deleted AS anon_1_instances_deleted, anon_1.instances_id AS anon_1_instances_id, anon_1.instances_user_id AS anon_1_instances_user_id, anon_1.instances_project_id AS anon_1_instances_project_id, anon_1.instances_image_ref AS anon_1_instances_image_ref, anon_1.instances_kernel_id AS anon_1_instances_kernel_id, anon_1.instances_ramdisk_id AS anon_1_instances_ramdisk_id, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_launch_index AS anon_1_instances_launch_index, anon_1.instances_key_name AS anon_1_instances_key_name, anon_1.instances_key_data AS anon_1_instances_key_data, anon_1.instances_power_state AS anon_1_instances_power_state, anon_1.instances_vm_state AS anon_1_instances_vm_state, anon_1.instances_task_state AS anon_1_instances_task_state, anon_1.instances_memory_mb AS anon_1_instances_memory_mb, anon_1.instances_vcpus AS anon_1_instances_vcpus, anon_1.instances_root_gb AS anon_1_instances_root_gb, anon_1.instances_ephemeral_gb AS anon_1_instances_ephemeral_gb, anon_1.instances_ephemeral_key_uuid AS anon_1_instances_ephemeral_key_uuid, anon_1.instances_host AS anon_1_instances_host, anon_1.instances_node AS anon_1_instances_node, anon_1.instances_instance_type_id AS anon_1_instances_instance_type_id, anon_1.instances_user_data AS anon_1_instances_user_data, anon_1.instances_reservation_id AS anon_1_instances_reservation_id, anon_1.instances_launched_at AS anon_1_instances_launched_at, anon_1.instances_terminated_at AS anon_1_instances_terminated_at, anon_1.instances_availability_zone AS anon_1_instances_availability_zone, anon_1.instances_display_name AS anon_1_instances_display_name, anon_1.instances_display_description AS anon_1_instances_display_description, anon_1.instances_launched_on AS anon_1_instances_launched_on, anon_1.instances_locked AS anon_1_instances_locked, anon_1.instances_locked_by AS anon_1_instances_locked_by, anon_1.instances_os_type AS anon_1_instances_os_type, anon_1.instances_architecture AS anon_1_instances_architecture, anon_1.instances_vm_mode AS anon_1_instances_vm_mode, anon_1.instances_uuid AS anon_1_instances_uuid, anon_1.instances_root_device_name AS anon_1_instances_root_device_name, anon_1.instances_default_ephemeral_device AS anon_1_instances_default_ephemeral_device, anon_1.instances_default_swap_device AS anon_1_instances_default_swap_device, anon_1.instances_config_drive AS anon_1_instances_config_drive, anon_1.instances_access_ip_v4 AS anon_1_instances_access_ip_v4, anon_1.instances_access_ip_v6 AS anon_1_instances_access_ip_v6, anon_1.instances_auto_disk_config AS anon_1_instances_auto_disk_config, anon_1.instances_progress AS anon_1_instances_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, anon_1.instances_cell_name AS anon_1_instances_cell_name, anon_1.instances_cleaned AS anon_1_instances_cleaned, services_1.created_at AS services_1_created_at, services_1.updated_at AS services_1_updated_at, services_1.deleted_at AS services_1_deleted_at, services_1.deleted AS services_1_deleted, services_1.id AS services_1_id, services_1.host AS services_1_host, services_1.`binary` AS services_1_binary, services_1.topic AS services_1_topic, services_1.report_count AS services_1_report_count, services_1.disabled AS services_1_disabled, services_1.disabled_reason AS services_1_disabled_reason, services_1.last_seen_up AS services_1_last_seen_up, services_1.forced_down AS services_1_forced_down, services_1.version AS services_1_version, security_groups_1.created_at AS security_groups_1_created_at, security_groups_1.updated_at AS security_groups_1_updated_at, security_groups_1.deleted_at AS security_groups_1_deleted_at, security_groups_1.deleted AS security_groups_1_deleted, security_groups_1.id AS security_groups_1_id, security_groups_1.name AS security_groups_1_name, security_groups_1.description AS security_groups_1_description, security_groups_1.user_id AS security_groups_1_user_id, security_groups_1.project_id AS security_groups_1_project_id, instance_extra_1.flavor AS instance_extra_1_flavor, instance_extra_1.created_at AS instance_extra_1_created_at, instance_extra_1.updated_at AS instance_extra_1_updated_at, instance_extra_1.deleted_at AS instance_extra_1_deleted_at, instance_extra_1.deleted AS instance_extra_1_deleted, instance_extra_1.id AS instance_extra_1_id, instance_extra_1.instance_uuid AS instance_extra_1_instance_uuid, tags_1.resource_id AS tags_1_resource_id, tags_1.tag AS tags_1_tag, instance_info_caches_1.created_at AS instance_info_caches_1_created_at, instance_info_caches_1.updated_at AS instance_info_caches_1_updated_at, instance_info_caches_1.deleted_at AS instance_info_caches_1_deleted_at, instance_info_caches_1.deleted AS instance_info_caches_1_deleted, instance_info_caches_1.id AS instance_info_caches_1_id, instance_info_caches_1.network_info AS instance_info_caches_1_network_info, instance_info_caches_1.instance_uuid AS instance_info_caches_1_instance_uuid \nFROM (SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.hostname AS instances_hostname, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS instances_key_data, instances.power_state AS instances_power_state, instances.vm_state AS instances_vm_state, instances.task_state AS instances_task_state, instances.memory_mb AS instances_memory_mb, instances.vcpus AS instances_vcpus, instances.root_gb AS instances_root_gb, instances.ephemeral_gb AS instances_ephemeral_gb, instances.ephemeral_key_uuid AS instances_ephemeral_key_uuid, instances.host AS instances_host, instances.node AS instances_node, instances.instance_type_id AS instances_instance_type_id, instances.user_data AS instances_user_data, instances.reservation_id AS instances_reservation_id, instances.launched_at AS instances_launched_at, instances.terminated_at AS instances_terminated_at, instances.availability_zone AS instances_availability_zone, instances.display_name AS instances_display_name, instances.display_description AS instances_display_description, instances.launched_on AS instances_launched_on, instances.locked AS instances_locked, instances.locked_by AS instances_locked_by, instances.os_type AS instances_os_type, instances.architecture AS instances_architecture, instances.vm_mode AS instances_vm_mode, instances.uuid AS instances_uuid, instances.root_device_name AS instances_root_device_name, instances.default_ephemeral_device AS instances_default_ephemeral_device, instances.default_swap_device AS instances_default_swap_device, instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6, instances.auto_disk_config AS instances_auto_disk_config, instances.progress AS instances_progress, instances.shutdown_terminate AS instances_shutdown_terminate, instances.disable_terminate AS instances_disable_terminate, instances.cell_name AS instances_cell_name, instances.cleaned AS instances_cleaned \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND (instances.vm_state != %(vm_state_1)s OR instances.vm_state IS NULL) AND instances.project_id = %(project_id_1)s ORDER BY instances.created_at DESC, instances.id DESC \n LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN services AS services_1 ON services_1.host = anon_1.instances_host AND services_1.`binary` = %(binary_1)s AND anon_1.instances_deleted = %(deleted_2)s LEFT OUTER JOIN (security_group_instance_association AS security_group_instance_association_1 INNER JOIN security_groups AS security_groups_1 ON security_groups_1.id = security_group_instance_association_1.security_group_id AND security_group_instance_association_1.deleted = %(deleted_3)s AND security_groups_1.deleted = %(deleted_4)s) ON security_group_instance_association_1.instance_uuid = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_5)s LEFT OUTER JOIN instance_extra AS instance_extra_1 ON instance_extra_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN tags AS tags_1 ON tags_1.resource_id = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_6)s LEFT OUTER JOIN instance_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid ORDER BY anon_1.instances_created_at DESC, anon_1.instances_id DESC'] [parameters: {u'binary_1': 'nova-compute', u'deleted_6': 0, u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0, u'param_1': 990, u'vm_state_1': 'soft-delete', u'project_id_1': u'b76de65cb28f465d957ce2e76f284542'}]
2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions
2018-07-18 13:23:48.692 25 INFO nova.api.openstack.wsgi [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.ProgrammingError'>
2018-07-18 13:23:48.695 25 INFO nova.osapi_compute.wsgi.server [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542/servers/detail HTTP/1.1" status: 500 len: 574 time: 0.2840259

I built openstack at centos 7.5 using kolla openstack contrail all in
one

** Affects: nova
     Importance: Undecided
         Status: New

** Description changed:

  I tried to build instance using nova boot but when I do nova list there
  unexpected API is error
  
  Steps to reproduce
  ==================
  (kolla-toolbox) nova boot --flavor b7da5913-7ff0-4758-971a-e9265dd4e261 --image c68f931b-47b2-4657-acf8-4e52aaafd75f --key-name Ubuntu-16QCOW2 --user-data /var/lib/kolla/config_files/myfile.txt --security-groups default Cirros
  +--------------------------------------+----------------------------------------------------------------------------------------------------------+
  | Property                             | Value                                                                                                    |
  +--------------------------------------+----------------------------------------------------------------------------------------------------------+
  | OS-DCF:diskConfig                    | MANUAL                                                                                                   |
  | OS-EXT-AZ:availability_zone          |                                                                                                          |
  | OS-EXT-SRV-ATTR:host                 | -                                                                                                        |
  | OS-EXT-SRV-ATTR:hostname             | cirros                                                                                                   |
  | OS-EXT-SRV-ATTR:hypervisor_hostname  | -                                                                                                        |
  | OS-EXT-SRV-ATTR:instance_name        |                                                                                                          |
  | OS-EXT-SRV-ATTR:kernel_id            |                                                                                                          |
  | OS-EXT-SRV-ATTR:launch_index         | 0                                                                                                        |
  | OS-EXT-SRV-ATTR:ramdisk_id           |                                                                                                          |
  | OS-EXT-SRV-ATTR:reservation_id       | r-yjv4w0nv                                                                                               |
  | OS-EXT-SRV-ATTR:root_device_name     | -                                                                                                        |
  | OS-EXT-SRV-ATTR:user_data            | I2Nsb3VkLWNvbmZpZwpwYXNzd29yZDogcHNpMTIzCmNocGFzc3dkOiB7IGV4cGlyZTogRmFsc2UgfQpzc2hfcHdhdXRoOiBUcnVlCg== |
  | OS-EXT-STS:power_state               | 0                                                                                                        |
  | OS-EXT-STS:task_state                | scheduling                                                                                               |
  | OS-EXT-STS:vm_state                  | building                                                                                                 |
  | OS-SRV-USG:launched_at               | -                                                                                                        |
  | OS-SRV-USG:terminated_at             | -                                                                                                        |
  | accessIPv4                           |                                                                                                          |
  | accessIPv6                           |                                                                                                          |
  | adminPass                            | pE2eMP6sv2Ay                                                                                             |
  | config_drive                         |                                                                                                          |
  | created                              | 2018-07-17T09:59:27Z                                                                                     |
  | description                          | -                                                                                                        |
  | flavor                               | Ubuntu (b7da5913-7ff0-4758-971a-e9265dd4e261)                                                            |
  | hostId                               |                                                                                                          |
  | host_status                          |                                                                                                          |
  | id                                   | 7de09170-ce9d-4908-9f26-d573d4488821                                                                     |
  | image                                | cirros2 (c68f931b-47b2-4657-acf8-4e52aaafd75f)                                                           |
  | key_name                             | Ubuntu-16QCOW2                                                                                           |
  | locked                               | False                                                                                                    |
  | metadata                             | {}                                                                                                       |
  | name                                 | Cirros                                                                                                   |
  | os-extended-volumes:volumes_attached | []                                                                                                       |
  | progress                             | 0                                                                                                        |
  | security_groups                      | default                                                                                                  |
  | status                               | BUILD                                                                                                    |
  | tags                                 | []                                                                                                       |
  | tenant_id                            | b76de65cb28f465d957ce2e76f284542                                                                         |
  | updated                              | 2018-07-17T09:59:27Z                                                                                     |
  | user_id                              | ca80261d88834979bb91ba17748facf2                                                                         |
- +--------------------------------------+----------------------------------------------------------------------------------------------------------+  
+ +--------------------------------------+----------------------------------------------------------------------------------------------------------+
  
- (kolla-toolbox)[root@centos-7 ~]# nova list     
+ (kolla-toolbox)[root@centos-7 ~]# nova list
  ERROR (ClientException): Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.ProgrammingError'> (HTTP 500) (Request-ID: req-62a92b16-6212-4f00-9b35-51a06e004cdd)
+ 
+ ===============================================================================
  
  Below are my nova-api.log
  2018-07-18 13:23:36.179 29 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.180 25 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.181 27 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.182 29 INFO nova.metadata.wsgi.server [req-a1645f58-4f34-4075-83c9-f1720f508567 - - - - -] (29) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.182 25 INFO nova.osapi_compute.wsgi.server [req-051561e2-7640-4c3c-9650-e600b8728c75 - - - - -] (25) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.182 27 INFO nova.metadata.wsgi.server [req-a95696db-5302-4048-a376-e5bc63d2a615 - - - - -] (27) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.184 25 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.184 29 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.184 27 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.183 22 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.186 23 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.187 26 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.188 26 INFO nova.metadata.wsgi.server [req-6b76722b-d72d-449b-a18e-c06030c11df2 - - - - -] (26) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.179 28 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.189 24 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.190 28 INFO nova.metadata.wsgi.server [req-da204b35-4cfa-44ad-a7b2-c989fbaa58e1 - - - - -] (28) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.191 24 INFO nova.osapi_compute.wsgi.server [req-15dd44c5-fca7-4cfb-8397-94c8574d5814 - - - - -] (24) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.192 28 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.192 22 INFO nova.osapi_compute.wsgi.server [req-831901fd-50eb-4c06-8793-1c9b0c5d81fa - - - - -] (22) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.193 22 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.193 26 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.195 23 INFO nova.osapi_compute.wsgi.server [req-83abb04d-d326-4309-aa36-53dd03f6a14b - - - - -] (23) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.196 23 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.200 24 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.209 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Caught SIGTERM, stopping children
  2018-07-18 13:23:36.211 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
  2018-07-18 13:23:36.212 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
  2018-07-18 13:23:36.212 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Waiting on 8 children to exit
  2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 25 exited with status 0
  2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 29 exited with status 0
  2018-07-18 13:23:36.217 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 26 exited with status 0
  2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 28 exited with status 0
  2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 27 exited with status 0
  2018-07-18 13:23:36.222 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 23 exited with status 0
  2018-07-18 13:23:36.224 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 24 exited with status 0
  2018-07-18 13:23:36.235 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 22 exited with status 0
  2018-07-18 13:23:40.437 7 WARNING oslo_reports.guru_meditation_report [-] Guru meditation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
  2018-07-18 13:23:40.625 7 WARNING oslo_config.cfg [-] Option "use_neutron" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
  2018-07-18 13:23:40.668 7 INFO nova.compute.rpcapi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Automatically selected compute RPC version 4.13 from minimum service version 16
  2018-07-18 13:23:41.099 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
  2018-07-18 13:23:41.104 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
  2018-07-18 13:23:41.464 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
  2018-07-18 13:23:41.467 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
  2018-07-18 13:23:41.480 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] osapi_compute listening on 192.168.100.14:8774
  2018-07-18 13:23:41.480 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
  2018-07-18 13:23:41.529 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] metadata listening on 192.168.100.14:8775
  2018-07-18 13:23:41.530 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
  2018-07-18 13:23:41.549 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "force_dhcp_release" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
  2018-07-18 13:23:41.581 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_available_filters" from group "DEFAULT" is deprecated. Use option "available_filters" from group "filter_scheduler".
  2018-07-18 13:23:41.582 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_default_filters" from group "DEFAULT" is deprecated. Use option "enabled_filters" from group "filter_scheduler".
  2018-07-18 13:23:41.649 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_host_manager" from group "DEFAULT" is deprecated. Use option "host_manager" from group "scheduler".
  2018-07-18 13:23:41.769 25 INFO nova.osapi_compute.wsgi.server [req-396e69be-d9c8-4499-a386-780e8f31c2d8 - - - - -] (25) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.812 23 INFO nova.osapi_compute.wsgi.server [req-3daefbdf-83d4-409e-878c-ff71bf342b32 - - - - -] (23) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.882 28 INFO nova.metadata.wsgi.server [req-7644075f-065f-4d8e-9b6b-363001ba7c38 - - - - -] (28) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.959 26 INFO nova.osapi_compute.wsgi.server [req-33a80f66-fe91-480c-80fe-bb99b81fceb2 - - - - -] (26) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.976 24 INFO nova.osapi_compute.wsgi.server [req-31b25d2c-8831-431e-950f-e68056c81da3 - - - - -] (24) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.983 30 INFO nova.metadata.wsgi.server [req-fece6f3c-3669-40c5-995f-0a20d6e08c2a - - - - -] (30) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.984 29 INFO nova.metadata.wsgi.server [req-1c855bc2-8d5b-49c3-8b1c-9992a6370139 - - - - -] (29) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.986 27 INFO nova.metadata.wsgi.server [req-37fa90b5-cd9e-47d3-8b52-31ff65019e63 - - - - -] (27) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:48.307 25 INFO nova.osapi_compute.wsgi.server [req-faeb3aad-646b-40a3-a448-939eca0fdbcd ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542 HTTP/1.1" status: 404 len: 331 time: 1.2246220
  2018-07-18 13:23:48.318 25 INFO nova.osapi_compute.wsgi.server [req-caec31f0-3a56-4df8-9b01-3244ea647063 ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/ HTTP/1.1" status: 200 len: 721 time: 0.0084748
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] Unexpected exception in API method
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions Traceback (most recent call last):
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/extensions.py", line 338, in wrapped
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 214, in detail
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     servers = self._get_servers(req, is_detail=True)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 357, in _get_servers
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2488, in get_all
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2631, in _get_instances_by_filters
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     expected_attrs=fields, sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = fn(cls, context, *args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1227, in get_by_filters
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     use_slave=use_slave, sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 236, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1211, in _get_by_filters_impl
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 763, in instance_get_all_by_filters_sort
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 180, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 281, in wrapped
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(context, *args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 2262, in instance_get_all_by_filters_sort
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return _instances_fill_metadata(context, query_prefix.all(), manual_joins)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2588, in all
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return list(self)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return self._execute_and_instances(context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = conn.execute(querycontext.statement, self._params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return meth(self, multiparams, params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return connection._execute_clauseelement(self, multiparams, params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     compiled_sql, distilled_params
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     util.raise_from_cause(newraise, exc_info)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     reraise(type(exception), exception, tb=exc_tb)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     cursor.execute(statement, parameters)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = self._query(query)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     conn.query(q)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 893, in query
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1103, in _read_query_result
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result.read()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1396, in read
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     first_packet = self.connection._read_packet()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1059, in _read_packet
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     packet.check_error()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     err.raise_mysql_exception(self._data)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     raise errorclass(errno, errval)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova_cell0.instances' doesn't exist") [SQL: u'SELECT anon_1.instances_created_at AS anon_1_instances_created_at, anon_1.instances_updated_at AS anon_1_instances_updated_at, anon_1.instances_deleted_at AS anon_1_instances_deleted_at, anon_1.instances_deleted AS anon_1_instances_deleted, anon_1.instances_id AS anon_1_instances_id, anon_1.instances_user_id AS anon_1_instances_user_id, anon_1.instances_project_id AS anon_1_instances_project_id, anon_1.instances_image_ref AS anon_1_instances_image_ref, anon_1.instances_kernel_id AS anon_1_instances_kernel_id, anon_1.instances_ramdisk_id AS anon_1_instances_ramdisk_id, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_launch_index AS anon_1_instances_launch_index, anon_1.instances_key_name AS anon_1_instances_key_name, anon_1.instances_key_data AS anon_1_instances_key_data, anon_1.instances_power_state AS anon_1_instances_power_state, anon_1.instances_vm_state AS anon_1_instances_vm_state, anon_1.instances_task_state AS anon_1_instances_task_state, anon_1.instances_memory_mb AS anon_1_instances_memory_mb, anon_1.instances_vcpus AS anon_1_instances_vcpus, anon_1.instances_root_gb AS anon_1_instances_root_gb, anon_1.instances_ephemeral_gb AS anon_1_instances_ephemeral_gb, anon_1.instances_ephemeral_key_uuid AS anon_1_instances_ephemeral_key_uuid, anon_1.instances_host AS anon_1_instances_host, anon_1.instances_node AS anon_1_instances_node, anon_1.instances_instance_type_id AS anon_1_instances_instance_type_id, anon_1.instances_user_data AS anon_1_instances_user_data, anon_1.instances_reservation_id AS anon_1_instances_reservation_id, anon_1.instances_launched_at AS anon_1_instances_launched_at, anon_1.instances_terminated_at AS anon_1_instances_terminated_at, anon_1.instances_availability_zone AS anon_1_instances_availability_zone, anon_1.instances_display_name AS anon_1_instances_display_name, anon_1.instances_display_description AS anon_1_instances_display_description, anon_1.instances_launched_on AS anon_1_instances_launched_on, anon_1.instances_locked AS anon_1_instances_locked, anon_1.instances_locked_by AS anon_1_instances_locked_by, anon_1.instances_os_type AS anon_1_instances_os_type, anon_1.instances_architecture AS anon_1_instances_architecture, anon_1.instances_vm_mode AS anon_1_instances_vm_mode, anon_1.instances_uuid AS anon_1_instances_uuid, anon_1.instances_root_device_name AS anon_1_instances_root_device_name, anon_1.instances_default_ephemeral_device AS anon_1_instances_default_ephemeral_device, anon_1.instances_default_swap_device AS anon_1_instances_default_swap_device, anon_1.instances_config_drive AS anon_1_instances_config_drive, anon_1.instances_access_ip_v4 AS anon_1_instances_access_ip_v4, anon_1.instances_access_ip_v6 AS anon_1_instances_access_ip_v6, anon_1.instances_auto_disk_config AS anon_1_instances_auto_disk_config, anon_1.instances_progress AS anon_1_instances_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, anon_1.instances_cell_name AS anon_1_instances_cell_name, anon_1.instances_cleaned AS anon_1_instances_cleaned, services_1.created_at AS services_1_created_at, services_1.updated_at AS services_1_updated_at, services_1.deleted_at AS services_1_deleted_at, services_1.deleted AS services_1_deleted, services_1.id AS services_1_id, services_1.host AS services_1_host, services_1.`binary` AS services_1_binary, services_1.topic AS services_1_topic, services_1.report_count AS services_1_report_count, services_1.disabled AS services_1_disabled, services_1.disabled_reason AS services_1_disabled_reason, services_1.last_seen_up AS services_1_last_seen_up, services_1.forced_down AS services_1_forced_down, services_1.version AS services_1_version, security_groups_1.created_at AS security_groups_1_created_at, security_groups_1.updated_at AS security_groups_1_updated_at, security_groups_1.deleted_at AS security_groups_1_deleted_at, security_groups_1.deleted AS security_groups_1_deleted, security_groups_1.id AS security_groups_1_id, security_groups_1.name AS security_groups_1_name, security_groups_1.description AS security_groups_1_description, security_groups_1.user_id AS security_groups_1_user_id, security_groups_1.project_id AS security_groups_1_project_id, instance_extra_1.flavor AS instance_extra_1_flavor, instance_extra_1.created_at AS instance_extra_1_created_at, instance_extra_1.updated_at AS instance_extra_1_updated_at, instance_extra_1.deleted_at AS instance_extra_1_deleted_at, instance_extra_1.deleted AS instance_extra_1_deleted, instance_extra_1.id AS instance_extra_1_id, instance_extra_1.instance_uuid AS instance_extra_1_instance_uuid, tags_1.resource_id AS tags_1_resource_id, tags_1.tag AS tags_1_tag, instance_info_caches_1.created_at AS instance_info_caches_1_created_at, instance_info_caches_1.updated_at AS instance_info_caches_1_updated_at, instance_info_caches_1.deleted_at AS instance_info_caches_1_deleted_at, instance_info_caches_1.deleted AS instance_info_caches_1_deleted, instance_info_caches_1.id AS instance_info_caches_1_id, instance_info_caches_1.network_info AS instance_info_caches_1_network_info, instance_info_caches_1.instance_uuid AS instance_info_caches_1_instance_uuid \nFROM (SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.hostname AS instances_hostname, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS instances_key_data, instances.power_state AS instances_power_state, instances.vm_state AS instances_vm_state, instances.task_state AS instances_task_state, instances.memory_mb AS instances_memory_mb, instances.vcpus AS instances_vcpus, instances.root_gb AS instances_root_gb, instances.ephemeral_gb AS instances_ephemeral_gb, instances.ephemeral_key_uuid AS instances_ephemeral_key_uuid, instances.host AS instances_host, instances.node AS instances_node, instances.instance_type_id AS instances_instance_type_id, instances.user_data AS instances_user_data, instances.reservation_id AS instances_reservation_id, instances.launched_at AS instances_launched_at, instances.terminated_at AS instances_terminated_at, instances.availability_zone AS instances_availability_zone, instances.display_name AS instances_display_name, instances.display_description AS instances_display_description, instances.launched_on AS instances_launched_on, instances.locked AS instances_locked, instances.locked_by AS instances_locked_by, instances.os_type AS instances_os_type, instances.architecture AS instances_architecture, instances.vm_mode AS instances_vm_mode, instances.uuid AS instances_uuid, instances.root_device_name AS instances_root_device_name, instances.default_ephemeral_device AS instances_default_ephemeral_device, instances.default_swap_device AS instances_default_swap_device, instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6, instances.auto_disk_config AS instances_auto_disk_config, instances.progress AS instances_progress, instances.shutdown_terminate AS instances_shutdown_terminate, instances.disable_terminate AS instances_disable_terminate, instances.cell_name AS instances_cell_name, instances.cleaned AS instances_cleaned \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND (instances.vm_state != %(vm_state_1)s OR instances.vm_state IS NULL) AND instances.project_id = %(project_id_1)s ORDER BY instances.created_at DESC, instances.id DESC \n LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN services AS services_1 ON services_1.host = anon_1.instances_host AND services_1.`binary` = %(binary_1)s AND anon_1.instances_deleted = %(deleted_2)s LEFT OUTER JOIN (security_group_instance_association AS security_group_instance_association_1 INNER JOIN security_groups AS security_groups_1 ON security_groups_1.id = security_group_instance_association_1.security_group_id AND security_group_instance_association_1.deleted = %(deleted_3)s AND security_groups_1.deleted = %(deleted_4)s) ON security_group_instance_association_1.instance_uuid = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_5)s LEFT OUTER JOIN instance_extra AS instance_extra_1 ON instance_extra_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN tags AS tags_1 ON tags_1.resource_id = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_6)s LEFT OUTER JOIN instance_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid ORDER BY anon_1.instances_created_at DESC, anon_1.instances_id DESC'] [parameters: {u'binary_1': 'nova-compute', u'deleted_6': 0, u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0, u'param_1': 990, u'vm_state_1': 'soft-delete', u'project_id_1': u'b76de65cb28f465d957ce2e76f284542'}]
- 2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions 
+ 2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions
  2018-07-18 13:23:48.692 25 INFO nova.api.openstack.wsgi [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.ProgrammingError'>
  2018-07-18 13:23:48.695 25 INFO nova.osapi_compute.wsgi.server [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542/servers/detail HTTP/1.1" status: 500 len: 574 time: 0.2840259
  
  I built openstack at centos 7.5 using kolla openstack contrail all in
  one

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1782296

Title:
  nova [ERROR (ClientException): Unexpected API Error.]

Status in OpenStack Compute (nova):
  New

Bug description:
  I tried to build instance using nova boot but when I do nova list
  there unexpected API is error

  Steps to reproduce
  ==================
  (kolla-toolbox) nova boot --flavor b7da5913-7ff0-4758-971a-e9265dd4e261 --image c68f931b-47b2-4657-acf8-4e52aaafd75f --key-name Ubuntu-16QCOW2 --user-data /var/lib/kolla/config_files/myfile.txt --security-groups default Cirros
  +--------------------------------------+----------------------------------------------------------------------------------------------------------+
  | Property                             | Value                                                                                                    |
  +--------------------------------------+----------------------------------------------------------------------------------------------------------+
  | OS-DCF:diskConfig                    | MANUAL                                                                                                   |
  | OS-EXT-AZ:availability_zone          |                                                                                                          |
  | OS-EXT-SRV-ATTR:host                 | -                                                                                                        |
  | OS-EXT-SRV-ATTR:hostname             | cirros                                                                                                   |
  | OS-EXT-SRV-ATTR:hypervisor_hostname  | -                                                                                                        |
  | OS-EXT-SRV-ATTR:instance_name        |                                                                                                          |
  | OS-EXT-SRV-ATTR:kernel_id            |                                                                                                          |
  | OS-EXT-SRV-ATTR:launch_index         | 0                                                                                                        |
  | OS-EXT-SRV-ATTR:ramdisk_id           |                                                                                                          |
  | OS-EXT-SRV-ATTR:reservation_id       | r-yjv4w0nv                                                                                               |
  | OS-EXT-SRV-ATTR:root_device_name     | -                                                                                                        |
  | OS-EXT-SRV-ATTR:user_data            | I2Nsb3VkLWNvbmZpZwpwYXNzd29yZDogcHNpMTIzCmNocGFzc3dkOiB7IGV4cGlyZTogRmFsc2UgfQpzc2hfcHdhdXRoOiBUcnVlCg== |
  | OS-EXT-STS:power_state               | 0                                                                                                        |
  | OS-EXT-STS:task_state                | scheduling                                                                                               |
  | OS-EXT-STS:vm_state                  | building                                                                                                 |
  | OS-SRV-USG:launched_at               | -                                                                                                        |
  | OS-SRV-USG:terminated_at             | -                                                                                                        |
  | accessIPv4                           |                                                                                                          |
  | accessIPv6                           |                                                                                                          |
  | adminPass                            | pE2eMP6sv2Ay                                                                                             |
  | config_drive                         |                                                                                                          |
  | created                              | 2018-07-17T09:59:27Z                                                                                     |
  | description                          | -                                                                                                        |
  | flavor                               | Ubuntu (b7da5913-7ff0-4758-971a-e9265dd4e261)                                                            |
  | hostId                               |                                                                                                          |
  | host_status                          |                                                                                                          |
  | id                                   | 7de09170-ce9d-4908-9f26-d573d4488821                                                                     |
  | image                                | cirros2 (c68f931b-47b2-4657-acf8-4e52aaafd75f)                                                           |
  | key_name                             | Ubuntu-16QCOW2                                                                                           |
  | locked                               | False                                                                                                    |
  | metadata                             | {}                                                                                                       |
  | name                                 | Cirros                                                                                                   |
  | os-extended-volumes:volumes_attached | []                                                                                                       |
  | progress                             | 0                                                                                                        |
  | security_groups                      | default                                                                                                  |
  | status                               | BUILD                                                                                                    |
  | tags                                 | []                                                                                                       |
  | tenant_id                            | b76de65cb28f465d957ce2e76f284542                                                                         |
  | updated                              | 2018-07-17T09:59:27Z                                                                                     |
  | user_id                              | ca80261d88834979bb91ba17748facf2                                                                         |
  +--------------------------------------+----------------------------------------------------------------------------------------------------------+

  (kolla-toolbox)[root@centos-7 ~]# nova list
  ERROR (ClientException): Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.ProgrammingError'> (HTTP 500) (Request-ID: req-62a92b16-6212-4f00-9b35-51a06e004cdd)

  ===============================================================================

  Below are my nova-api.log
  2018-07-18 13:23:36.179 29 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.180 25 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.181 27 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.182 29 INFO nova.metadata.wsgi.server [req-a1645f58-4f34-4075-83c9-f1720f508567 - - - - -] (29) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.182 25 INFO nova.osapi_compute.wsgi.server [req-051561e2-7640-4c3c-9650-e600b8728c75 - - - - -] (25) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.182 27 INFO nova.metadata.wsgi.server [req-a95696db-5302-4048-a376-e5bc63d2a615 - - - - -] (27) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.184 25 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.184 29 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.184 27 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.183 22 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.186 23 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.187 26 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.188 26 INFO nova.metadata.wsgi.server [req-6b76722b-d72d-449b-a18e-c06030c11df2 - - - - -] (26) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.179 28 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.189 24 INFO nova.wsgi [-] Stopping WSGI server.
  2018-07-18 13:23:36.190 28 INFO nova.metadata.wsgi.server [req-da204b35-4cfa-44ad-a7b2-c989fbaa58e1 - - - - -] (28) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.191 24 INFO nova.osapi_compute.wsgi.server [req-15dd44c5-fca7-4cfb-8397-94c8574d5814 - - - - -] (24) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.192 28 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.192 22 INFO nova.osapi_compute.wsgi.server [req-831901fd-50eb-4c06-8793-1c9b0c5d81fa - - - - -] (22) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.193 22 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.193 26 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.195 23 INFO nova.osapi_compute.wsgi.server [req-83abb04d-d326-4309-aa36-53dd03f6a14b - - - - -] (23) wsgi exited, is_accepting=True
  2018-07-18 13:23:36.196 23 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.200 24 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] WSGI server has stopped.
  2018-07-18 13:23:36.209 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Caught SIGTERM, stopping children
  2018-07-18 13:23:36.211 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
  2018-07-18 13:23:36.212 6 INFO nova.wsgi [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Stopping WSGI server.
  2018-07-18 13:23:36.212 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Waiting on 8 children to exit
  2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 25 exited with status 0
  2018-07-18 13:23:36.213 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 29 exited with status 0
  2018-07-18 13:23:36.217 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 26 exited with status 0
  2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 28 exited with status 0
  2018-07-18 13:23:36.218 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 27 exited with status 0
  2018-07-18 13:23:36.222 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 23 exited with status 0
  2018-07-18 13:23:36.224 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 24 exited with status 0
  2018-07-18 13:23:36.235 6 INFO oslo_service.service [req-ce2b6e65-fdc5-415b-aa0d-ace49d3f2adc - - - - -] Child 22 exited with status 0
  2018-07-18 13:23:40.437 7 WARNING oslo_reports.guru_meditation_report [-] Guru meditation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
  2018-07-18 13:23:40.625 7 WARNING oslo_config.cfg [-] Option "use_neutron" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
  2018-07-18 13:23:40.668 7 INFO nova.compute.rpcapi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Automatically selected compute RPC version 4.13 from minimum service version 16
  2018-07-18 13:23:41.099 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
  2018-07-18 13:23:41.104 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
  2018-07-18 13:23:41.464 7 INFO nova.api.openstack [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Loaded extensions: ['extensions', 'flavors', 'image-metadata', 'image-size', 'images', 'ips', 'limits', 'os-admin-actions', 'os-admin-password', 'os-agents', 'os-aggregates', 'os-assisted-volume-snapshots', 'os-attach-interfaces', 'os-availability-zone', 'os-baremetal-nodes', 'os-block-device-mapping', 'os-cells', 'os-certificates', 'os-cloudpipe', 'os-config-drive', 'os-console-auth-tokens', 'os-console-output', 'os-consoles', 'os-create-backup', 'os-deferred-delete', 'os-evacuate', 'os-extended-availability-zone', 'os-extended-server-attributes', 'os-extended-status', 'os-extended-volumes', 'os-fixed-ips', 'os-flavor-access', 'os-flavor-extra-specs', 'os-flavor-manage', 'os-flavor-rxtx', 'os-floating-ip-dns', 'os-floating-ip-pools', 'os-floating-ips', 'os-floating-ips-bulk', 'os-fping', 'os-hide-server-addresses', 'os-hosts', 'os-hypervisors', 'os-instance-actions', 'os-instance-usage-audit-log', 'os-keypairs', 'os-lock-server', 'os-migrate-server', 'os-migrations', 'os-multinic', 'os-multiple-create', 'os-networks', 'os-networks-associate', 'os-pause-server', 'os-quota-class-sets', 'os-quota-sets', 'os-remote-consoles', 'os-rescue', 'os-scheduler-hints', 'os-security-group-default-rules', 'os-security-groups', 'os-server-diagnostics', 'os-server-external-events', 'os-server-groups', 'os-server-password', 'os-server-tags', 'os-server-usage', 'os-services', 'os-shelve', 'os-simple-tenant-usage', 'os-suspend-server', 'os-tenant-networks', 'os-used-limits', 'os-user-data', 'os-virtual-interfaces', 'os-volumes', 'server-metadata', 'server-migrations', 'servers', 'versions']
  2018-07-18 13:23:41.467 7 WARNING keystonemiddleware.auth_token [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] AuthToken middleware is set with keystone_authtoken.service_token_roles_required set to False. This is backwards compatible but deprecated behaviour. Please set this to True.
  2018-07-18 13:23:41.480 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] osapi_compute listening on 192.168.100.14:8774
  2018-07-18 13:23:41.480 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
  2018-07-18 13:23:41.529 7 INFO nova.wsgi [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] metadata listening on 192.168.100.14:8775
  2018-07-18 13:23:41.530 7 INFO oslo_service.service [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Starting 4 workers
  2018-07-18 13:23:41.549 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "force_dhcp_release" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
  2018-07-18 13:23:41.581 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_available_filters" from group "DEFAULT" is deprecated. Use option "available_filters" from group "filter_scheduler".
  2018-07-18 13:23:41.582 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_default_filters" from group "DEFAULT" is deprecated. Use option "enabled_filters" from group "filter_scheduler".
  2018-07-18 13:23:41.649 7 WARNING oslo_config.cfg [req-73cbaf20-edcb-459f-ac2d-82bf3fb9ccfd - - - - -] Option "scheduler_host_manager" from group "DEFAULT" is deprecated. Use option "host_manager" from group "scheduler".
  2018-07-18 13:23:41.769 25 INFO nova.osapi_compute.wsgi.server [req-396e69be-d9c8-4499-a386-780e8f31c2d8 - - - - -] (25) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.812 23 INFO nova.osapi_compute.wsgi.server [req-3daefbdf-83d4-409e-878c-ff71bf342b32 - - - - -] (23) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.882 28 INFO nova.metadata.wsgi.server [req-7644075f-065f-4d8e-9b6b-363001ba7c38 - - - - -] (28) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.959 26 INFO nova.osapi_compute.wsgi.server [req-33a80f66-fe91-480c-80fe-bb99b81fceb2 - - - - -] (26) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.976 24 INFO nova.osapi_compute.wsgi.server [req-31b25d2c-8831-431e-950f-e68056c81da3 - - - - -] (24) wsgi starting up on http://192.168.100.14:8774
  2018-07-18 13:23:41.983 30 INFO nova.metadata.wsgi.server [req-fece6f3c-3669-40c5-995f-0a20d6e08c2a - - - - -] (30) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.984 29 INFO nova.metadata.wsgi.server [req-1c855bc2-8d5b-49c3-8b1c-9992a6370139 - - - - -] (29) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:41.986 27 INFO nova.metadata.wsgi.server [req-37fa90b5-cd9e-47d3-8b52-31ff65019e63 - - - - -] (27) wsgi starting up on http://192.168.100.14:8775
  2018-07-18 13:23:48.307 25 INFO nova.osapi_compute.wsgi.server [req-faeb3aad-646b-40a3-a448-939eca0fdbcd ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542 HTTP/1.1" status: 404 len: 331 time: 1.2246220
  2018-07-18 13:23:48.318 25 INFO nova.osapi_compute.wsgi.server [req-caec31f0-3a56-4df8-9b01-3244ea647063 ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/ HTTP/1.1" status: 200 len: 721 time: 0.0084748
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] Unexpected exception in API method
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions Traceback (most recent call last):
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/extensions.py", line 338, in wrapped
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return func(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 214, in detail
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     servers = self._get_servers(req, is_detail=True)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 357, in _get_servers
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2488, in get_all
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2631, in _get_instances_by_filters
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     expected_attrs=fields, sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = fn(cls, context, *args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1227, in get_by_filters
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     use_slave=use_slave, sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 236, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1211, in _get_by_filters_impl
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_keys=sort_keys, sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 763, in instance_get_all_by_filters_sort
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     sort_dirs=sort_dirs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 180, in wrapper
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(*args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 281, in wrapped
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return f(context, *args, **kwargs)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 2262, in instance_get_all_by_filters_sort
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return _instances_fill_metadata(context, query_prefix.all(), manual_joins)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2588, in all
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return list(self)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2736, in __iter__
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return self._execute_and_instances(context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = conn.execute(querycontext.statement, self._params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return meth(self, multiparams, params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     return connection._execute_clauseelement(self, multiparams, params)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     compiled_sql, distilled_params
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     util.raise_from_cause(newraise, exc_info)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     reraise(type(exception), exception, tb=exc_tb)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     context)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     cursor.execute(statement, parameters)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result = self._query(query)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     conn.query(q)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 893, in query
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1103, in _read_query_result
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     result.read()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1396, in read
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     first_packet = self.connection._read_packet()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1059, in _read_packet
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     packet.check_error()
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     err.raise_mysql_exception(self._data)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions     raise errorclass(errno, errval)
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova_cell0.instances' doesn't exist") [SQL: u'SELECT anon_1.instances_created_at AS anon_1_instances_created_at, anon_1.instances_updated_at AS anon_1_instances_updated_at, anon_1.instances_deleted_at AS anon_1_instances_deleted_at, anon_1.instances_deleted AS anon_1_instances_deleted, anon_1.instances_id AS anon_1_instances_id, anon_1.instances_user_id AS anon_1_instances_user_id, anon_1.instances_project_id AS anon_1_instances_project_id, anon_1.instances_image_ref AS anon_1_instances_image_ref, anon_1.instances_kernel_id AS anon_1_instances_kernel_id, anon_1.instances_ramdisk_id AS anon_1_instances_ramdisk_id, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_launch_index AS anon_1_instances_launch_index, anon_1.instances_key_name AS anon_1_instances_key_name, anon_1.instances_key_data AS anon_1_instances_key_data, anon_1.instances_power_state AS anon_1_instances_power_state, anon_1.instances_vm_state AS anon_1_instances_vm_state, anon_1.instances_task_state AS anon_1_instances_task_state, anon_1.instances_memory_mb AS anon_1_instances_memory_mb, anon_1.instances_vcpus AS anon_1_instances_vcpus, anon_1.instances_root_gb AS anon_1_instances_root_gb, anon_1.instances_ephemeral_gb AS anon_1_instances_ephemeral_gb, anon_1.instances_ephemeral_key_uuid AS anon_1_instances_ephemeral_key_uuid, anon_1.instances_host AS anon_1_instances_host, anon_1.instances_node AS anon_1_instances_node, anon_1.instances_instance_type_id AS anon_1_instances_instance_type_id, anon_1.instances_user_data AS anon_1_instances_user_data, anon_1.instances_reservation_id AS anon_1_instances_reservation_id, anon_1.instances_launched_at AS anon_1_instances_launched_at, anon_1.instances_terminated_at AS anon_1_instances_terminated_at, anon_1.instances_availability_zone AS anon_1_instances_availability_zone, anon_1.instances_display_name AS anon_1_instances_display_name, anon_1.instances_display_description AS anon_1_instances_display_description, anon_1.instances_launched_on AS anon_1_instances_launched_on, anon_1.instances_locked AS anon_1_instances_locked, anon_1.instances_locked_by AS anon_1_instances_locked_by, anon_1.instances_os_type AS anon_1_instances_os_type, anon_1.instances_architecture AS anon_1_instances_architecture, anon_1.instances_vm_mode AS anon_1_instances_vm_mode, anon_1.instances_uuid AS anon_1_instances_uuid, anon_1.instances_root_device_name AS anon_1_instances_root_device_name, anon_1.instances_default_ephemeral_device AS anon_1_instances_default_ephemeral_device, anon_1.instances_default_swap_device AS anon_1_instances_default_swap_device, anon_1.instances_config_drive AS anon_1_instances_config_drive, anon_1.instances_access_ip_v4 AS anon_1_instances_access_ip_v4, anon_1.instances_access_ip_v6 AS anon_1_instances_access_ip_v6, anon_1.instances_auto_disk_config AS anon_1_instances_auto_disk_config, anon_1.instances_progress AS anon_1_instances_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, anon_1.instances_cell_name AS anon_1_instances_cell_name, anon_1.instances_cleaned AS anon_1_instances_cleaned, services_1.created_at AS services_1_created_at, services_1.updated_at AS services_1_updated_at, services_1.deleted_at AS services_1_deleted_at, services_1.deleted AS services_1_deleted, services_1.id AS services_1_id, services_1.host AS services_1_host, services_1.`binary` AS services_1_binary, services_1.topic AS services_1_topic, services_1.report_count AS services_1_report_count, services_1.disabled AS services_1_disabled, services_1.disabled_reason AS services_1_disabled_reason, services_1.last_seen_up AS services_1_last_seen_up, services_1.forced_down AS services_1_forced_down, services_1.version AS services_1_version, security_groups_1.created_at AS security_groups_1_created_at, security_groups_1.updated_at AS security_groups_1_updated_at, security_groups_1.deleted_at AS security_groups_1_deleted_at, security_groups_1.deleted AS security_groups_1_deleted, security_groups_1.id AS security_groups_1_id, security_groups_1.name AS security_groups_1_name, security_groups_1.description AS security_groups_1_description, security_groups_1.user_id AS security_groups_1_user_id, security_groups_1.project_id AS security_groups_1_project_id, instance_extra_1.flavor AS instance_extra_1_flavor, instance_extra_1.created_at AS instance_extra_1_created_at, instance_extra_1.updated_at AS instance_extra_1_updated_at, instance_extra_1.deleted_at AS instance_extra_1_deleted_at, instance_extra_1.deleted AS instance_extra_1_deleted, instance_extra_1.id AS instance_extra_1_id, instance_extra_1.instance_uuid AS instance_extra_1_instance_uuid, tags_1.resource_id AS tags_1_resource_id, tags_1.tag AS tags_1_tag, instance_info_caches_1.created_at AS instance_info_caches_1_created_at, instance_info_caches_1.updated_at AS instance_info_caches_1_updated_at, instance_info_caches_1.deleted_at AS instance_info_caches_1_deleted_at, instance_info_caches_1.deleted AS instance_info_caches_1_deleted, instance_info_caches_1.id AS instance_info_caches_1_id, instance_info_caches_1.network_info AS instance_info_caches_1_network_info, instance_info_caches_1.instance_uuid AS instance_info_caches_1_instance_uuid \nFROM (SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.hostname AS instances_hostname, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS instances_key_data, instances.power_state AS instances_power_state, instances.vm_state AS instances_vm_state, instances.task_state AS instances_task_state, instances.memory_mb AS instances_memory_mb, instances.vcpus AS instances_vcpus, instances.root_gb AS instances_root_gb, instances.ephemeral_gb AS instances_ephemeral_gb, instances.ephemeral_key_uuid AS instances_ephemeral_key_uuid, instances.host AS instances_host, instances.node AS instances_node, instances.instance_type_id AS instances_instance_type_id, instances.user_data AS instances_user_data, instances.reservation_id AS instances_reservation_id, instances.launched_at AS instances_launched_at, instances.terminated_at AS instances_terminated_at, instances.availability_zone AS instances_availability_zone, instances.display_name AS instances_display_name, instances.display_description AS instances_display_description, instances.launched_on AS instances_launched_on, instances.locked AS instances_locked, instances.locked_by AS instances_locked_by, instances.os_type AS instances_os_type, instances.architecture AS instances_architecture, instances.vm_mode AS instances_vm_mode, instances.uuid AS instances_uuid, instances.root_device_name AS instances_root_device_name, instances.default_ephemeral_device AS instances_default_ephemeral_device, instances.default_swap_device AS instances_default_swap_device, instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6, instances.auto_disk_config AS instances_auto_disk_config, instances.progress AS instances_progress, instances.shutdown_terminate AS instances_shutdown_terminate, instances.disable_terminate AS instances_disable_terminate, instances.cell_name AS instances_cell_name, instances.cleaned AS instances_cleaned \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND (instances.vm_state != %(vm_state_1)s OR instances.vm_state IS NULL) AND instances.project_id = %(project_id_1)s ORDER BY instances.created_at DESC, instances.id DESC \n LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN services AS services_1 ON services_1.host = anon_1.instances_host AND services_1.`binary` = %(binary_1)s AND anon_1.instances_deleted = %(deleted_2)s LEFT OUTER JOIN (security_group_instance_association AS security_group_instance_association_1 INNER JOIN security_groups AS security_groups_1 ON security_groups_1.id = security_group_instance_association_1.security_group_id AND security_group_instance_association_1.deleted = %(deleted_3)s AND security_groups_1.deleted = %(deleted_4)s) ON security_group_instance_association_1.instance_uuid = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_5)s LEFT OUTER JOIN instance_extra AS instance_extra_1 ON instance_extra_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN tags AS tags_1 ON tags_1.resource_id = anon_1.instances_uuid AND anon_1.instances_deleted = %(deleted_6)s LEFT OUTER JOIN instance_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid ORDER BY anon_1.instances_created_at DESC, anon_1.instances_id DESC'] [parameters: {u'binary_1': 'nova-compute', u'deleted_6': 0, u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0, u'param_1': 990, u'vm_state_1': 'soft-delete', u'project_id_1': u'b76de65cb28f465d957ce2e76f284542'}]
  2018-07-18 13:23:48.673 25 ERROR nova.api.openstack.extensions
  2018-07-18 13:23:48.692 25 INFO nova.api.openstack.wsgi [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.ProgrammingError'>
  2018-07-18 13:23:48.695 25 INFO nova.osapi_compute.wsgi.server [req-55faf948-3f94-4b90-893e-b6aeed6a023e ca80261d88834979bb91ba17748facf2 b76de65cb28f465d957ce2e76f284542 - default default] 192.168.100.14 "GET /v2.1/b76de65cb28f465d957ce2e76f284542/servers/detail HTTP/1.1" status: 500 len: 574 time: 0.2840259

  I built openstack at centos 7.5 using kolla openstack contrail all in
  one

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1782296/+subscriptions
Follow ups

[Bug 1782296] Re: nova [ERROR (ClientException): Unexpected API Error.]
From: Takashi NATSUME, 2018-07-24