yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #73932
[Bug 1782296] Re: nova [ERROR (ClientException): Unexpected API Error.]
This issue is not a bug. So set the status to 'Invalid'.
** Changed in: nova
Status: New => Invalid
--
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):
Invalid
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
References
