<div dir="ltr">Hi. Thanks for your bug report! Also I would recommend to add appropriate tags in future (like sahara in our case) to subject of the message so that more folks can read this message.<div><br></div><div>Let's continue discussions about the bug in launchpad.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Mar 25, 2016 at 4:23 AM, Jerico Revote <span dir="ltr"><<a href="mailto:jerico.revote@monash.edu" target="_blank">jerico.revote@monash.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes, first, when creating a new cluster, it get stuck on "validating",<div>then tried deleting it but get stuck again on "deleting",</div><div>and seeing that SQL error.</div><div>Will submit a bug @ Launchpad.</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On 25 March 2016 at 01:56, Mike Bayer <span dir="ltr"><<a href="mailto:mbayer@redhat.com" target="_blank">mbayer@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Id recommend filing a bug in Launchpad against Sahara for that. Can you reproduce it ?<div><div><br>
<br>
<br>
<br>
On 03/23/2016 07:10 PM, Jerico Revote wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
Hello,<br>
<br>
When trying to delete a cluster in sahara,<br>
I'm getting the following error:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
code 500 and message 'Internal Server Error'<br>
2016-03-23 17:25:<a href="tel:21.651%2018827" value="+12165118827" target="_blank">21.651 18827</a> ERROR sahara.utils.api<br>
[req-d797bbc8-7932-4187-a428-565f9d834f8b ] Traceback (most recent<br>
call last):<br>
OperationalError: (pymysql.err.OperationalError) (2014, 'Command Out<br>
of Sync')<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
[req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] DB exception wrapped.<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
Traceback (most recent call last):<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
line 1139, in _execute_context<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
context)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",<br>
line 450, in do_execute<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
cursor.execute(statement, parameters)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 132,<br>
in execute<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
result = self._query(query)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 271,<br>
in _query<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
conn.query(q)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
726, in query<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
self._affected_rows = self._read_query_result(unbuffered=unbuffered)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
861, in _read_query_result<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
result.read()<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
1064, in read<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
first_packet = self.connection._read_packet()<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
825, in _read_packet<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
packet = packet_type(self)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
242, in __init__<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
self._recv_packet(connection)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
248, in _recv_packet<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
packet_header = connection._read_bytes(4)<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line<br>
839, in _read_bytes<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
if len(data) < num_bytes:<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
TypeError: object of type 'NoneType' has no len()<br>
2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters<br>
2016-03-23 17:25:35.808 18823 ERROR sahara.utils.api<br>
[req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] Request aborted with<br>
status code 500 and message 'Internal Server Error'<br>
2016-03-23 17:25:35.809 18823 ERROR sahara.utils.api<br>
[req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] Traceback (most recent<br>
call last):<br>
OperationalError: (pymysql.err.OperationalError) (2014, 'Command Out<br>
of Sync')<br>
</blockquote>
<br>
Any idea what could this mean? Thanks<br>
As a result, sahara clusters are stuck in "Deleting" state.<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
pkg -l | grep -i sahara<br>
ii python-sahara 1:3.0.0-0ubuntu1~cloud0<br>
all OpenStack data processing cluster as a service - library<br>
ii sahara-api 1:3.0.0-0ubuntu1~cloud0<br>
all OpenStack data processing cluster as a service - API<br>
ii sahara-common 1:3.0.0-0ubuntu1~cloud0<br>
all OpenStack data processing cluster as a service - common<br>
files<br>
</blockquote>
<br>
Regards,<br>
<br>
Jerico<br>
<br>
<br>
<br>
<br>
<br></div></div>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br>
</blockquote>
<br>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div><br></div>
</div></div><br>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><span style="font-family:arial;font-size:small">Best Regards,</span><br></div><div><span style="font-family:arial;font-size:small">Vitaly Gridnev</span><br style="font-family:arial;font-size:small"><div style="font-family:arial;font-size:small">Mirantis, Inc</div></div></div></div>
</div>