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


-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to