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.rev...@monash.edu
<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 <mba...@redhat.com
    <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 <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-requ...@lists.openstack.org?subject:unsubscribe 
<http://openstack-dev-requ...@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-requ...@lists.openstack.org?subject:unsubscribe
        <http://openstack-dev-requ...@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-requ...@lists.openstack.org?subject:unsubscribe
    <http://openstack-dev-requ...@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-requ...@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-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to