Uploaded image for project: 'Virtual Function Controller'
  1. Virtual Function Controller
  2. VFC-1402

Lost connection to MySQL server during query in vnflcm

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: El Alto Release
    • Fix Version/s: El Alto Release
    • Labels:
    • Environment:

      Integration Lab --> VF-C tenant

      Description

      Lost connection to MySQL server during query in vnflcm, you can get the detail info from runtime_lcm.log

       

      2019-05-28 11:21:38|||||lcm.nf.biz.instantiate_vnf||139678408735504||run||ERROR||Traceback (most recent call last):
      File "./lcm/nf/biz/instantiate_vnf.py", line 66, in run
      self.inst_pre()
      File "./lcm/nf/biz/instantiate_vnf.py", line 104, in inst_pre
      if not vnf_insts.exists():
      File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line 670, in exists
      return self.query.has_results(using=self.db)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py", line 517, in has_results
      return compiler.has_results()
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 858, in has_results
      return bool(self.execute_sql(SINGLE))
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 876, in execute_sql
      sql, params = self.as_sql()
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 441, in as_sql
      where, w_params = self.compile(self.where) if self.where is not None else ("", [])
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 373, in compile
      sql, params = node.as_sql(self, self.connection)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/where.py", line 79, in as_sql
      sql, params = compiler.compile(child)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 373, in compile
      sql, params = node.as_sql(self, self.connection)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/lookups.py", line 169, in as_sql
      lhs_sql, params = self.process_lhs(compiler, connection)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/lookups.py", line 162, in process_lhs
      db_type = self.lhs.output_field.db_type(connection=connection)
      File "/usr/local/lib/python2.7/site-packages/django/db/models/fields/_init_.py", line 644, in db_type
      return connection.data_types[self.get_internal_type()] % data
      File "/usr/local/lib/python2.7/site-packages/django/utils/functional.py", line 35, in _get_
      res = instance._dict_[self.name] = self.func(instance)
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 174, in data_types
      if self.features.supports_microsecond_precision:
      File "/usr/local/lib/python2.7/site-packages/django/utils/functional.py", line 35, in _get_
      res = instance._dict_[self.name] = self.func(instance)
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/features.py", line 53, in supports_microsecond_precision
      return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)
      File "/usr/local/lib/python2.7/site-packages/django/utils/functional.py", line 35, in _get_
      res = instance._dict_[self.name] = self.func(instance)
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 385, in mysql_version
      with self.temporary_connection() as cursor:
      File "/usr/local/lib/python2.7/contextlib.py", line 17, in _enter_
      return self.gen.next()
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 591, in temporary_connection
      cursor = self.cursor()
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 254, in cursor
      return self._cursor()
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 229, in _cursor
      self.ensure_connection()
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
      self.connect()
      File "/usr/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in _exit_
      six.reraise(dj_exc_type, dj_exc_value, traceback)
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
      self.connect()
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 189, in connect
      self.connection = self.get_new_connection(conn_params)
      File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 274, in get_new_connection
      conn = Database.connect(**conn_params)
      File "/usr/local/lib/python2.7/site-packages/pymysql/_init_.py", line 94, in Connect
      return Connection(*args, **kwargs)
      File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 325, in _init_
      self.connect()
      File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 599, in connect
      self._request_authentication()
      File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 861, in _request_authentication
      auth_packet = self._read_packet()
      File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 657, in _read_packet
      packet_header = self._read_bytes(4)
      File "/usr/local/lib/python2.7/site-packages/pymysql/connections.py", line 707, in _read_bytes
      CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
      OperationalError: (2013, 'Lost connection to MySQL server during query')

        Attachments

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

              People

              • Assignee:
                yangyan Yan Yang
                Reporter:
                haibin Huang Haibin
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: