openstack team mailing list archive

[Rasika Karunathilaka <rasika.karunathilaka@xxxxxxxxx>]

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 <leandro.reox@xxxxxxxxx>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 <
> rasika.karunathilaka@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


--