Open Stack

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.

Let's continue discussions about the bug in launchpad.

On Fri, Mar 25, 2016 at 4:23 AM, Jerico Revote <jerico.revote at monash.edu>
wrote:

> 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
>>
>
>
> __________________________________________________________________________
> 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
>
>


-- 
Best Regards,
Vitaly Gridnev
Mirantis, Inc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160325/5a357868/attachment.html>