← Back to team overview

openstack team mailing list archive

Re: Nova Compute Errors

 

Hi-

I now get this error with respect to RPC version mismatch

root@ComputeNode:~# nova-compute
2013-05-24 14:55:05.365 4022 INFO nova.manager [-] Skipping periodic task
_periodic_update_dns because its interval is negative
2013-05-24 14:55:05.834 4022 INFO nova.virt.driver [-] Loading compute
driver 'libvirt.LibvirtDriver'
2013-05-24 14:55:06.307 INFO nova.openstack.common.rpc.common
[req-8da356a3-fecb-4dba-99a7-0fcac69750d7 None None] Connected to AMQP
server on 10.232.91.81:5672
2013-05-24 14:55:06.402 4022 AUDIT nova.service [-] Starting compute node
(version 2013.1.1)
Traceback (most recent call last):
  File
"/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/poll.py",
line 97, in wait
    readers.get(fileno, noop).cb(fileno)
  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.1-py2.7.egg/nova/service.py",
line 147, in run_server
    server.start()
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 429, in start
    self.manager.init_host()
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/compute/manager.py",
line 588, in init_host
    self.host)
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/conductor/api.py",
line 409, in instance_get_all_by_host
    context, host, columns_to_join=columns_to_join)
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/conductor/rpcapi.py",
line 316, in instance_get_all_by_host
    return self.call(context, msg, version='1.47')
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/proxy.py",
line 80, in call
    return rpc.call(context, self._get_topic(topic), msg, timeout)
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/__init__.py",
line 140, in call
    return _get_impl().call(CONF, context, topic, msg, timeout)
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/impl_kombu.py",
line 798, in call
    rpc_amqp.get_connection_pool(conf, Connection))
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/amqp.py",
line 612, in call
    rv = list(rv)
  File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/amqp.py",
line 561, in __iter__
    raise result
