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 <[email protected]> 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: >> [email protected]?subject:unsubscribe >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >> >> > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: [email protected]?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
