Error when starting nova-network

Asked by Tsel

Hi,
New to all this and trying to configure controller with an extra compute node.
Randomly the controller, server 1, loses connection to outside of the network, ie internet, and can't bring it back unless nova-network is ran, but it displays the following error.
Any help would be appreciated.

@controller:~# nova-network
2011-09-21 12:02:24,192 AUDIT nova [-] Starting network node (version 2011.2-workspace:tarmac-20110415024701-a9bdb77vaatk99lh)
2011-09-21 12:02:24,445 CRITICAL nova [-] (OperationalError) no such table: networks u'SELECT networks.created_at AS networks_created_at, networks.updated_at AS networks_updated_at, networks.deleted_at AS networks_deleted_at, networks.deleted AS networks_deleted, networks.id AS networks_id, networks.label AS networks_label, networks.injected AS networks_injected, networks.cidr AS networks_cidr, networks.cidr_v6 AS networks_cidr_v6, networks.gateway_v6 AS networks_gateway_v6, networks.netmask_v6 AS networks_netmask_v6, networks.netmask AS networks_netmask, networks.bridge AS networks_bridge, networks.gateway AS networks_gateway, networks.broadcast AS networks_broadcast, networks.dns AS networks_dns, networks.vlan AS networks_vlan, networks.vpn_public_address AS networks_vpn_public_address, networks.vpn_public_port AS networks_vpn_public_port, networks.vpn_private_address AS networks_vpn_private_address, networks.dhcp_start AS networks_dhcp_start, networks.project_id AS networks_project_id, networks.host AS networks_host \nFROM networks \nWHERE networks.deleted = ? AND networks.host = ?' (False, 'controller')

from mysql

mysql> select * from networks;
+---------------------+---------------------+------------+---------+----+----------+----------------+-----------------+--------+-------------+---------------+------+------+--------------------+-----------------+---------------------+-------------+------------+------------+---------+------------+-------+------------+
| created_at | updated_at | deleted_at | deleted | id | injected | cidr | netmask | bridge | gateway | broadcast | dns | vlan | vpn_public_address | vpn_public_port | vpn_private_address | dhcp_start | project_id | host | cidr_v6 | gateway_v6 | label | netmask_v6 |
+---------------------+---------------------+------------+---------+----+----------+----------------+-----------------+--------+-------------+---------------+------+------+--------------------+-----------------+---------------------+-------------+------------+------------+---------+------------+-------+------------+
| 2011-09-20 21:28:26 | 2011-09-21 17:27:49 | NULL | 0 | 2 | 0 | 192.168.1.0/25 | 255.255.255.128 | br100 | 192.168.1.1 | 192.168.1.127 | NULL | 100 | 192.168.0.155 | 1000 | 192.168.1.2 | 192.168.1.3 | kesseltest | controller | NULL | NULL | NULL | NULL |
+---------------------+---------------------+------------+---------+----+----------+----------------+-----------------+--------+-------------+---------------+------+------+--------------------+-----------------+---------------------+-------------+------------+------------+---------+------------+-------+------------+
1 row in set (0.00 sec)

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
Tsel
Solved:
Last query:
Last reply:
Revision history for this message
Sateesh (sateesh-chodapuneedi) said :
#1

Is the flag --sql-connection specified such that nova service does know which sql server it should connect to?

Revision history for this message
Tsel (tselhakeisar) said :
#2

yes, here is the controllers nova.conf

could it be the network addresses? I did everything again and same thing happened.
Maybe network schemes are the issue?

--dhcpbridge_flagfile=/etc/nova/nova.conf
--dhcpbridge=/usr/bin/nova-dhcpbridge
--logdir=/var/log/nova
--state_path=/var/lib/nova
--lock_path=/var/lock/nova
--verbose
--s3_host=192.168.0.155
--rabbit_host=192.168.1.10
--cc_host=192.168.1.10
--ec2_url=http://192.168.0.155:8773/services/Cloud
--fixed_range=192.168.1.0/16
--network_size=8
--FAKE_subdomain=ec2
--routing_source_ip=192.168.1.10
--sql_connection=mysql://root:nova@192.168.0.155/nova
--glance_host=192.168.1.10
--image_service=nova.image.glance.GlanceImageService
--iscsi_ip_prefix=192.168.

Thanks.

Revision history for this message
Tsel (tselhakeisar) said :
#3

Sateesh, Thanks for the response.
For me it was an issue between database and configuration files for the network.