openstack rocky version, neutron is throwing the following error : ovs|00002|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Manager\" table to have identi

Bug #1943112 reported by cheparthi midula
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Undecided
Unassigned

Bug Description

i am using the openstack rocky version, the neutron is throwing the error when command is executed -
 " systemctl status neutron-openvswitch-agent "

the error is as follows:

Sep 07 09:48:38 compute-I ovs-vsctl[5369]: ovs|00002|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Manager\" table to have identi

Revision history for this message
Lajos Katona (lajos-katona) wrote :

Could You check please the logs of neutron-openvswitch-agent if there's a traceback or more details?
By the truncated line of log I found this old bugzilla ticket:
https://access.redhat.com/solutions/3224831 , not sure if it is similar to your case

Changed in neutron:
status: New → Incomplete
Revision history for this message
cheparthi midula (midula) wrote :
Download full text (3.7 KiB)

the openvswitch_agent.log file has the following entries :

===============================================================================================
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent [-] Failed reporting state!: MessagingTimeout: Timed out waiting for a reply to message ID 22ff019086fb4dc385c54007f4ec2b74
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent Traceback (most recent call last):
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/local/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/openvswitch/agent/ovs_neutron_agent.py", line 325, in _report_state
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent True)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/local/lib/python2.7/dist-packages/neutron/agent/rpc.py", line 97, in report_state
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent return method(context, 'report_state', **kwargs)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/rpc/client.py", line 179, in call
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent retry=self.retry)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/transport.py", line 133, in _send
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent retry=retry)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 584, in send
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent call_monitor_timeout, retry=retry)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 573, in _send
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent call_monitor_timeout)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 459, in wait
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent message = self.waiters.get(msg_id, timeout=timeout)
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent File "/usr/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 336, in get
2021-09-09 17:21:29.019 20788 ERROR neutron.plugins.ml2.drivers.openvswitch.agent.ovs_neutron_agent 'to message ID %s' % msg_id)
2021-09-09 17:2...

Read more...

Revision history for this message
cheparthi midula (midula) wrote :
Download full text (3.5 KiB)

the bugzilla ticket you have provided doesn't seem to provide a fix to the issue, does it?

although my error is similar to what is shown in the link you provided, so i have tried to restart neutron but the issue is not resolved.

==============================================================================================
root@controller:/etc/neutron# journalctl -u neutron-openvswitch-agent -f
-- Logs begin at Mon 2021-07-05 17:48:05 IST. --
Sep 09 14:08:28 controller ovs-vsctl[20957]: ovs|00001|vsctl|INFO|Called as /usr/bin/ovs-vsctl --timeout=5 --id=@manager -- create Manager "target=\"ptcp:6640:127.0.0.1\"" -- add Open_vSwitch . manager_options @manager
Sep 09 14:08:28 controller ovs-vsctl[20957]: ovs|00002|ovsdb_idl|WARN|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 dd5aace9-e7b8-4c78-865e-353df69b6286, was inserted by this transaction. Second row, with UUID cb7a5e48-4ebc-4de4-9289-36aab899abaa, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}
Sep 09 14:08:28 controller ovs-vsctl[20957]: 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 dd5aace9-e7b8-4c78-865e-353df69b6286, was inserted by this transaction. Second row, with UUID cb7a5e48-4ebc-4de4-9289-36aab899abaa, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}
Sep 09 14:08:28 controller sudo[20948]: pam_unix(sudo:session): session closed for user root
Sep 09 14:08:28 controller sudo[20960]: neutron : TTY=unknown ; PWD=/var/lib/neutron ; USER=root ; COMMAND=/usr/bin/neutron-rootwrap /etc/neutron/rootwrap.conf ovs-vsctl --timeout=5 --id=@manager -- create Manager target="ptcp:6640:127.0.0.1" -- add Open_vSwitch . manager_options @manager
Sep 09 14:08:28 controller sudo[20960]: pam_unix(sudo:session): session opened for user root by (uid=0)
Sep 09 14:08:28 controller ovs-vsctl[20963]: ovs|00001|vsctl|INFO|Called as /usr/bin/ovs-vsctl --timeout=5 --id=@manager -- create Manager "target=\"ptcp:6640:127.0.0.1\"" -- add Open_vSwitch . manager_options @manager
Sep 09 14:08:28 controller ovs-vsctl[20963]: ovs|00002|ovsdb_idl|WARN|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 cb7a5e48-4ebc-4de4-9289-36aab899abaa, existed in the database before this transaction and was not modified by the transaction. Second row, with UUID e43c5cbc-6a91-4384-9acd-6751d6fec9e4, was inserted by this transaction.","error":"constraint violation"}
Sep 09 14:08:28 controller ovs-vsctl[20963]: 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 cb7a5e48-4ebc-4de4-...

Read more...

Revision history for this message
Lajos Katona (lajos-katona) wrote :

Question are You able to manually execute the ovs-vsctl commands, like:
/usr/bin/ovs-vsctl --timeout=5 --id=@manager -- create Manager "target=\"ptcp:6640:127.0.0.1\"" -- add Open_vSwitch . manager_options @manager ?

Revision history for this message
cheparthi midula (midula) wrote :

i am able to,
but now there is a error with my neutron service is not working in compute4 node
it is displaying the following error when i try to do
systemctl status neutron-* :

Unit neutron-openvswitch-agent.log.service could not be found.
Unit neutron-openvswitch-agent.log.1.service could not be found.
Unit neutron-openvswitch-agent.log.2.gz.service could not be found.
Unit neutron-openvswitch-agent.log.3.gz.service could not be found.
Unit neutron-openvswitch-agent.log.4.gz.service could not be found.
Unit neutron-ovs-cleanup.log.service could not be found.
Unit neutron-ovs-cleanup.log.1.service could not be found.
Unit neutron-ovs-cleanup.log.2.gz.service could not be found.
Unit neutron-ovs-cleanup.log.3.gz.service could not be found.
Unit neutron-ovs-cleanup.log.4.gz.service could not be found.

Revision history for this message
cheparthi midula (midula) wrote :

any suggestions would be much appreciated. thank you

Revision history for this message
Lajos Katona (lajos-katona) wrote :

Did you try to restart the related services on the host?
As this issue seems more a support request or deployment issue, I mark this bug invalid.

Changed in neutron:
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers