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

Mike Bayer mbayer at redhat.com
Thu Mar 24 14:56:03 UTC 2016


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
>



More information about the OpenStack-dev mailing list