<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:311714188;
mso-list-type:hybrid;
mso-list-template-ids:-2041418278 662210176 67895321 67895323 67895311 67895321 67895323 67895311 67895321 67895323;}
@list l0:level1
{mso-level-text:%1-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Stefan,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">It looks like your nova db has been setup unproperly.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’ve exatly the same settings (1 controller, 1 network and 2 computes).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I check my nova DB :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">mysql> use nova;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">mysql> desc reservations;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">+------------+--------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| Field | Type | Null | Key | Default | Extra |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">+------------+--------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| created_at | datetime | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| updated_at | datetime | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| deleted_at | datetime | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| id | int(11) | NO | PRI | NULL | auto_increment |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| uuid | varchar(36) | NO | MUL | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| usage_id | int(11) | NO | MUL | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| project_id | varchar(255) | YES | MUL | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| resource | varchar(255) | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| delta | int(11) | NO | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| expire | datetime | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| deleted | int(11) | YES | | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">| user_id | varchar(255) | YES | MUL | NULL | |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">+------------+--------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">12 rows in set (0.00 sec)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">mysql><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">As you got this message :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333">, "Unknown column 'reservations.user_id' in 'field list'") 'SELECT reservations.created_at AS reservations_created_at, reservations<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><span style="mso-list:Ignore">1-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I will suggest to verify your DB version :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">[ctl]# nova-manage db version<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">216<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">[ctl]#<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><span style="mso-list:Ignore">2-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">drop the nova DB and create again then
<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><span style="mso-list:Ignore">3-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">create your nova db again<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><span style="mso-list:Ignore">4-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">then sync again<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D">[ctl]# nova-manage db sync<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Courier New";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hope that will help<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">---<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Samba.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Stefan Apostoaie [mailto:iosstef@gmail.com]
<br>
<b>Sent:</b> mardi 18 mars 2014 17:42<br>
<b>To:</b> openstack@lists.openstack.org<br>
<b>Subject:</b> [Openstack] [Nova] Error when creating an instance<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I encountered an issue on a clean openstack havana install (one controller node, two compute nodes, and one network node) when creating multiple instances. Some instances were created but other entered in the error state. Looking in the
logs I noticed that the openstack-nova-scheduler had some database related errors (logs can be found bellow). Has anyone encountered this issue? What is causing this?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Stefan<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The error in the nova-scheduler log:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333">Error during SchedulerManager._expire_reservations: (OperationalError) (1054, "Unknown column 'reservations.user_id' in 'field list'") 'SELECT reservations.created_at
AS reservations_created_at, reservations.updated_at AS reservations_updated_at, reservations.deleted_at AS reservations_deleted_at, reservations.deleted AS reservations_deleted,
<a href="http://reservations.id">reservations.id</a> AS reservations_id, reservations.uuid AS reservations_uuid, reservations.usage_id AS reservations_usage_id, reservations.project_id AS reservations_project_id, reservations.user_id AS reservations_user_id,
reservations.resource AS reservations_resource, reservations.delta AS reservations_delta, reservations.expire AS reservations_expire \nFROM reservations INNER JOIN quota_usages ON
<a href="http://quota_usages.id">quota_usages.id</a> = reservations.usage_id \nWHERE reservations.deleted = %s AND reservations.expire < %s' (0, datetime.datetime(2014, 3, 18, 12, 58, 8, 784970))<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task Traceback (most recent call last):<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/openstack/common/periodic_task.py", line 180, in run_periodic_tasks<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task task(self, context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/scheduler/manager.py", line 273, in _expire_reservations<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task QUOTAS.expire(context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/quota.py", line 1368, in expire<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task self._driver.expire(context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/quota.py", line 609, in expire<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task db.reservation_expire(context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/db/api.py", line 1112, in reservation_expire<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task return IMPL.reservation_expire(context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py", line 108, in wrapper<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task return f(*args, **kwargs)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py", line 3337, in reservation_expire<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task for reservation in reservation_query.join(models.QuotaUsage).all():<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2115, in all<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task return list(self)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2227, in _<em><span style="font-family:"Arial","sans-serif"">iter</span></em>_<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task return self._execute_and_instances(context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task result = conn.execute(querycontext.statement, self._params)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1449, in execute<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task params)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task compiled_sql, distilled_params<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1698, in _execute_context<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task context)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task cursor.execute(statement, parameters)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task self.errorhandler(self, exc, value)<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task raise errorclass, errorvalue<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task OperationalError: (OperationalError) (1054, "Unknown column 'reservations.user_id' in 'field list'") 'SELECT reservations.created_at AS reservations_created_at, reservations.updated_at
AS reservations_updated_at, reservations.deleted_at AS reservations_deleted_at, reservations.deleted AS reservations_deleted,
<a href="http://reservations.id">reservations.id</a> AS reservations_id, reservations.uuid AS reservations_uuid, reservations.usage_id AS reservations_usage_id, reservations.project_id AS reservations_project_id, reservations.user_id AS reservations_user_id,
reservations.resource AS reservations_resource, reservations.delta AS reservations_delta, reservations.expire AS reservations_expire \nFROM reservations INNER JOIN quota_usages ON
<a href="http://quota_usages.id">quota_usages.id</a> = reservations.usage_id \nWHERE reservations.deleted = %s AND reservations.expire < %s' (0, datetime.datetime(2014, 3, 18, 12, 58, 8, 784970))<br>
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>