Re: [openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error

2016-03-25 Thread Mike Bayer
and on the subject of"more folks reading this message", here's that 
bug report!   https://bugs.launchpad.net/sahara/+bug/1561807




On 03/25/2016 12:42 AM, Vitaly Gridnev wrote:

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 mailto:jerico.rev...@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 mailto:mba...@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 = pa

Re: [openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error

2016-03-24 Thread Vitaly Gridnev
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 
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  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.Opera

Re: [openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error

2016-03-24 Thread Jerico Revote
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  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-sahara1:3.0.0-0ubuntu1~cloud0
>>> all  OpenStack data processing cluster as a service - library
>>> ii sahara-api   1:3.0.0-0ubuntu1~cloud0
>

Re: [openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error

2016-03-24 Thread Mike Bayer
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-sahara1: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-common1: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-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev



__
Open

[openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error

2016-03-23 Thread Jerico Revote
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-sahara1: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-common1: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-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.or