Open Stack

Yes, first, when creating a new cluster, it get stuck on "validating",
then tried deleting it but get stuck again on "deleting",
and seeing that SQL error.
Will submit a bug @ Launchpad.

On 25 March 2016 at 01:56, Mike Bayer <mbayer at redhat.com> wrote:

> Id recommend filing a bug in Launchpad against Sahara for that.  Can you
> reproduce it ?
>
>
>
>
> On 03/23/2016 07:10 PM, Jerico Revote wrote:
>
>> Hello,
>>
>> When trying to delete a cluster in sahara,
>> I'm getting the following error:
>>
>> code 500 and message 'Internal Server Error'
>>> 2016-03-23 17:25:21.651 18827 ERROR sahara.utils.api
>>> [req-d797bbc8-7932-4187-a428-565f9d834f8b ] Traceback (most recent
>>> call last):
>>> OperationalError: (pymysql.err.OperationalError) (2014, 'Command Out
>>> of Sync')
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>> [req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] DB exception wrapped.
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>> Traceback (most recent call last):
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
>>> line 1139, in _execute_context
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  context)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
>>> line 450, in do_execute
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  cursor.execute(statement, parameters)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 132,
>>> in execute
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  result = self._query(query)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 271,
>>> in _query
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  conn.query(q)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 726, in query
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  self._affected_rows = self._read_query_result(unbuffered=unbuffered)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 861, in _read_query_result
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  result.read()
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 1064, in read
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  first_packet = self.connection._read_packet()
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 825, in _read_packet
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  packet = packet_type(self)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 242, in __init__
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  self._recv_packet(connection)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 248, in _recv_packet
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  packet_header = connection._read_bytes(4)
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line
>>> 839, in _read_bytes
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>>  if len(data) < num_bytes:
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>> TypeError: object of type 'NoneType' has no len()
>>> 2016-03-23 17:25:35.803 18823 ERROR oslo_db.sqlalchemy.exc_filters
>>> 2016-03-23 17:25:35.808 18823 ERROR sahara.utils.api
>>> [req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] Request aborted with
>>> status code 500 and message 'Internal Server Error'
>>> 2016-03-23 17:25:35.809 18823 ERROR sahara.utils.api
>>> [req-377ef364-f2c7-4343-b32c-3741bfc0a05b ] Traceback (most recent
>>> call last):
>>> OperationalError: (pymysql.err.OperationalError) (2014, 'Command Out
>>> of Sync')
>>>
>>
>> Any idea what could this mean? Thanks
>> As a result, sahara clusters are stuck in "Deleting" state.
>>
>> pkg -l | grep -i sahara
>>> ii  python-sahara                    1:3.0.0-0ubuntu1~cloud0
>>>     all          OpenStack data processing cluster as a service - library
>>> ii sahara-api                       1:3.0.0-0ubuntu1~cloud0
>>>   all          OpenStack data processing cluster as a service - API
>>> ii sahara-common                    1:3.0.0-0ubuntu1~cloud0
>>>   all          OpenStack data processing cluster as a service - common
>>> files
>>>
>>
>> Regards,
>>
>> Jerico
>>
>>
>>
>>
>>
>> __________________________________________________________________________
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe:
>> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>
>>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160325/249dca8d/attachment.html>