Open Stack

Hi Team,

 When I am trying to attach a compute node into Cloud Control node , I am
getting following error on /var/log/nova/nova-compute.log . Server1 is the
cloud control node, Server2 is the compute node which I am trying to attach.

*2011-08-30 12:16:18+0500 [-]   File
"/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288,
in do_execute
2011-08-30 12:16:18+0500 [-]     cursor.execute(statement, parameters)
2011-08-30 12:16:18+0500 [-]   File
"/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
2011-08-30 12:16:18+0500 [-]     self.errorhandler(self, exc, value)
2011-08-30 12:16:18+0500 [-]   File
"/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
2011-08-30 12:16:18+0500 [-]     raise errorclass, errorvalue
2011-08-30 12:16:18+0500 [-] sqlalchemy.exc.OperationalError:
(OperationalError) (1005, "Can't create table 'nova.network_indexes' (errno:
150)") '\nCREATE TABLE network_indexes (\n\tcreated_at DATETIME,
\n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tdeleted BOOL, \n\tid
INTEGER NOT NULL AUTO_INCREMENT, \n\t`index` INTEGER, \n\tnetwork_id
INTEGER, \n\tPRIMARY KEY (id), \n\tCHECK (deleted IN (0, 1)), \n\tFOREIGN
KEY(network_id) REFERENCES networks (id), \n\tUNIQUE
(`index`)\n)ENGINE=InnoDB\n\n' ()
2011-08-30 12:22:26+0500 [-] Log opened.**
*
 Compute node's nova-compute.conf file is;

--ca_path=/var/lib/nova/CA
--keys_path=/var/lib/nova/keys
--instances_path=/var/lib/nova/instances
--injected_network_template=/usr/share/nova/interfaces.template
--libvirt_xml_template=/usr/share/nova/libvirt.qemu.xml.template
--libvirt_uml_xml_template=/usr/share/nova/libvirt.uml.xml.template
--vpn_client_template=/usr/share/nova/client.ovpn.template
--credentials_template=/usr/share/nova/novarc.template
--logfile=/var/log/nova/nova-compute.log
--dhcpbridge=/usr/bin/nova-dhcpbridge
--logdir=/var/log/nova
--lock_path=/var/lock/nova
--state_path=/var/lib/nova
--verbose
--s3_host=192.168.104.1
--rabbit_host=192.168.104.1
--cc_host=192.168.104.1
--ec2_url=http://192.168.104.1:8773/services/Cloud
--fixed_range=192.168.104.0/24
--network_size=8
--FAKE_subdomain=ec2
--routing_source_ip=192.168.104.1
--sql_connection=mysql://root:<passwd>@192.168.104.1/nova
--glance_host=192.168.104.1
--image_service=nova.image.glance.GlanceImageService

 Could you please help to resolve this!

Cheers!
Rasika Karunathilaka.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20110830/04fd92b7/attachment.html>