Open Stack

Are running diablo milestone ?

There's only 3 ways to get this mysql error :


   - If the two fields ( field and the foreing field) uses non-compatible
   field types


   - If its using “On Delete Set Null” but the field doesnt allow that
   - The FK name is not unique



A quick solution is to disable Foreing Key check before the query and
reenabling it,

set foreign_key_checks = 0 ;
NOVA DB SYNC
now enable by, set foreign_key_checks = 1

but i dont know if this is actually a bug. If youre running on "release"
this should not happen.

Regards


On Tue, Aug 30, 2011 at 4:34 AM, Rasika Karunathilaka <
rasika.karunathilaka at gmail.com> wrote:

>
> 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.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack at lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20110830/c4510b3c/attachment.html>