yahoo-eng-team team mailing list archive

["Dr. Jens Harbott" <2116186@xxxxxxxxxxxxxxxxxx>]

some neutron API calls are also affected, cf. https://review.opendev.org/c/openstack/devstack/+/954653
like "openstack subnet list" gives an API failure, while "openstack network list" works without issues

** Also 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/2116186

Title:
  Py3.13: nova-conductor crash during report status

Status in neutron:
  New
Status in OpenStack Compute (nova):
  New

Bug description:
  Hi,

  When running nova-conductor from Epoxy under Debian Trixie (meaning
  Python 3.13), I get the below traceback. Not sure what's going on.
  Here's the traceback from the nova-conductor.log:

   [-] Unexpected error while reporting service status: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1020, "Record has changed since last read in table 'services'")
  [SQL: UPDATE services SET report_count=%(report_count)s, last_seen_up=%(last_seen_up)s, updated_at=%(updated_at)s WHERE services.id = %(services_id)s]
  [parameters: {'report_count': 61664, 'last_seen_up': datetime.datetime(2025, 7, 8, 13, 43, 16, 904402), 'updated_at': datetime.datetime(2025, 7, 8, 13, 43, 16, 904641), 'services_id': 6}]
  (Background on this error at: https://sqlalche.me/e/20/e3q8)
   Traceback (most recent call last):
     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
       self.dialect.do_execute(
       ~~~~~~~~~~~~~~~~~~~~~~~^
           cursor, str_statement, effective_parameters, context
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
       )
       ^
     File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 945, in do_execute
       cursor.execute(statement, parameters)
       ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 153, in execute
       result = self._query(query)
     File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 322, in _query
       conn.query(q)
       ~~~~~~~~~~^^^
     File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 563, in query
       self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                             ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 825, in _read_query_result
       result.read()
       ~~~~~~~~~~~^^
     File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1199, in read
       first_packet = self.connection._read_packet()
     File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 775, in _read_packet
       packet.raise_for_error()
       ~~~~~~~~~~~~~~~~~~~~~~^^
     File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 219, in raise_for_error
       err.raise_mysql_exception(self._data)
       ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
     File "/usr/lib/python3/dist-packages/pymysql/err.py", line 150, in raise_mysql_exception
       raise errorclass(errno, errval)
   pymysql.err.OperationalError: (1020, "Record has changed since last read in table 'services'")

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