Hi Peeyush- You may also try to delete/rename that table (if its an empty one) and restart the nova service.
The table with new column can be added. -- Trinath Somanchi - B39208 [email protected] | extn: 4048 From: wu jiang [mailto:[email protected]] Sent: Monday, September 02, 2013 2:57 PM To: Peeyush Gupta Cc: [email protected] Subject: Re: [Openstack] Adding a new column to a table. Hi Peeyush, My approach is to create a file with successive number in dir "\nova\db\sqlalchemy\migrate_repo\versions\" , and realize it according to my needs. And later, execute "nova-manage db sync", the new table will be available. Please take it as your reference~ On Mon, Sep 2, 2013 at 5:01 PM, Peeyush Gupta <[email protected]<mailto:[email protected]>> wrote: Hi, I have been trying to add a new column to compute_nodes table. I understand the table is defined at db.sqlalchemy.models.py<http://db.sqlalchemy.models.py>. So, I added a new field in the file and restarted the nova-compute process. But, there is no change in the table. What am I doing wrong? Where should I make changes to add the column? P.S: I am using devstack on Ubuntu 12.04 LTS Thanks, ~Peeyush Gupta _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected]<mailto:[email protected]> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
