Ask Your Question

asitkc's profile - activity

2014-08-15 06:31:10 -0500 received badge  Famous Question (source)
2014-06-09 16:40:47 -0500 received badge  Notable Question (source)
2014-06-05 03:02:10 -0500 received badge  Popular Question (source)
2014-06-03 21:22:19 -0500 asked a question nova-compute fails to come up with OperationalError on tables

controller is implemented as a vm. compute host is a regular node, has errors like the following. Using mysql command line as user nova on the compute host can verify that the instances table do exist on the controller. What could be wrong here ?

[database]
# The SQLAlchemy connection string used to connect to the database (10.0.0.121 is the controller)
connection = mysql://nova:xxx@10.0.0.121/nova



2014-06-03 18:37:29 CRITICAL nova [-] (OperationalError) no such table: networks
 u'SELECT networks.created_at AS networks_created_at, networks.updated_at AS net
works_updated_at, networks.deleted_at AS networks_deleted_at, networks.deleted A
S networks_deleted, networks.id AS networks_id, networks.label AS networks_label
, networks.injected AS networks_injected, networks.cidr AS networks_cidr, networ
ks.cidr_v6 AS networks_cidr_v6, networks.multi_host AS networks_multi_host, netw
orks.gateway_v6 AS networks_gateway_v6, networks.netmask_v6 AS networks_netmask_
v6, networks.netmask AS networks_netmask, networks.bridge AS networks_bridge, ne
tworks.bridge_interface AS networks_bridge_interface, networks.gateway AS networ
ks_gateway, networks.broadcast AS networks_broadcast, networks.dns1 AS networks_
dns1, networks.dns2 AS networks_dns2, networks.vlan AS networks_vlan, networks.v
pn_public_address AS networks_vpn_public_address, networks.vpn_public_port AS ne
tworks_vpn_public_port, networks.vpn_private_address AS networks_vpn_private_add
ress, networks.dhcp_start AS networks_dhcp_start, networks.rxtx_base AS networks
_rxtx_base, networks.project_id AS networks_project_id, networks.priority AS net
works_priority, networks.host AS networks_host, networks.uuid AS networks_uuid \
nFROM networks \nWHERE networks.deleted = ? AND (networks.host = ? OR networks.i
d IN (SELECT fixed_ips.network_id \nFROM fixed_ips \nWHERE fixed_ips.deleted = ?
 AND fixed_ips.host = ?))' (0, 'enc01-blade01', 0, 'enc01-blade01')
2014-06-03 18:37:29 TRACE nova Traceback (most recent call last):
2014-06-03 18:37:29 TRACE nova   File "/usr/bin/nova-network", line 49, in <modu
le>
2014-06-03 18:37:29 TRACE nova     service.wait()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/ser
vice.py", line 413, in wait
2014-06-03 18:37:29 TRACE nova     _launcher.wait()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/ser
vice.py", line 131, in wait
2014-06-03 18:37:29 TRACE nova     service.wait()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet
/greenthread.py", line 166, in wait
2014-06-03 18:37:29 TRACE nova     return self._exit_event.wait()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet
/event.py", line 116, in wait
2014-06-03 18:37:29 TRACE nova     return hubs.get_hub().switch()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet
/hubs/hub.py", line 177, in switch
2014-06-03 18:37:29 TRACE nova     return self.greenlet.switch()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/eventlet
/greenthread.py", line 192, in main
2014-06-03 18:37:29 TRACE nova     result = function(*args, **kwargs)
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/ser
vice.py", line 101, in run_server
2014-06-03 18:37:29 TRACE nova     server.start()
2014-06-03 18:37:29 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/ser
vice.py", line 162, in start
2014-06-03 18:37:29 ...
(more)