Are running diablo milestone ? <br><br>There's only 3 ways to get this mysql error : <br><br><meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="font-family: Georgia, 'Times New Roman', Times, serif; font-size: 14px; line-height: 23px; "><ul style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 40px; color: rgb(0, 0, 0); list-style-type: square; ">
<li style="padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">If the two fields ( field and the foreing field) uses non-compatible field types </li>
</ul><ul style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 15px; margin-left: 40px; color: rgb(0, 0, 0); list-style-type: square; "><li style="padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">
If its using “On Delete Set Null” but the field doesnt allow that</li><li style="padding-top: 3px; padding-right: 0px; padding-bottom: 3px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">
The FK name is not unique </li></ul><div><br></div></span><font class="Apple-style-span" face="verdana, arial, helvetica, sans-serif"><span class="Apple-style-span" style="font-size: 12px; line-height: 23px;"><br></span></font><span class="Apple-style-span" style="font-family: Georgia, 'Times New Roman', Times, serif; font-size: 14px; line-height: 23px; "><div>
A quick solution is to disable Foreing Key check before the query and reenabling it, </div><div><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; "><br></span></div>
<div><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; "><meta http-equiv="content-type" content="text/html; charset=utf-8">set foreign_key_checks = 0 ; </span></div>
<div><meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; ">NOVA DB SYNC <br></span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; ">now enable by, set foreign_key_checks = 1 </span></div>
<div><br></div><div>but i dont know if this is actually a bug. If youre running on "release" this should not happen. <br><br>Regards</div><div><br></div></span><br><div class="gmail_quote">On Tue, Aug 30, 2011 at 4:34 AM, Rasika Karunathilaka <span dir="ltr"><<a href="mailto:rasika.karunathilaka@gmail.com">rasika.karunathilaka@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><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" target="_blank">http://192.168.104.1:8773/services/Cloud</a><br>
--fixed_range=<a href="http://192.168.104.0/24" target="_blank">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" target="_blank">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><font color="#888888">Rasika Karunathilaka.<br>
</font><br>_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br></blockquote></div><br>