<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 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I installed a three node openstack Mitaka and installed Manila packages. The services run fine but when I go to list the services it throws the ‘ERROR: The server has either erred or is incapable of performing the requested operation.’
Looking at the logs I found:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"># manila-scheduler.log<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service err.raise_mysql_exception(self._data)<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service _check_mysql_exception(errinfo)<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service raise InternalError(errno, errorvalue)<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'services.availability_zone_id' 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.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_id AS services_availability_zone_id \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': 'neutron', u'param_1': 1, u'deleted_1': 0, u'binary_1': 'manila-scheduler'}]<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:18:32.250 13456 ERROR oslo_service.service<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"># manila-api.log<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault File "/usr/lib/python2.7/dist-packages/keystoneauth1/identity/base.py", line 136, in get_access<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault self.auth_ref = self.get_auth_ref(session)<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault File "/usr/lib/python2.7/dist-packages/keystoneauth1/identity/generic/base.py", line 179, in get_auth_ref<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault self._plugin = self._do_create_plugin(session)<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault File "/usr/lib/python2.7/dist-packages/keystoneauth1/identity/generic/base.py", line 174, in _do_create_plugin<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault raise exceptions.DiscoveryFailure('Could not determine a suitable URL '<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault DiscoveryFailure: Could not determine a suitable URL for the plugin<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.787 13675 ERROR manila.api.middleware.fault<o:p></o:p></p>
<p class="MsoNormal">2016-07-12 16:21:15.834 13675 INFO manila.api.middleware.fault [-]
<a href="http://1.x.x.x:8786/v2/dc4a4922954b5e57498254e1/services%20returned%20with%20HTTP%20500">
http://1.x.x.x:8786/v2/dc4a4922954b5e57498254e1/services returned with HTTP 500</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you.<o:p></o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by
you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of
internal compliance with Accenture policy. <br>
______________________________________________________________________________________<br>
<br>
www.accenture.com<br>
</font>
</body>
</html>