Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-31850

SQuaSH DB disconnection errors (pymysql.err.InterfaceError)

    XMLWordPrintable

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      I'm seeing pymysql.err.InterfaceError) errors in the SQuaSH API after the update done for DM-31131

      [2021-09-20 16:11:05,515] ERROR in app: Exception on /auth [POST]
      Traceback (most recent call last):
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1772, in _execute_context
          cursor, statement, parameters, context
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
          cursor.execute(statement, parameters)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 148, in execute
          result = self._query(query)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 310, in _query
          conn.query(q)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 548, in query
          self._affected_rows = self._read_query_result(unbuffered=unbuffered)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 775, in _read_query_result
          result.read()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1156, in read
          first_packet = self.connection._read_packet()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 707, in _read_packet
          % (packet_number, self._next_seq_id)
      pymysql.err.InternalError: Packet sequence number wrong - got 55 expected 1
      

      and

      [2021-09-20 16:11:05,515] ERROR in app: Exception on /job [POST]
      Traceback (most recent call last):
        File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1513, in full_dispatch_request
          rv = self.dispatch_request()
        File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1499, in dispatch_request
          return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
        File "/usr/local/lib/python3.6/site-packages/flask_restful/__init__.py", line 467, in wrapper
          resp = resource(*args, **kwargs)
        File "/usr/local/lib/python3.6/site-packages/flask/views.py", line 83, in view
          return self.dispatch_request(*args, **kwargs)
        File "/usr/local/lib/python3.6/site-packages/flask_restful/__init__.py", line 582, in dispatch_request
          resp = meth(*args, **kwargs)
        File "/usr/local/lib/python3.6/site-packages/flask_jwt/__init__.py", line 177, in decorator
          return fn(*args, **kwargs)
        File "./app/api_v1/job.py", line 155, in post
          self.insert_measurements(job_id)
        File "./app/decorators.py", line 11, in wrapper
          result = func(*args)
        File "./app/api_v1/job.py", line 301, in insert_measurements
          metric = MetricModel.find_by_name(metric_name)
        File "./app/models.py", line 117, in find_by_name
          return cls.query.filter_by(name=name).first()
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2762, in first
          return self.limit(1)._iter().first()
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2849, in _iter
          execution_options={"_sa_orm_load_options": self.load_options},
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
          result = conn._execute_20(statement, params or {}, execution_options)
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1583, in _execute_20
          return meth(self, args_10style, kwargs_10style, execution_options)
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
          self, multiparams, params, execution_options
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1462, in _execute_clauseelement
          cache_hit=cache_hit,
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1815, in _execute_context
          e, statement, parameters, cursor, context
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1999, in _handle_dbapi_exception
          util.raise_(exc_info[1], with_traceback=exc_info[2])
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
          raise exception
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1772, in _execute_context
          cursor, statement, parameters, context
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
          cursor.execute(statement, parameters)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 148, in execute
          result = self._query(query)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 310, in _query
          conn.query(q)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 548, in query
          self._affected_rows = self._read_query_result(unbuffered=unbuffered)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 775, in _read_query_result
          result.read()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1163, in read
          self._read_result_packet(first_packet)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1236, in _read_result_packet
          self._read_rowdata_packet()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1274, in _read_rowdata_packet
          rows.append(self._read_row_from_packet(packet))
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1294, in _read_row_from_packet
          data = converter(data)
      ValueError: invalid literal for int() with base 10: '11e'
      Traceback (most recent call last):
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 958, in _rollback_impl
          self.engine.dialect.do_rollback(self.connection)
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 667, in do_rollback
      Traceback (most recent call last):
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 958, in _rollback_impl
          dbapi_connection.rollback()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 479, in rollback
          self.engine.dialect.do_rollback(self.connection)
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 667, in do_rollback
          self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 793, in _execute_command
          raise err.InterfaceError(0, "")
          dbapi_connection.rollback()
      pymysql.err.InterfaceError: (0, '')
      

        Attachments

          Issue Links

            Activity

            There are no comments yet on this issue.

              People

              Assignee:
              afausti Angelo Fausti
              Reporter:
              afausti Angelo Fausti
              Watchers:
              Angelo Fausti
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.