[openstack-dev] Deleting a cluster in Sahara SQL/PyMYSQL Error
Mike Bayer
mbayer at redhat.com
Fri Mar 25 13:46:48 UTC 2016
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 <jerico.revote at monash.edu
> <mailto: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
> <mailto: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 <tel:21.651%2018827> 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://OpenStack-dev-request@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://OpenStack-dev-request@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://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe>
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
>
> --
> Best Regards,
> Vitaly Gridnev
> Mirantis, Inc
>
>
> __________________________________________________________________________
> 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