<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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="EN-IN" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Javier, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks that helped </span><span style="font-family:Wingdings;color:#1F497D">J</span><span style="color:#1F497D"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN">/Sonali<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-IN">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-IN"> Sonali Jadhav
<br>
<b>Sent:</b> 16 November 2017 05:45 PM<br>
<b>To:</b> 'Javier Pena' <javier.pena@redhat.com><br>
<b>Cc:</b> users@lists.rdoproject.org<br>
<b>Subject:</b> RE: [rdo-users] packstack allinone POC - unable to get openstack running ERROR oslo_service.service<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Javier,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I have tried doing it from scratch, but every time I end up at same error which I reported in my first mail.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ll give a try to what you suggested though.
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN">/Sonali<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-IN">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-IN"> Javier Pena [<a href="mailto:javier.pena@redhat.com">mailto:javier.pena@redhat.com</a>]
<br>
<b>Sent:</b> 16 November 2017 04:40 PM<br>
<b>To:</b> Sonali Jadhav <<a href="mailto:sonali@servercentralen.se">sonali@servercentralen.se</a>><br>
<b>Cc:</b> <a href="mailto:users@lists.rdoproject.org">users@lists.rdoproject.org</a><br>
<b>Subject:</b> Re: [rdo-users] packstack allinone POC - unable to get openstack running ERROR oslo_service.service<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="color:black">Hi Sonali,</span><span style="font-size:12.0pt;color:black;mso-fareast-language:EN-IN"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">At this stage, it looks like the Nova database is not in a very good shape :-/. If you don't want to reinstall and start again from scratch, we could try the following:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">- Stop all Nova services<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">- Try to drop all the tables from the Nova database, and then re-run "nova-manage db sync"<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">- If it works fine, run packstack again with the same answer file<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Regards,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Javier<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:black">
<hr size="2" width="100%" align="center">
</span></div>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><a name="_MailEndCompose"></a><span style="color:#1F497D">Hi Javier,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks for the response. I thought same before, since I had searched for that error. But I had executed “nova-manage db sync” before as well and rerun entire packstack, didn’t helped.
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">My system is running on 98GB ram and 60G of SSD disks.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I tried just now for this new installation again,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I get this,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[root@ostest ~]# nova-manage db sync</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">An error has occurred:</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Traceback (most recent call last):</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 1797, in main</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> ret = fn(*fn_args, **fn_kwargs)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 711, in sync</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return migration.db_sync(version)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return IMPL.db_sync(version=version, database=database, context=context)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> repository, version)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return _migrate(url, repository, version, upgrade=True, err=err, **opts)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "<string>", line 2, in _migrate</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return f(*a, **kw)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> schema.runchange(ver, change, changeset.step)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> change.run(self.engine, step)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> script_func(engine)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py", line 1044, in upgrade</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> instances.create()</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 756, in create</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> checkfirst=checkfirst)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1929, in _run_visitor</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> conn._run_visitor(visitorcallable, element, **kwargs)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> **kwargs).traverse_single(element)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return meth(obj, **kw)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 767, in visit_table</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> include_foreign_key_constraints=include_foreign_key_constraints</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return meth(self, multiparams, params)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> return connection._execute_ddl(self, multiparams, params)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> compiled</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> context)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> util.raise_from_cause(newraise, exc_info)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> reraise(type(exception), exception, tb=exc_tb, cause=cause)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> context)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> cursor.execute(statement, parameters)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> result = self._query(query)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> conn.query(q)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> self._affected_rows = self._read_query_result(unbuffered=unbuffered)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> result.read()</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> first_packet = self.connection._read_packet()</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> packet.check_error()</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> err.raise_mysql_exception(self._data)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> raise errorclass(errno, errval)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">DBError: (pymysql.err.InternalError) (1050, u"Table 'instances' already exists") [SQL: u"\nCREATE TABLE instances (\n\tcreated_at DATETIME, \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tid INTEGER NOT
NULL AUTO_INCREMENT, \n\tinternal_id INTEGER, \n\tuser_id VARCHAR(255), \n\tproject_id VARCHAR(255), \n\timage_ref VARCHAR(255), \n\tkernel_id VARCHAR(255), \n\tramdisk_id VARCHAR(255), \n\tlaunch_index INTEGER, \n\tkey_name VARCHAR(255), \n\tkey_data MEDIUMTEXT,
\n\tpower_state INTEGER, \n\tvm_state VARCHAR(255), \n\tmemory_mb INTEGER, \n\tvcpus INTEGER, \n\thostname VARCHAR(255), \n\thost VARCHAR(255), \n\tuser_data MEDIUMTEXT, \n\treservation_id VARCHAR(255), \n\tscheduled_at DATETIME, \n\tlaunched_at DATETIME,
\n\tterminated_at DATETIME, \n\tdisplay_name VARCHAR(255), \n\tdisplay_description VARCHAR(255), \n\tavailability_zone VARCHAR(255), \n\tlocked BOOL, \n\tos_type VARCHAR(255), \n\tlaunched_on MEDIUMTEXT, \n\tinstance_type_id INTEGER, \n\tvm_mode VARCHAR(255),
\n\tuuid VARCHAR(36), \n\tarchitecture VARCHAR(255), \n\troot_device_name VARCHAR(255), \n\taccess_ip_v4 VARCHAR(39), \n\taccess_ip_v6 VARCHAR(39), \n\tconfig_drive VARCHAR(255), \n\ttask_state VARCHAR(255), \n\tdefault_ephemeral_device VARCHAR(255), \n\tdefault_swap_device
VARCHAR(255), \n\tprogress INTEGER, \n\tauto_disk_config BOOL, \n\tshutdown_terminate BOOL, \n\tdisable_terminate BOOL, \n\troot_gb INTEGER, \n\tephemeral_gb INTEGER, \n\tcell_name VARCHAR(255), \n\tnode VARCHAR(255), \n\tdeleted INTEGER, \n\tlocked_by ENUM('owner','admin'),
\n\tcleaned INTEGER, \n\tPRIMARY KEY (id), \n\tCHECK (locked IN (0, 1)), \n\tCHECK (auto_disk_config IN (0, 1)), \n\tCHECK (shutdown_terminate IN (0, 1)), \n\tCHECK (disable_terminate IN (0, 1))\n)ENGINE=InnoDB CHARSET=utf8\n\n"]</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">[root@ostest ~]#</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN">Thanks,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-IN">/Sonali</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="color:black;mso-fareast-language:EN-IN">From:</span></b><span lang="EN-US" style="color:black;mso-fareast-language:EN-IN"> Javier Pena [<a href="mailto:javier.pena@redhat.com">mailto:javier.pena@redhat.com</a>]
<br>
<b>Sent:</b> 14 November 2017 05:49 PM<br>
<b>To:</b> Sonali Jadhav <<a href="mailto:sonali@servercentralen.se">sonali@servercentralen.se</a>><br>
<b>Cc:</b> <a href="mailto:users@lists.rdoproject.org">users@lists.rdoproject.org</a><br>
<b>Subject:</b> Re: [rdo-users] packstack allinone POC - unable to get openstack running ERROR oslo_service.service</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="color:black">Hi Sonali,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">The source for the issues is here:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
</div>
<div>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">Error: /Stage[main]/Nova:db::Sync/Exec[nova-db-sync]: Failed to call refresh: Command exceeded timeout<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black"> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">That means that the "nova-manage db sync" command took too long to execute, and Puppet considered that as a failure. This usually happens when your disk is very slow or the machine you are
using to run Packstack is low on RAM and constantly swapping.<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black"> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">As a quick fix, I'd suggest to:<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black"> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">- Run "nova-manage db sync" as root.<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">- Re-run packstack using the same answer file.<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black"> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">Regards,<o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="color:black">Javier<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:black">
<hr size="2" width="100%" align="center">
</span></div>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:black">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am trying to implement all-in-one concept cloud with Packstack on Centos 7. But I am having problem.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">My command “#packstack –allinone” end with following error,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Preparing Puppet manifests [ DONE ]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Copying Puppet modules and manifests [ DONE ]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Applying 172.16.5.184_controller.pp<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">172.16.5.184_controller.pp: [ ERROR ] <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Applying Puppet manifests [ ERROR ]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">ERROR : Error appeared during Puppet run: 192.6.5.184_controller.pp<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Error: /Stage[main]/Nova::Db::Sync/Exec[nova-db-sync]: Failed to call refresh: Command exceeded timeout<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">You will find full trace in log /var/tmp/packstack/20171113-141949-w6oJW4/manifests/172.16.5.184_controller.pp.log<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Please check log file /var/tmp/packstack/20171113-141949-w6oJW4/openstack-setup.log for more information<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Additional information:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">* A new answerfile was created in: /root/packstack-answers-20171113-141950.txt<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">* Time synchronization installation was skipped. Please note that unsynchronized time on server instances might be problem for some OpenStack components.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">* File /root/keystonerc_admin has been created on OpenStack client host 192.6.5.184. To use the command line tools you need to source the file.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">* To access the OpenStack Dashboard browse to
<a href="http://192.6.5.184/dashboard" target="_blank">http://192.6.5.184/dashboard</a> .<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Please, find your login credentials stored in the keystonerc_admin in your home directory.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am able to bowse dashboard but once I enter username and pwd , it’s not loading further.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I checked nova logs,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am getting these errors,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.061 30815 INFO nova.service [-] Starting consoleauth node (version 16.0.2-1.el7)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters [req-6df91cfa-5d3e-4738-9d5e-06e0109a8175 - - - - -] DBAPIError exception wrapped from (pymysql.err.InternalError) (1054, u"Unknown column 'services.uuid'
in 'field list'") [SQL: u'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.uuid AS services_uuid,
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.disabled_reason AS services_disabled_reason, services.last_seen_up
AS services_last_seen_up, services.forced_down AS services_forced_down, services.version AS services_version \nFROM services \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND services.`binary` = %(binary_1)s \n LIMIT %(param_1)s']
[parameters: {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1': 'nova-consoleauth'}]: InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'")<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters context)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters result.read()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'")<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service [req-6df91cfa-5d3e-4738-9d5e-06e0109a8175 - - - - -] Error starting thread.: DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'services.uuid'
in 'field list'") [SQL: u'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.uuid AS services_uuid,
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.disabled_reason AS services_disabled_reason, services.last_seen_up
AS services_last_seen_up, services.forced_down AS services_forced_down, services.version AS services_version \nFROM services \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND services.`binary` = %(binary_1)s \n LIMIT %(param_1)s']
[parameters: {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1': 'nova-consoleauth'}]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service Traceback (most recent call last):<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/oslo_service/service.py", line 721, in run_service<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service service.start()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/nova/service.py", line 147, in start<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service ctxt, self.host, self.binary)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result = fn(cls, context, *args, **kwargs)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/nova/objects/service.py", line 296, in get_by_host_and_binary<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service host, binary)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 133, in service_get_by_host_and_binary<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return IMPL.service_get_by_host_and_binary(context, host, binary)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 265, in wrapped<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return f(context, *args, **kwargs)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 554, in service_get_by_host_and_binary<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service filter_by(binary=binary).\<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2755, in first<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service ret = list(self[0:1])<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2547, in __getitem__<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return list(res)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return self._execute_and_instances(context)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result = conn.execute(querycontext.statement, self._params)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return meth(self, multiparams, params)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return connection._execute_clauseelement(self, multiparams, params)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service compiled_sql, distilled_params<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service context)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service util.raise_from_cause(newraise, exc_info)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service reraise(type(exception), exception, tb=exc_tb, cause=cause)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service context)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service cursor.execute(statement, parameters)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result = self._query(query)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service conn.query(q)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service self._affected_rows = self._read_query_result(unbuffered=unbuffered)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result.read()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service first_packet = self.connection._read_packet()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service packet.check_error()<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service err.raise_mysql_exception(self._data)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service raise errorclass(errno, errval)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'services.uuid' in 'field list'") [SQL: u'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.uuid AS services_uuid, 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.disabled_reason AS services_disabled_reason, services.last_seen_up AS services_last_seen_up, services.forced_down AS services_forced_down,
services.version AS services_version \nFROM services \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND services.`binary` = %(binary_1)s \n LIMIT %(param_1)s'] [parameters: {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1':
'nova-consoleauth'}]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">2017-11-14 12:51:22.469 30815 ERROR oslo_service.service<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">^C<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in
raise_mysql_exception</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1054, u"Unknown column 'aggregates.uuid' in 'field list'")</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters
</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.197 2949 CRITICAL nova [req-2d6ddb32-c998-4123-a7ba-e1a0da9648e1 - - - - -] Unhandled error: DBError: (pymysql.err.InternalError)
(1054, u"Unknown column 'aggregates.uuid' in 'field list'") [SQL: u'SELECT aggregates.created_at AS aggregates_created_at, aggregates.updated_at AS aggregates_updated_at, aggregates.deleted_at AS aggregates_deleted_at, aggregates.deleted AS aggregates_deleted,
aggregates.id AS aggregates_id, aggregates.uuid AS aggregates_uuid, aggregates.name AS aggregates_name, aggregate_hosts_1.created_at AS aggregate_hosts_1_created_at, aggregate_hosts_1.updated_at AS aggregate_hosts_1_updated_at, aggregate_hosts_1.deleted_at
AS aggregate_hosts_1_deleted_at, aggregate_hosts_1.deleted AS aggregate_hosts_1_deleted, aggregate_hosts_1.id AS aggregate_hosts_1_id, aggregate_hosts_1.host AS aggregate_hosts_1_host, aggregate_hosts_1.aggregate_id AS aggregate_hosts_1_aggregate_id, aggregate_metadata_1.created_at
AS aggregate_metadata_1_created_at, aggregate_metadata_1.updated_at AS aggregate_metadata_1_updated_at, aggregate_metadata_1.deleted_at AS aggregate_metadata_1_deleted_at, aggregate_metadata_1.deleted AS aggregate_metadata_1_deleted, aggregate_metadata_1.id
AS aggregate_metadata_1_id, aggregate_metadata_1.`key` AS aggregate_metadata_1_key, aggregate_metadata_1.value AS aggregate_metadata_1_value, aggregate_metadata_1.aggregate_id AS aggregate_metadata_1_aggregate_id \nFROM aggregates LEFT OUTER JOIN aggregate_hosts
AS aggregate_hosts_1 ON aggregates.id = aggregate_hosts_1.aggregate_id AND aggregate_hosts_1.deleted = %(deleted_1)s AND aggregates.deleted = %(deleted_2)s LEFT OUTER JOIN aggregate_metadata AS aggregate_metadata_1 ON aggregates.id = aggregate_metadata_1.aggregate_id
AND aggregate_metadata_1.deleted = %(deleted_3)s AND aggregates.deleted = %(deleted_4)s \nWHERE aggregates.deleted = %(deleted_5)s'] [parameters: {u'deleted_5': 0, u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0}]</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.197 2949 ERROR nova Traceback (most recent call last):</span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.197 2949 ERROR nova File "/usr/bin/nova-scheduler", line 10, in <module></span><span style="color:black"><o:p></o:p></span></p>
<p style="margin:0cm;margin-bottom:.0001pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">2017-11-13 15:17:13.197 2949 ERROR nova sys.exit(main())</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am unable to figure out the issue here. Can anyone help me figure it out?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">/Sonali<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN"><br>
_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.rdoproject.org" target="_blank">users@lists.rdoproject.org</a><br>
<a href="http://lists.rdoproject.org/mailman/listinfo/users" target="_blank">http://lists.rdoproject.org/mailman/listinfo/users</a></span><span style="color:black"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN">To unsubscribe:
<a href="mailto:users-unsubscribe@lists.rdoproject.org" target="_blank">users-unsubscribe@lists.rdoproject.org</a></span><span style="color:black"><o:p></o:p></span></p>
</blockquote>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;mso-fareast-language:EN-IN"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN"><br>
_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.rdoproject.org">users@lists.rdoproject.org</a><br>
<a href="http://lists.rdoproject.org/mailman/listinfo/users">http://lists.rdoproject.org/mailman/listinfo/users</a><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:black;mso-fareast-language:EN-IN">To unsubscribe:
<a href="mailto:users-unsubscribe@lists.rdoproject.org">users-unsubscribe@lists.rdoproject.org</a><o:p></o:p></span></p>
</blockquote>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;mso-fareast-language:EN-IN"><o:p> </o:p></span></p>
</div>
</div>
</div>
</body>
</html>