Hi Leandra/Team, I set the set foreign_key_checks = 0 ; at mysql DB and then executed; /etc/init.d/nova-compute start
However still I am getting the same error on /var/log/nova/nova-compute.log stating; *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\tUNIQUE (`index`), \n\tFOREIGN KEY(network_id) REFERENCES networks (id)\n)ENGINE=InnoDB\n\n' () * NOVA server is running on Ubuntu 11.04 - 64 bit server NOVA Compute is running on Ubuntu 10.10 - 64 bit desktop I got nova for the compute node Ubuntu repository using apt-get and the version displays as nova-compute 0.9.1~bzr331-0ubuntu2 Nova version at the Server displays as: 2011.2-0ubuntu1 Appreciate your help. Cheers! Rasika K On Tue, Aug 30, 2011 at 12:47 PM, Leandro Reox <[email protected]>wrote: > 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
