<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Did you run an upgrade? <div>try maybe : </div><div>$nova-manage db sync</div><div><br></div><div>(make a backup first)</div><div><br></div><div>regards,</div><div><br><div apple-content-edited="true">
<span class="Apple-style-span" style="color: rgb(0, 0, 0); font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; font-family: 'Lucida Grande'; border-spacing: 0px; -webkit-text-decorations-in-effect: none; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Razique Mahroua</b></span><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; color: rgb(19, 112, 138); "><b> - </b></span><span class="Apple-style-span" style="font-family: Helvetica; "><span class="Apple-style-span" style="font-weight: normal; font-family: Helvetica; "><b style="color: rgb(19, 112, 138); ">Nuage & Co</b></span><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; border-spacing: 0px; -webkit-text-decorations-in-effect: none; "><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="font-weight: normal; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a"><a href="mailto:razique.mahroua@gmail.com">razique.mahroua@gmail.com</a></font></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; "><font class="Apple-style-span" color="#13708a">Tel : +33 9 72 37 94 15</font></div></span></span></span></span></span><br class="Apple-interchange-newline" style="color: rgb(0, 0, 0); font-family: Arial; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span><img height="125" width="125" id="94d1e145-132a-4223-9ce5-c5ae98aa4bea" apple-width="yes" apple-height="yes" src="cid:0A2450C8-6A0D-42D0-8035-743CAD564432@fabrique.lan"></span>
</div>
<br><div><div>Le 23 mai 2013 à 11:19, Trinath Somanchi <<a href="mailto:trinath.somanchi@gmail.com">trinath.somanchi@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi Stackers-<div><br></div><div>I have installed nova-compute from the source code, with command, "python setup.py install". </div><div><br></div><div>Also, configured the configuration files.</div><div><br></div>
<div>When I start the "nova-compute" service, I get the following issues.</div><div><br></div><div><div>2013-05-23 14:37:27 3124 AUDIT nova.service [-] Starting compute node (version 2013.1-LOCALBRANCH:LOCALREVISION)</div>
<div>2013-05-23 14:37:27 3124 DEBUG nova.virt.libvirt.driver [-] Connecting to libvirt: <a href="qemu:///system">qemu:///system</a> _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340</div><div>2013-05-23 14:37:28 INFO nova.compute.manager [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Updating host status</div>
<div>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</div>
<div>2013-05-23 14:37:28 DEBUG nova.virt.libvirt.driver [req-f5cbe8c7-1fba-430d-965d-e6f72cef1ad2 None None] Connecting to libvirt: <a href="qemu:///system">qemu:///system</a> _get_connection /usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/virt/libvirt/driver.py:340</div>
<div>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</div>
<div>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</div>
<div>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</div><div>
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</div><div>2013-05-23 14:37:29 3124 INFO nova.openstack.common.rpc.common [-] Connected to AMQP server on <a href="http://10.232.91.81:5672/">10.232.91.81:5672</a></div>
<div>Traceback (most recent call last):</div><div> File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/hub.py", line 346, in fire_timers</div><div> timer()</div><div> File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/hubs/timer.py", line 56, in __call__</div>
<div> cb(*args, **kw)</div><div> File "/usr/lib/python2.7/site-packages/eventlet-0.12.1-py2.7.egg/eventlet/greenthread.py", line 194, in main</div><div> result = function(*args, **kwargs)</div><div> File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", line 124, in run_server</div>
<div> server.start()</div><div> File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/service.py", line 399, in start</div><div> self.binary)</div><div> File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/api.py", line 158, in service_get_by_args</div>
<div> return IMPL.service_get_by_args(context, host, binary)</div><div> File "/usr/lib/python2.7/site-packages/nova-2013.1-py2.7.egg/nova/db/sqlalchemy/api.py", line 107, in wrapper</div><div> return f(*args, **kwargs)</div>
<div> 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</div><div> filter_by(binary=binary).\</div><div> File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2156, in first</div>
<div> ret = list(self[0:1])</div><div> File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2023, in __getitem__</div><div> return list(res)</div><div>
File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/orm/query.py", line 2227, in __iter__</div><div> return self._execute_and_instances(context)</div><div> 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</div>
<div> result = conn.execute(querycontext.statement, self._params)</div><div> File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-ppc.egg/sqlalchemy/engine/base.py", line 1449, in execute</div>
<div> params)</div><div> 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</div><div> compiled_sql, distilled_params</div>
<div> 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</div><div> context)</div><div> 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</div>
<div> None, sys.exc_info()[2]</div><div>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, <a href="http://services.id/">services.id</a> 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)</div>
<div>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, <a href="http://services.id/">services.id</a> 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)</div>
<div>2013-05-23 14:37:29 3124 TRACE nova Traceback (most recent call last):</div><div>2013-05-23 14:37:29 3124 TRACE nova File "/usr/bin/nova-compute", line 5, in <module></div><div>2013-05-23 14:37:29 3124 TRACE nova pkg_resources.run_script('nova==2013.1', 'nova-compute')</div>
<div>2013-05-23 14:37:29 3124 TRACE nova File "/usr/lib/python2.7/site-packages/pkg_resources.py", line 505, in run_script</div><div>2013-05-23 14:37:29 3124 TRACE nova self.require(requires)[0].run_script(script_name, ns)</div>
<div>2013-05-23 14:37:29 3124 TRACE nova File "/usr/lib/python2.7/site-packages/pkg_resources.py", line 1245, in run_script</div><div>2013-05-23 14:37:29 3124 TRACE nova execfile(script_filename, namespace, namespace)</div>
<div>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></div><div>2013-05-23 14:37:29 3124 TRACE nova service.wait()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova _launcher.wait()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova super(ServiceLauncher, self).wait()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova service.wait()</div><div>
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</div><div>2013-05-23 14:37:29 3124 TRACE nova return self._exit_event.wait()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova return hubs.get_hub().switch()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova return self.greenlet.switch()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova result = function(*args, **kwargs)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova server.start()</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova self.binary)</div><div>
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</div><div>2013-05-23 14:37:29 3124 TRACE nova return IMPL.service_get_by_args(context, host, binary)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova return f(*args, **kwargs)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova filter_by(binary=binary).\</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova ret = list(self[0:1])</div>
<div>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__</div><div>2013-05-23 14:37:29 3124 TRACE nova return list(res)</div>
<div>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__</div><div>2013-05-23 14:37:29 3124 TRACE nova return self._execute_and_instances(context)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova result = conn.execute(querycontext.statement, self._params)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova params)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova compiled_sql, distilled_params</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova context)</div>
<div>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</div><div>2013-05-23 14:37:29 3124 TRACE nova None, sys.exc_info()[2]</div>
<div>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, <a href="http://services.id/">services.id</a> 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)</div>
<div>2013-05-23 14:37:29 3124 TRACE nova </div><div><br></div><div>With respect to the above issue, I feel there exists some access to an unknown column in the DB tables.</div><div><br></div><div>The SERVICES table of the nova DB is as below</div>
<div><br></div><div><div>mysql> desc services;</div><div>+--------------+--------------+------+-----+---------+----------------+</div><div>| Field | Type | Null | Key | Default | Extra |</div><div>
+--------------+--------------+------+-----+---------+----------------+</div><div>| created_at | datetime | YES | | NULL | |</div><div>| updated_at | datetime | YES | | NULL | |</div>
<div>| deleted_at | datetime | YES | | NULL | |</div><div>| id | int(11) | NO | PRI | NULL | auto_increment |</div><div>| host | varchar(255) | YES | | NULL | |</div>
<div>| binary | varchar(255) | YES | | NULL | |</div><div>| topic | varchar(255) | YES | | NULL | |</div><div>| report_count | int(11) | NO | | NULL | |</div>
<div>| disabled | tinyint(1) | YES | | NULL | |</div><div>| deleted | int(11) | YES | | NULL | |</div><div>+--------------+--------------+------+-----+---------+----------------+</div>
</div><div><br></div><div>Kindly help me resolve the issue.</div><div><br></div><div><br></div><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>Trinath Somanchi,<div>+91 9866 235 130</div>
</div>
_______________________________________________<br>Mailing list: <a href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>Unsubscribe : <a href="https://launchpad.net/~openstack">https://launchpad.net/~openstack</a><br>More help : <a href="https://help.launchpad.net/ListHelp">https://help.launchpad.net/ListHelp</a><br></blockquote></div><br></div></body></html>