<br clear="all">Hi Team,<br><br> 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.<br>
<br><i>2011-08-30 12:16:18+0500 [-]   File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute<br>2011-08-30 12:16:18+0500 [-]     cursor.execute(statement, parameters)<br>2011-08-30 12:16:18+0500 [-]   File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute<br>
2011-08-30 12:16:18+0500 [-]     self.errorhandler(self, exc, value)<br>2011-08-30 12:16:18+0500 [-]   File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler<br>2011-08-30 12:16:18+0500 [-]     raise errorclass, errorvalue<br>
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' ()<br>
2011-08-30 12:22:26+0500 [-] Log opened.</i><b><i><br></i></b><br><font size="4"> Compute node's nova-compute.conf file is;</font><br><br>--ca_path=/var/lib/nova/CA<br>--keys_path=/var/lib/nova/keys<br>--instances_path=/var/lib/nova/instances<br>
--injected_network_template=/usr/share/nova/interfaces.template<br>--libvirt_xml_template=/usr/share/nova/libvirt.qemu.xml.template<br>--libvirt_uml_xml_template=/usr/share/nova/libvirt.uml.xml.template<br>--vpn_client_template=/usr/share/nova/client.ovpn.template<br>
--credentials_template=/usr/share/nova/novarc.template<br>--logfile=/var/log/nova/nova-compute.log<br>--dhcpbridge=/usr/bin/nova-dhcpbridge<br>--logdir=/var/log/nova<br>--lock_path=/var/lock/nova<br>--state_path=/var/lib/nova<br>
--verbose<br>--s3_host=192.168.104.1<br>--rabbit_host=192.168.104.1<br>--cc_host=192.168.104.1<br>--ec2_url=<a href="http://192.168.104.1:8773/services/Cloud">http://192.168.104.1:8773/services/Cloud</a><br>--fixed_range=<a href="http://192.168.104.0/24">192.168.104.0/24</a><br>
--network_size=8<br>--FAKE_subdomain=ec2<br>--routing_source_ip=192.168.104.1<br>--sql_connection=mysql://root:<passwd>@<a href="http://192.168.104.1/nova">192.168.104.1/nova</a><br>--glance_host=192.168.104.1<br>--image_service=nova.image.glance.GlanceImageService<br>
<br> Could you please help to resolve this!<br><br>Cheers!<br>Rasika Karunathilaka.<br>