yahoo-eng-team team mailing list archive

[Rodolfo Alonso <2122651@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Randomly the MySQL tests, that inherit the ``OpportunisticSqlFixture`` class, fail during the tear down process in the clean up phase. Error: [1]
"""
...
File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.12/site-packages/pymysql/connections.py", line 492, in rollback
    self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
  File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.12/site-packages/pymysql/connections.py", line 843, in _execute_command
    raise err.InterfaceError(0, "")
oslo_db.exception.DBConnectionError: (pymysql.err.InterfaceError) (0, '')
"""

Because the DB is not reusable by other test and this error doesn't mean the test failed, this bug proposes:
* To dismiss the error while the root cause of this problem is found.
* Find the root cause of the DB connection error during the table drop process.

[1]https://paste.opendev.org/show/b9KObG1HBgsB0iLc8uNe/

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2122651

Title:
  [FT] ``DBConnectionError`` exception during the
  ``OpportunisticSqlFixture`` cleanup process

Status in neutron:
  New

Bug description:
  Randomly the MySQL tests, that inherit the ``OpportunisticSqlFixture`` class, fail during the tear down process in the clean up phase. Error: [1]
  """
  ...
  File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.12/site-packages/pymysql/connections.py", line 492, in rollback
      self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
    File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.12/site-packages/pymysql/connections.py", line 843, in _execute_command
      raise err.InterfaceError(0, "")
  oslo_db.exception.DBConnectionError: (pymysql.err.InterfaceError) (0, '')
  """

  Because the DB is not reusable by other test and this error doesn't mean the test failed, this bug proposes:
  * To dismiss the error while the root cause of this problem is found.
  * Find the root cause of the DB connection error during the table drop process.

  [1]https://paste.opendev.org/show/b9KObG1HBgsB0iLc8uNe/

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2122651/+subscriptions