RemoteError: Remote error: UnsupportedRpcVersion Specified RPC version,
1.47, not supported by this endpoint.
[u'Traceback (most recent call last):\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line
430, in _process_data\n    rval = self.proxy.dispatch(ctxt, version,
method, **args)\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py",
line 138, in dispatch\n    raise
rpc_common.UnsupportedRpcVersion(version=version)\n',
u'UnsupportedRpcVersion: Specified RPC version, 1.47, not supported by this
endpoint.\n'].
Removing descriptor: 5
2013-05-24 14:55:06.484 4022 CRITICAL nova [-] Remote error:
UnsupportedRpcVersion Specified RPC version, 1.47, not supported by this
endpoint.
[u'Traceback (most recent call last):\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line
430, in _process_data\n    rval = self.proxy.dispatch(ctxt, version,
method, **args)\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py",
line 138, in dispatch\n    raise
rpc_common.UnsupportedRpcVersion(version=version)\n',
u'UnsupportedRpcVersion: Specified RPC version, 1.47, not supported by this
endpoint.\n'].
2013-05-24 14:55:06.484 4022 TRACE nova Traceback (most recent call last):
2013-05-24 14:55:06.484 4022 TRACE nova   File "/usr/bin/nova-compute",
line 5, in <module>
2013-05-24 14:55:06.484 4022 TRACE nova
pkg_resources.run_script('nova==2013.1.1', 'nova-compute')
2013-05-24 14:55:06.484 4022 TRACE nova   File
"build/bdist.linux-ppc/egg/pkg_resources.py", line 505, in run_script
2013-05-24 14:55:06.484 4022 TRACE nova
self.require(requires)[0].run_script(script_name, ns)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"build/bdist.linux-ppc/egg/pkg_resources.py", line 1245, in run_script
2013-05-24 14:55:06.484 4022 TRACE nova     execfile(script_filename,
namespace, namespace)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/EGG-INFO/scripts/nova-compute",
line 85, in <module>
2013-05-24 14:55:06.484 4022 TRACE nova     service.wait()
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 689, in wait
2013-05-24 14:55:06.484 4022 TRACE nova     _launcher.wait()
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 209, in wait
2013-05-24 14:55:06.484 4022 TRACE nova     super(ServiceLauncher,
self).wait()
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 179, in wait
2013-05-24 14:55:06.484 4022 TRACE nova     service.wait()
2013-05-24 14:55:06.484 4022 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-24 14:55:06.484 4022 TRACE nova     return self._exit_event.wait()
2013-05-24 14:55:06.484 4022 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-24 14:55:06.484 4022 TRACE nova     return hubs.get_hub().switch()
2013-05-24 14:55:06.484 4022 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-24 14:55:06.484 4022 TRACE nova     return self.greenlet.switch()
2013-05-24 14:55:06.484 4022 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-24 14:55:06.484 4022 TRACE nova     result = function(*args,
**kwargs)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 147, in run_server
2013-05-24 14:55:06.484 4022 TRACE nova     server.start()
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/service.py",
line 429, in start
2013-05-24 14:55:06.484 4022 TRACE nova     self.manager.init_host()
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/compute/manager.py",
line 588, in init_host
2013-05-24 14:55:06.484 4022 TRACE nova     self.host)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/conductor/api.py",
line 409, in instance_get_all_by_host
2013-05-24 14:55:06.484 4022 TRACE nova     context, host,
columns_to_join=columns_to_join)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/conductor/rpcapi.py",
line 316, in instance_get_all_by_host
2013-05-24 14:55:06.484 4022 TRACE nova     return self.call(context, msg,
version='1.47')
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/proxy.py",
line 80, in call
2013-05-24 14:55:06.484 4022 TRACE nova     return rpc.call(context,
self._get_topic(topic), msg, timeout)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/__init__.py",
line 140, in call
2013-05-24 14:55:06.484 4022 TRACE nova     return _get_impl().call(CONF,
context, topic, msg, timeout)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/impl_kombu.py",
line 798, in call
2013-05-24 14:55:06.484 4022 TRACE nova
rpc_amqp.get_connection_pool(conf, Connection))
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/amqp.py",
line 612, in call
2013-05-24 14:55:06.484 4022 TRACE nova     rv = list(rv)
2013-05-24 14:55:06.484 4022 TRACE nova   File
"/usr/lib/python2.7/site-packages/nova-2013.1.1-py2.7.egg/nova/openstack/common/rpc/amqp.py",
line 561, in __iter__
2013-05-24 14:55:06.484 4022 TRACE nova     raise result
2013-05-24 14:55:06.484 4022 TRACE nova RemoteError: Remote error:
UnsupportedRpcVersion Specified RPC version, 1.47, not supported by this
endpoint.
2013-05-24 14:55:06.484 4022 TRACE nova [u'Traceback (most recent call
last):\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/amqp.py", line
430, in _process_data\n    rval = self.proxy.dispatch(ctxt, version,
method, **args)\n', u'  File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/dispatcher.py",
line 138, in dispatch\n    raise
rpc_common.UnsupportedRpcVersion(version=version)\n',
u'UnsupportedRpcVersion: Specified RPC version, 1.47, not supported by this
endpoint.\n'].
2013-05-24 14:55:06.484 4022 TRACE nova






On Thu, May 23, 2013 at 4:58 PM, Rahul Sharma <rahulsharmaait@xxxxxxxxx>wrote:

> 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@xxxxxxxxx> 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@xxxxxxxxx>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@xxxxxxxxx> 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@xxxxxxxxx
>>>> > 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@xxxxxxxxx> wrote:
>>>>>
>>>>>> Did you run an upgrade?
>>>>>> try maybe :
>>>>>> $nova-manage db sync
>>>>>>
>>>>>> (make a backup first)
>>>>>>
>>>>>> regards,
>>>>>>
>>>>>> *Razique Mahroua** - **Nuage & Co*
>>>>>> razique.mahroua@xxxxxxxxx
>>>>>> Tel : +33 9 72 37 94 15
>>>>>>
>>>>>>
>>>>>> Le 23 mai 2013 à 11:19, Trinath Somanchi <trinath.somanchi@xxxxxxxxx>
>>>>>> 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.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
>>>>>>
>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~openstack
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~openstack
>>>>>> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>>>>>> 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
>>
>
>


-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130

References