+++ This bug was initially created as a clone of Bug #1948472 +++

On a 17.1.3 DCN deployment, we cannot create VMs on a DCN site and the networks agents apears UP but not alive. Seems that the bug still present in this version, the same workaround works [1].

Checking the logs on compute node there, this is neutron/ovn-metadata-agent.log:

2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command [-] Error executing command (DbAddCommand): ovsdbapp.backend.ovs_idl.idlutils.RowNotFound: Cannot find Chassis_Private with name=e61fc978-45d8-4ed0-b3c9-f0da8bf3d497
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command Traceback (most recent call last):
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/command.py", line 42, in execute
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command t.add(self)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib64/python3.9/contextlib.py", line 126, in _exit_
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command next(self.gen)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/api.py", line 110, in transaction
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command del self._nested_txns_map[cur_thread_id]
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/api.py", line 61, in _exit_
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command self.result = self.commit()
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/transaction.py", line 64, in commit
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command raise result.ex
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/connection.py", line 118, in run
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command txn.results.put(txn.do_commit())
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/transaction.py", line 92, in do_commit
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command command.run_idl(txn)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/command.py", line 172, in run_idl
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command record = self.api.lookup(self.table, self.record)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/_init_.py", line 208, in lookup
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command return self._lookup(table, record)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/_init_.py", line 268, in _lookup
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command row = idlutils.row_by_value(self, rl.table, rl.column, record)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command File "/usr/lib/python3.9/site-packages/ovsdbapp/backend/ovs_idl/idlutils.py", line 114, in row_by_value
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command raise RowNotFound(table=table, col=column, match=match)
2024-07-19 15:04:00.463 281727 ERROR ovsdbapp.backend.ovs_idl.command ovsdbapp.backend.ovs_idl.idlutils.RowNotFound: Cannot find Chassis_Private with name=e61fc978-45d8-4ed0-b3c9-f0da8bf3d497

And openvswitch/ovn-controller.log

2024-07-19T14:03:34.999Z|02788|ovsdb_idl|WARN|Dropped 12 log messages in last 60 seconds (most recently, 5 seconds ago) due to excessive rate
2024-07-19T14:03:34.999Z|02789|ovsdb_idl|WARN|transaction error:

{"details":"Transaction causes multiple rows in \"Encap\" table to have identical values (geneve and \"10.245.82.76\") for index on columns \"type\" and \"ip\". First row, with UUID f5bb8a79-08e6-41e6-901c-f1380b38b276, existed in the database before this transaction and was not modified by the transaction. Second row, with UUID 26f3fccf-fafb-421f-8299-fb7adf3a1b70, was inserted by this transaction.","error":"constraint violation"}

[1] https://access.redhat.com/solutions/6551871