Error nova api with ironic test in stable/juno branch

[Hirofumi Ichihara]

CI got broken because check-grenade-dsvm-ironic-sideways failed to test in https://review.openstack.org/#/c/154733/

http://logs.openstack.org/33/154733/8/check/check-grenade-dsvm-ironic-sideways/51f1003/logs/new/screen-n-api.txt.gz#_2015-02-16_21_43_22_640

2015-02-16 21:43:22.640 ERROR nova.api.openstack [req-00416f29-d3cc-40c9-9c38-25257cd943ef BaremetalNodesAdminTestJSON-789601882 BaremetalNodesAdminTestJSON-1934154776] Caught error: (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 21:43:22.640 14022 TRACE nova.api.openstack Traceback (most recent call last):
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/api/openstack/__init__.py", line 124, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return req.get_response(self.application)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1320, in send
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack application, catch_exc_info=False)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1284, in call_application
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack app_iter = application(self.environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return resp(environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/keystonemiddleware/auth_token.py", line 823, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return self._call_app(env, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/keystonemiddleware/auth_token.py", line 758, in _call_app
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return self._app(env, _fake_start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return resp(environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return resp(environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/routes/middleware.py", line 136, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack response = self.app(environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 144, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return resp(environ, start_response)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 130, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack resp = self.call_func(req, *args, **self.kwargs)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 195, in call_func
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return self.func(req, *args, **kwargs)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 910, in __call__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack content_type, body, accept)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 975, in _process_stack
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack action_result = self.dispatch(meth, request, action_args)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/api/openstack/wsgi.py", line 1059, in dispatch
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return method(req=request, **action_args)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/api/openstack/compute/contrib/baremetal_nodes.py", line 200, in index
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack nodes_from_db = db.bm_node_get_all(context)
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack service_host=service_host)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/opt/stack/new/nova/nova/db/sqlalchemy/api.py", line 125, in wrapper
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return f(*args, **kwargs)
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack return query.all()
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2241, in all
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return list(self)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2353, in __iter__
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack return self._execute_and_instances(context)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2368, in _execute_and_instances
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack result = conn.execute(querycontext.statement, self._params)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack params)
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack compiled_sql, distilled_params
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
2015-02-16 21:43:22.640 14022 TRACE nova.api.openstack context)
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack six.reraise(type(newraise), newraise, sys.exc_info()[2])
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack per_fn = fn(ctx)
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack context.is_disconnect)
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack raise operational_error
2015-02-16 21:43:22.640 14022 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 21:43:22.640 14022 TRACE nova.api.openstack
2015-02-16 21:43:22.644 INFO nova.api.openstack [req-00416f29-d3cc-40c9-9c38-25257cd943ef BaremetalNodesAdminTestJSON-789601882 BaremetalNodesAdminTestJSON-1934154776] http://127.0.0.1:8774/v2/e8b086c860304e85922a61ffb058c477/os-baremetal-nodes returned with HTTP 500