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 < [email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : [email protected] Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
