[Openstack] Nova Compute Errors
Hi Stackers- I have installed nova-compute from the source code, with command, python setup.py install. Also, configured the configuration files. When I start the nova-compute service, I get the following issues. 2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:58 2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py, line 346, in fire_timers timer() File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py, line 56, in __call__ cb(*args, **kw) File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py, line 194, in main result = function(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 124, in run_server server.start() File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 399, in start self.binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py, line 158, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 107, in wrapper return f(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 411, in service_get_by_args filter_by(binary=binary).\ File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2156, in first ret = list(self[0:1]) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2023, in __getitem__ return list(res) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2227, in __iter__ return self._execute_and_instances(context) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2242, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py, line 1449, in execute params) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py, line 1584, in _execute_clauseelement compiled_sql, distilled_params File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py, line 1698, in _execute_context context) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py, line 1850, in _handle_dbapi_exception None, sys.exc_info()[2] OperationalError: (OperationalError) (1054, Unknown column 'services.availability_zone' in 'field list') 'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.`binary` AS services_binary, services.topic AS services_topic, services.report_count AS
Re: [Openstack] Nova Compute Errors
Did you run an upgrade?try maybe :$nova-manage db sync(make a backup first)regards, Razique Mahroua-Nuage Corazique.mahr...@gmail.comTel: +33 9 72 37 94 15 Le 23 mai 2013 à 11:19, Trinath Somanchi trinath.soman...@gmail.com a écrit :Hi Stackers-I have installed nova-compute from the source code, with command, "python setup.py install".Also, configured the configuration files. When I start the "nova-compute" service, I get the following issues.2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3402013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:582013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py", line 346, in fire_timers timer() File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py", line 56, in __call__ cb(*args, **kw) File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py", line 194, in main result = function(*args, **kwargs) File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", line 124, in run_server server.start() File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", line 399, in start self.binary) File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py", line 158, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py", line 107, in wrapper return f(*args, **kwargs) File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py", line 411, in service_get_by_args filter_by(binary=binary).\ File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2156, in first ret = list(self[0:1]) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2023, in __getitem__ return list(res) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2227, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", line 1449, in execute params) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", line 1698, in _execute_context context) File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", line 1850, in _handle_dbapi_exception None, sys.exc_info()[2]OperationalError: (OperationalError) (1054, "Unknown column 'services.availability_zone' in 'field list'") 'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted
Re: [Openstack] Nova Compute Errors
Hi Trinath, I don't know how you have landed to this situation, mostly would be because of upgrade. What had happened is that in *Nova* databases's *instances*table, column *availability_zones* is not present(was there in earlier releases). You might be having the latest database and old nova-code. Due to this, sqlalchemy is sending commands to fetch values based on availability_zones column but the table in database don't have that column. Due to this, you are hitting the exception. One solution is to manually add the extra column to the database to support the old code. But chances are that there will be more tables in database in which you need to do this procedure again and again. Second solution is to have latest code for the Nova, that will solve the problem. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 2:58 PM, Razique Mahroua razique.mahr...@gmail.comwrote: Did you run an upgrade? try maybe : $nova-manage db sync (make a backup first) regards, *Razique Mahroua** - **Nuage Co* razique.mahr...@gmail.com Tel : +33 9 72 37 94 15 Le 23 mai 2013 à 11:19, Trinath Somanchi trinath.soman...@gmail.com a écrit : Hi Stackers- I have installed nova-compute from the source code, with command, python setup.py install. Also, configured the configuration files. When I start the nova-compute service, I get the following issues. 2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:58 2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py, line 346, in fire_timers timer() File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py, line 56, in __call__ cb(*args, **kw) File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py, line 194, in main result = function(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 124, in run_server server.start() File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 399, in start self.binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py, line 158, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 107, in wrapper return f(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 411, in service_get_by_args filter_by(binary=binary).\ File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2156, in first ret = list(self[0:1]) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2023, in __getitem__ return list(res) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2227, in __iter__ return self._execute_and_instances(context) File
Re: [Openstack] Nova Compute Errors
Correction: the table_name is services not instances. -Regards Rahul On Thu, May 23, 2013 at 3:45 PM, Rahul Sharma rahulsharma...@gmail.comwrote: Hi Trinath, I don't know how you have landed to this situation, mostly would be because of upgrade. What had happened is that in *Nova* databases's * instances* table, column *availability_zones* is not present(was there in earlier releases). You might be having the latest database and old nova-code. Due to this, sqlalchemy is sending commands to fetch values based on availability_zones column but the table in database don't have that column. Due to this, you are hitting the exception. One solution is to manually add the extra column to the database to support the old code. But chances are that there will be more tables in database in which you need to do this procedure again and again. Second solution is to have latest code for the Nova, that will solve the problem. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 2:58 PM, Razique Mahroua razique.mahr...@gmail.com wrote: Did you run an upgrade? try maybe : $nova-manage db sync (make a backup first) regards, *Razique Mahroua** - **Nuage Co* razique.mahr...@gmail.com Tel : +33 9 72 37 94 15 Le 23 mai 2013 à 11:19, Trinath Somanchi trinath.soman...@gmail.com a écrit : Hi Stackers- I have installed nova-compute from the source code, with command, python setup.py install. Also, configured the configuration files. When I start the nova-compute service, I get the following issues. 2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:58 2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py, line 346, in fire_timers timer() File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py, line 56, in __call__ cb(*args, **kw) File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py, line 194, in main result = function(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 124, in run_server server.start() File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py, line 399, in start self.binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py, line 158, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 107, in wrapper return f(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py, line 411, in service_get_by_args filter_by(binary=binary).\ File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2156, in first ret = list(self[0:1]) File /usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py, line 2023, in __getitem__ return list(res) File
Re: [Openstack] Nova Compute Errors
Hi Rahul- In that case, I feel the source code from apt-get install and the once got from GIT are different. How to get the code base similar to that of the apt-get install code base from GIT. Any guidelines for the same. thanking you for the help. - Trinath On Thu, May 23, 2013 at 4:32 PM, Rahul Sharma rahulsharma...@gmail.comwrote: Hi Trinath, Latest code is available at https://github.com/openstack/nova.git Have you upgraded the setup to Grizzly? To add the grizzly repositories, you need to do the following:- apt-get install ubuntu-cloud-keyring python-software-properties software-properties-common python-keyring echo deb http://ubuntu-cloud.archive.canonical.com/ubuntu precise-updates/grizzly main /etc/apt/sources.list.d/grizzly.list Then you need to do update and upgrade. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 3:47 PM, Trinath Somanchi trinath.soman...@gmail.com wrote: Hi Rahul- Can you kindly point me to the place, to download the latest Nova code base for Compute Node Installation. - Trinath On Thu, May 23, 2013 at 3:45 PM, Rahul Sharma rahulsharma...@gmail.comwrote: Hi Trinath, I don't know how you have landed to this situation, mostly would be because of upgrade. What had happened is that in *Nova* databases's * instances* table, column *availability_zones* is not present(was there in earlier releases). You might be having the latest database and old nova-code. Due to this, sqlalchemy is sending commands to fetch values based on availability_zones column but the table in database don't have that column. Due to this, you are hitting the exception. One solution is to manually add the extra column to the database to support the old code. But chances are that there will be more tables in database in which you need to do this procedure again and again. Second solution is to have latest code for the Nova, that will solve the problem. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 2:58 PM, Razique Mahroua razique.mahr...@gmail.com wrote: Did you run an upgrade? try maybe : $nova-manage db sync (make a backup first) regards, *Razique Mahroua** - **Nuage Co* razique.mahr...@gmail.com Tel : +33 9 72 37 94 15 Le 23 mai 2013 à 11:19, Trinath Somanchi trinath.soman...@gmail.com a écrit : Hi Stackers- I have installed nova-compute from the source code, with command, python setup.py install. Also, configured the configuration files. When I start the nova-compute service, I get the following issues. 2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:58 2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py, line 346, in fire_timers timer() File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py, line 56, in __call__ cb(*args, **kw) File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py, line 194, in main result = function(*args, **kwargs) File
Re: [Openstack] Nova Compute Errors
Hi Trinath, Try the stable grizzly branch: https://github.com/openstack/nova/tree/stable/grizzly -Regards Rahul On Thu, May 23, 2013 at 4:46 PM, Trinath Somanchi trinath.soman...@gmail.com wrote: Hi Rahul- In that case, I feel the source code from apt-get install and the once got from GIT are different. How to get the code base similar to that of the apt-get install code base from GIT. Any guidelines for the same. thanking you for the help. - Trinath On Thu, May 23, 2013 at 4:32 PM, Rahul Sharma rahulsharma...@gmail.comwrote: Hi Trinath, Latest code is available at https://github.com/openstack/nova.git Have you upgraded the setup to Grizzly? To add the grizzly repositories, you need to do the following:- apt-get install ubuntu-cloud-keyring python-software-properties software-properties-common python-keyring echo deb http://ubuntu-cloud.archive.canonical.com/ubuntu precise-updates/grizzly main /etc/apt/sources.list.d/grizzly.list Then you need to do update and upgrade. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 3:47 PM, Trinath Somanchi trinath.soman...@gmail.com wrote: Hi Rahul- Can you kindly point me to the place, to download the latest Nova code base for Compute Node Installation. - Trinath On Thu, May 23, 2013 at 3:45 PM, Rahul Sharma rahulsharma...@gmail.comwrote: Hi Trinath, I don't know how you have landed to this situation, mostly would be because of upgrade. What had happened is that in *Nova* databases's * instances* table, column *availability_zones* is not present(was there in earlier releases). You might be having the latest database and old nova-code. Due to this, sqlalchemy is sending commands to fetch values based on availability_zones column but the table in database don't have that column. Due to this, you are hitting the exception. One solution is to manually add the extra column to the database to support the old code. But chances are that there will be more tables in database in which you need to do this procedure again and again. Second solution is to have latest code for the Nova, that will solve the problem. Thanks and Regards Rahul Sharma On Thu, May 23, 2013 at 2:58 PM, Razique Mahroua razique.mahr...@gmail.com wrote: Did you run an upgrade? try maybe : $nova-manage db sync (make a backup first) regards, *Razique Mahroua** - **Nuage Co* razique.mahr...@gmail.com Tel : +33 9 72 37 94 15 Le 23 mai 2013 à 11:19, Trinath Somanchi trinath.soman...@gmail.com a écrit : Hi Stackers- I have installed nova-compute from the source code, with command, python setup.py install. Also, configured the configuration files. When I start the nova-compute service, I get the following issues. 2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION) 2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: qemu:///system _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340 2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host stats update_status /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:3039 2013-05-23 14:37:29 DEBUG nova.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Notifying Schedulers of capabilities ... publish_service_capabilities /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/manager.py:256 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Making asynchronous fanout cast... fanout_cast /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:385 2013-05-23 14:37:29 3124 DEBUG nova.openstack.common.rpc.amqp [-] Pool creating new connection create /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/openstack/common/rpc/amqp.py:58 2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on 10.232.91.81:5672 Traceback (most recent call last): File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py, line 346, in fire_timers timer() File /usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py, line 56, in __call__ cb(*args, **kw) File