[Openstack] Nova Compute Errors

Rahul Sharma rahulsharmaait at gmail.com
Thu May 23 11:28:10 UTC 2013


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.somanchi at 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 <rahulsharmaait at 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.somanchi at 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 <rahulsharmaait at 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.mahroua at gmail.com> wrote:
>>>>
>>>>> Did you run an upgrade?
>>>>> try maybe :
>>>>> $nova-manage db sync
>>>>>
>>>>> (make a backup first)
>>>>>
>>>>> regards,
>>>>>
>>>>> *Razique Mahroua** - **Nuage & Co*
>>>>> razique.mahroua at gmail.com
>>>>> Tel : +33 9 72 37 94 15
>>>>>
>>>>>
>>>>> Le 23 mai 2013 à 11:19, Trinath Somanchi <trinath.somanchi at 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 at lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~openstack
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~openstack
>>>>> Post to     : openstack at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130523/1a450157/attachment.html>


More information about the Openstack mailing list