Neutron openvswitch agent error

[YG Kumar]

Hi All,

I have a rocky openstack ansible setup. One of the compute nodes shows the following error in the neutron-openvswitch service:

-----------------------
Mar 19 07:47:45 b2a-1 ovs-vsctl[4897]: ovs|00003|db_ctl_base|ERR|transaction error: {"details":"Transaction causes multiple rows in \"Manager\" table to have identical values (\"ptcp:6640:127.0.0.1\") for index on column \"target\". First row, with UUID 4c7080b5-d201-4629-a30d-78277a6711b2, existed in the database before this transaction and was not modified by the transaction. Second row, with UUID 81b20bb3-2562-4df5-a975-5e7f0296c2f9, was inserted by this transaction.","error":"constraint violation"}
---------------------

The above service is in error state. I have tried removing the ovs packages and rebooted the compute node and reran the neutron playbook. But still the same.

Can someone help me with this issue please ?

Thanks
Kumar

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Hello Kumar:

What deployment tool are you using?

According to [1] this happens when you try to execute two OVS agents. Did you check the managers connected:
$ ovs-vsctl list Manager

BTW, apart from the possible problem of having two OVS agents running in the same node (something should never happen), this error message is harmless.

Regards.

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1506035

[YG Kumar (ygk-kmr)]

Hi,

I see this:
-----------------
root@b2a-1:~# ovs-vsctl list Manager
_uuid : 4c7080b5-d201-4629-a30d-78277a6711b2
connection_mode : []
external_ids : {}
inactivity_probe : []
is_connected : true
max_backoff : []
other_config : {}
status : {bound_port="6640", n_connections="4", sec_since_connect="0", sec_since_disconnect="0"}
target : "ptcp:6640:127.0.0.1"
--------------------

I am using openstack ansible on ubuntu 18.04. There are two compute nodes. One is working fine. The other one is showing this error.

[YG Kumar (ygk-kmr)]

Also, I see a nova error when I try to launch a vm on this compute node:

--------------
2020-03-19 10:32:02.210 6193 ERROR nova.compute.manager [req-5c035446-b647-4298-a460-d7fb604b547d - - - - -] Error updating resources for node b2a-1.: ResourceProviderRetrievalFailed: Failed to get resource provider with UUID ea3af0ff-fb69-449a-b484-5ac722010a1f

2020-03-19 10:32:02.210 6193 ERROR nova.compute.manager ResourceProviderRetrievalFailed: Failed to get resource provider with UUID ea3af0ff-fb69-449a-b484-5ac722010a1f
------------

I cant make out if these neutron and nova errors are related and that whether solving the above ovs error will solve the above nova-compute error.

[Slawek Kaplonski (slaweq)]

I don't think that those 2 issues are somehow related to each other.
To continue investigation on this OVS issue, can You also check if You don't have any other neutron-ovs-agent process already running on the node? Or maybe You have any other process which is running as this manager for ovs?

For now I'm marking this issue as incomplete as for me it doesn't looks like neutron issue so far. But feel free to change state of this issue if You will have additional data about Neutron issue.

[YG Kumar (ygk-kmr)]

I have deleted the manager and restarted the ovs agent. But still its showing the same error in the service status:

--------------
Mar 20 01:32:59 b2a-1 ovs-vsctl[29778]: ovs|00003|db_ctl_base|ERR|transaction error: {"details":"Transaction causes multiple rows in \"Manager\" table to have identical values (\"ptcp:6640:127.0.0.1\") for index on column \"target\". First row, with UUID 7daef0d7-05db-43ff-9ec7-e9737a13b475, was inserted by this transaction. Second row, with UUID 87a568f9-be4e-43b7-9303-792fcc4ff0c9, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}
---------------------

[light_issa (isares)]

Hello,

having the same issue ?

did you resolve the problem ?

Thanks

ERROR neutron.agent.ovsdb.impl_vsctl [req-47ab3697-fda6-4777-93c9-ae971644e2c8 - - - - -] Unable to execute ['ovs-vsctl', '--timeout=10', '--oneline', '--format=json', '--', '--id=@man
ager', 'create', 'Manager', 'target="ptcp:6640:127.0.0.1"', '--', 'add', 'Open_vSwitch', '.', 'manager_options', '@manager']. Exception: Exit code: 1; Stdin: ; Stdout: ; Stderr: ovs-vsctl: transaction error: {"d
etails":"Transaction causes multiple rows in \"Manager\" table to have identical values (\"ptcp:6640:127.0.0.1\") for index on column \"target\". First row, with UUID 4fb71291-1b44-4956-8cdb-2a1e9a355de8, exist
ed in the database before this transaction and was not modified by the transaction. Second row, with UUID 360d5c1b-b951-408c-bda5-68726d0a3176, was inserted by this transaction.","error":"constraint violation"}