[Expired for OpenStack Compute (nova) because there has been no activity
for 60 days.]
** Changed in: nova
Status: Incomplete => Expired
--
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/1696410
Title:
(openstack) server list Unexpected API Error
Status in OpenStack Compute (nova):
Expired
Bug description:
(openstack) server list
Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/
and attach the Nova API log if possible.
<class 'sqlalchemy.exc.OperationalError'> (HTTP 500) (Request-ID:
req-81cc918b-3ce8-42de-996f-38609e5d058f)
the following is nova-api.log:
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
[req-4ac89295-a118-4259-98c8-415cf5da26ba 7ae91d7b6e334c55bee81317b7aae048
78a9778adb624324a46970407072b6b7 - default default] Unexpected exception in API
method
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions Traceback
(most recent call last):
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/api/openstack/extensions.py", line 338,
in wrapped
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
f(*args, **kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181,
in wrapper
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
func(*args, **kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 181,
in wrapper
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
func(*args, **kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line
214, in detail
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions servers
= self._get_servers(req, is_detail=True)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line
357, in _get_servers
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
sort_keys=sort_keys, sort_dirs=sort_dirs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2469, in get_all
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
sort_dirs=sort_dirs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/compute/api.py", line 2609, in
_get_instances_by_filters
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
expected_attrs=fields, sort_keys=sort_keys, sort_dirs=sort_dirs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in
wrapper
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions result =
fn(cls, context, *args, **kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/objects/instance.py", line 1220, in
get_by_filters
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
use_slave=use_slave, sort_keys=sort_keys, sort_dirs=sort_dirs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 235, in
wrapper
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions with
reader_mode.using(context):
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
self.gen.next()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
944, in _transaction_scope
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
allow_async=self._allow_async) as resource:
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
self.gen.next()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
558, in _session
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
bind=self.connection, mode=self.mode)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
317, in _create_session
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
self._start()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
403, in _start
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
engine_args, maker_args)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
427, in _setup_for_connection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
sql_connection=sql_connection, **engine_kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 155, in
create_engine
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
test_conn = _test_connection(engine, max_retries, retry_interval)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 331, in
_test_connection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
engine.connect()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in
connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
self._connection_cls(self, **kwargs)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in
__init__
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions if
connection is not None else engine.raw_connection()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in
raw_connection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
self.pool.unique_connection, _connection)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in
_wrap_pool_connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions e,
dialect, self)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in
_handle_dbapi_exception_noconnection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
util.raise_from_cause(newraise, exc_info)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in
raise_from_cause
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
reraise(type(exception), exception, tb=exc_tb)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in
_wrap_pool_connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
fn()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in
unique_connection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
_ConnectionFairy._checkout(self)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions fairy =
_ConnectionRecord.checkout(pool)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions rec =
pool._do_get()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
self._dec_overflow()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60,
in __exit__
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
compat.reraise(exc_type, exc_value, exc_tb)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
self._create_connection()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in
_create_connection
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
_ConnectionRecord(self)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
self.connection = self.__connect()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
connection = self.__pool._invoke_creator(self)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97,
in connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
dialect.connect(*cargs, **cparams)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in
connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions return
self.dbapi.connect(*cargs, **cparams)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions conn =
_connect(dsn, connection_factory=connection_factory, async=async)
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions File
"/usr/lib/python2.7/site-packages/eventlet/support/psycopg2_patcher.py", line
46, in eventlet_wait_callback
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions state =
conn.poll()
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
OperationalError: (psycopg2.OperationalError) asynchronous connection failed
2017-06-07 20:09:05.739 3066 ERROR nova.api.openstack.extensions
2017-06-07 20:09:05.742 3066 INFO nova.api.openstack.wsgi
[req-4ac89295-a118-4259-98c8-415cf5da26ba 7ae91d7b6e334c55bee81317b7aae048
78a9778adb624324a46970407072b6b7 - 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.OperationalError'>
2017-06-07 20:09:05.744 3066 INFO nova.osapi_compute.wsgi.server
[req-4ac89295-a118-4259-98c8-415cf5da26ba 7ae91d7b6e334c55bee81317b7aae048
78a9778adb624324a46970407072b6b7 - default default] 192.168.1.112 "GET
/v2.1/servers/detail HTTP/1.1" status: 500 len: 572 time: 0.0545859
thank guys for help!
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1696410/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
