[Openstack] Adding a new column to a table.

Somanchi Trinath-B39208 B39208 at freescale.com
Tue Sep 3 05:49:12 UTC 2013

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
trinath.somanchi at freescale.com | extn: 4048

From: wu jiang [mailto:wingwj at gmail.com]
Sent: Monday, September 02, 2013 2:57 PM
To: Peeyush Gupta
Cc: openstack at lists.openstack.org
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 <gpeeyush at ymail.com<mailto:gpeeyush at ymail.com>> wrote:


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


~Peeyush Gupta

Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to     : openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130903/40389f5e/attachment.html>

More information about the Openstack mailing list