Ironic

gate-grenade-dsvm-ironic-sideways fails with "(OperationalError) no such table"

Bug #1422556 reported by Matt Riedemann on 2015-02-17

This bug report is a duplicate of: Bug #1422520: check-grenade-dsvm-ironic-sideways failing test_list_baremetal_node. Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Ironic	New	Undecided	Unassigned

Bug Description

http://logs.openstack.org/64/153164/1/gate/gate-grenade-dsvm-ironic-sideways/2ca1d86/logs/new/screen-n-api.txt.gz?level=TRACE#_2015-02-16_12_56_23_241

http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiQ2F1Z2h0IGVycm9yOiAoT3BlcmF0aW9uYWxFcnJvcikgbm8gc3VjaCB0YWJsZTogYm1fbm9kZXNcIiBBTkQgdGFnczpcInNjcmVlbi1uLWFwaS50eHRcIiIsImZpZWxkcyI6W10sIm9mZnNldCI6MCwidGltZWZyYW1lIjoiNjA0ODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJ0aW1lIjp7InVzZXJfaW50ZXJ2YWwiOjB9LCJzdGFtcCI6MTQyNDE0MzYzNDYwMX0=

5 hits since 2/16, check and gate, all failures.

Revision history for this message

Matt Riedemann (mriedem) wrote on 2015-02-17:

Download full text (8.2 KiB)

2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack Traceback (most recent call last):
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/api/openstack/__init__.py", line 124, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return req.get_response(self.application)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1320, in send
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     application, catch_exc_info=False)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1284, in call_application
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     app_iter = application(self.environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return resp(environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/keystonemiddleware/auth_token.py", line 823, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return self._call_app(env, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/keystonemiddleware/auth_token.py", line 758, in _call_app
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return self._app(env, _fake_start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return resp(environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return resp(environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/routes/middleware.py", line 136, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     response = self.app(environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return resp(environ, start_response)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     resp = self.call_func(req, *args, **self.kwargs)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 195, in call_func
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return self.func(req, *args, **kwargs)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 910, in __call__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     content_type, body, accept)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 975, in _process_stack
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     action_result = self.dispatch(meth, request, action_args)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 1059, in dispatch
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return method(req=request, **action_args)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/api/openstack/compute/contrib/baremetal_nodes.py", line 200, in index
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     nodes_from_db = db.bm_node_get_all(context)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/virt/baremetal/db/api.py", line 71, in bm_node_get_all
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     service_host=service_host)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 125, in wrapper
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return f(*args, **kwargs)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/opt/stack/new/nova/nova/virt/baremetal/db/sqlalchemy/api.py", line 90, in bm_node_get_all
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return query.all()
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2241, in all
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return list(self)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2353, in __iter__
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     return self._execute_and_instances(context)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2368, in _execute_and_instances
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     result = conn.execute(querycontext.statement, self._params)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     params)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     compiled_sql, distilled_params
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     context)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 125, in _handle_dbapi_exception
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     six.reraise(type(newraise), newraise, sys.exc_info()[2])
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 102, in _handle_dbapi_exception
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     per_fn = fn(ctx)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     context.is_disconnect)
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack   File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack     raise operational_error
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack OperationalError: (OperationalError) no such table: bm_nodes u'SELECT bm_nodes.deleted_at AS bm_nodes_deleted_at, bm_nodes.created_at AS bm_nodes_created_at, bm_nodes.updated_at AS bm_nodes_updated_at, bm_nodes.id AS bm_nodes_id, bm_nodes.deleted AS bm_nodes_deleted, bm_nodes.uuid AS bm_nodes_uuid, bm_nodes.service_host AS bm_nodes_service_host, bm_nodes.instance_uuid AS bm_nodes_instance_uuid, bm_nodes.instance_name AS bm_nodes_instance_name, bm_nodes.cpus AS bm_nodes_cpus, bm_nodes.memory_mb AS bm_nodes_memory_mb, bm_nodes.local_gb AS bm_nodes_local_gb, bm_nodes.preserve_ephemeral AS bm_nodes_preserve_ephemeral, bm_nodes.pm_address AS bm_nodes_pm_address, bm_nodes.pm_user AS bm_nodes_pm_user, bm_nodes.pm_password AS bm_nodes_pm_password, bm_nodes.task_state AS bm_nodes_task_state, bm_nodes.terminal_port AS bm_nodes_terminal_port, bm_nodes.image_path AS bm_nodes_image_path, bm_nodes.pxe_config_path AS bm_nodes_pxe_config_path, bm_nodes.deploy_key AS bm_nodes_deploy_key, bm_nodes.root_mb AS bm_nodes_root_mb, bm_nodes.swap_mb AS bm_nodes_swap_mb, bm_nodes.ephemeral_mb AS bm_nodes_ephemeral_mb \nFROM bm_nodes \nWHERE bm_nodes.deleted = 0' ()
2015-02-16 12:56:23.241 26053 TRACE nova.api.openstack

Revision history for this message

Matt Riedemann (mriedem) wrote on 2015-02-17:

e-r query: https://review.openstack.org/#/c/156453/

Report a bug

This report contains Public information

Everyone can see this information.

Duplicate of bug #1422520 Remove

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.