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.com>wrote: > >> 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.com>wrote: >>> >>>> 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 >>>>> "/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 services_report_count, >>>>> services.disabled AS services_disabled, services.availability_zone AS >>>>> services_availability_zone \nFROM services \nWHERE services.deleted = %s >>>>> AND services.host = %s AND services.`binary` = %s \n LIMIT %s' (0, >>>>> 'ComputeNode-1', 'nova-compute', 1) >>>>> 2013-05-23 14:37:29 3124 CRITICAL nova [-] (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 >>>>> services_report_count, services.disabled AS services_disabled, >>>>> services.availability_zone AS services_availability_zone \nFROM services >>>>> \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` >>>>> = %s \n LIMIT %s' (0, 'ComputeNode-1', 'nova-compute', 1) >>>>> 2013-05-23 14:37:29 3124 TRACE nova Traceback (most recent call last): >>>>> 2013-05-23 14:37:29 3124 TRACE nova File "/usr/bin/nova-compute", >>>>> line 5, in <module> >>>>> 2013-05-23 14:37:29 3124 TRACE nova >>>>> pkg_resources.run_script('nova==2013.1', 'nova-compute') >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/pkg_resources.py", line 505, in >>>>> run_script >>>>> 2013-05-23 14:37:29 3124 TRACE nova >>>>> self.require(requires)[0].run_script(script_name, ns) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/pkg_resources.py", line 1245, in >>>>> run_script >>>>> 2013-05-23 14:37:29 3124 TRACE nova execfile(script_filename, >>>>> namespace, namespace) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/EGG-INFO/scripts/nova-compute", >>>>> line 60, in <module> >>>>> 2013-05-23 14:37:29 3124 TRACE nova service.wait() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", >>>>> line 667, in wait >>>>> 2013-05-23 14:37:29 3124 TRACE nova _launcher.wait() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", >>>>> line 186, in wait >>>>> 2013-05-23 14:37:29 3124 TRACE nova super(ServiceLauncher, >>>>> self).wait() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", >>>>> line 156, in wait >>>>> 2013-05-23 14:37:29 3124 TRACE nova service.wait() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py", >>>>> line 168, in wait >>>>> 2013-05-23 14:37:29 3124 TRACE nova return self._exit_event.wait() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/event.py", >>>>> line 116, in wait >>>>> 2013-05-23 14:37:29 3124 TRACE nova return hubs.get_hub().switch() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py", >>>>> line 187, in switch >>>>> 2013-05-23 14:37:29 3124 TRACE nova return self.greenlet.switch() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py", >>>>> line 194, in main >>>>> 2013-05-23 14:37:29 3124 TRACE nova result = function(*args, >>>>> **kwargs) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", >>>>> line 124, in run_server >>>>> 2013-05-23 14:37:29 3124 TRACE nova server.start() >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", >>>>> line 399, in start >>>>> 2013-05-23 14:37:29 3124 TRACE nova self.binary) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py", >>>>> line 158, in service_get_by_args >>>>> 2013-05-23 14:37:29 3124 TRACE nova return >>>>> IMPL.service_get_by_args(context, host, binary) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py", >>>>> line 107, in wrapper >>>>> 2013-05-23 14:37:29 3124 TRACE nova return f(*args, **kwargs) >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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 >>>>> 2013-05-23 14:37:29 3124 TRACE nova filter_by(binary=binary).\ >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", >>>>> line 2156, in first >>>>> 2013-05-23 14:37:29 3124 TRACE nova ret = list(self[0:1]) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", >>>>> line 2023, in __getitem__ >>>>> 2013-05-23 14:37:29 3124 TRACE nova return list(res) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", >>>>> line 2227, in __iter__ >>>>> 2013-05-23 14:37:29 3124 TRACE nova return >>>>> self._execute_and_instances(context) >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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 >>>>> 2013-05-23 14:37:29 3124 TRACE nova result = >>>>> conn.execute(querycontext.statement, self._params) >>>>> 2013-05-23 14:37:29 3124 TRACE nova File >>>>> "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", >>>>> line 1449, in execute >>>>> 2013-05-23 14:37:29 3124 TRACE nova params) >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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 >>>>> 2013-05-23 14:37:29 3124 TRACE nova compiled_sql, distilled_params >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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 >>>>> 2013-05-23 14:37:29 3124 TRACE nova context) >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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 >>>>> 2013-05-23 14:37:29 3124 TRACE nova None, sys.exc_info()[2] >>>>> 2013-05-23 14:37:29 3124 TRACE nova 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.idAS >>>>> services_id, services.host AS services_host, services.`binary` AS >>>>> services_binary, services.topic AS services_topic, services.report_count >>>>> AS >>>>> services_report_count, services.disabled AS services_disabled, >>>>> services.availability_zone AS services_availability_zone \nFROM services >>>>> \nWHERE services.deleted = %s AND services.host = %s AND services.`binary` >>>>> = %s \n LIMIT %s' (0, 'ComputeNode-1', 'nova-compute', 1) >>>>> 2013-05-23 14:37:29 3124 TRACE nova >>>>> >>>>> With respect to the above issue, I feel there exists some access to an >>>>> unknown column in the DB tables. >>>>> >>>>> The SERVICES table of the nova DB is as below >>>>> >>>>> mysql> desc services; >>>>> +--------------+--------------+------+-----+---------+----------------+ >>>>> | Field | Type | Null | Key | Default | Extra | >>>>> +--------------+--------------+------+-----+---------+----------------+ >>>>> | created_at | datetime | YES | | NULL | | >>>>> | updated_at | datetime | YES | | NULL | | >>>>> | deleted_at | datetime | YES | | NULL | | >>>>> | id | int(11) | NO | PRI | NULL | auto_increment | >>>>> | host | varchar(255) | YES | | NULL | | >>>>> | binary | varchar(255) | YES | | NULL | | >>>>> | topic | varchar(255) | YES | | NULL | | >>>>> | report_count | int(11) | NO | | NULL | | >>>>> | disabled | tinyint(1) | YES | | NULL | | >>>>> | deleted | int(11) | YES | | NULL | | >>>>> +--------------+--------------+------+-----+---------+----------------+ >>>>> >>>>> Kindly help me resolve the issue. >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> ---------------------------------------------- >>>>> Trinath Somanchi, >>>>> +91 9866 235 130 >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~openstack >>>>> Post to : openstack@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~openstack >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~openstack >>>>> Post to : openstack@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~openstack >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>> >>> >>> -- >>> Regards, >>> ---------------------------------------------- >>> Trinath Somanchi, >>> +91 9866 235 130 >>> >> >> > > > -- > Regards, > ---------------------------------------------- > Trinath Somanchi, > +91 9866 235 130 >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp