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

Jerico Revote jerico.revote at monash.edu
Wed Mar 23 23:10:18 UTC 2016


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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160324/9d66bf66/attachment.html>


More information about the OpenStack-dev mailing list