[Bug 1998617] [NEW] Add route with --bfd, delete it and add it again leads to transaction error

[Frode Nordahl]

Public bug reported:

$ sudo ovn-nbctl --bfd \
    lr-route-add 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4 10.78.95.13 \
    lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0
$ sudo ovn-nbctl lr-route-del 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4
$ sudo ovn-nbctl --bfd \
    lr-route-add 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4 10.78.95.13 \
    lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0
2022-12-02T16:04:19Z|00002|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"BFD\" table to have identical values (lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0 and \"10.78.95.13\") for index on columns \"logical_port\" and \"dst_ip\".  First row, with UUID 051b51cb-53bf-4180-96ac-df6b1a132a3f, existed in the database before this transaction and was not modified by the transaction.  Second row, with UUID e3afd014-4ab5-4ed9-994f-ce28ff66366e, was inserted by this transaction.","error":"constraint violation"}
ovn-nbctl: transaction error: {"details":"Transaction causes multiple rows in \"BFD\" table to have identical values (lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0 and \"10.78.95.13\") for index on columns \"logical_port\" and \"dst_ip\".  First row, with UUID 051b51cb-53bf-4180-96ac-df6b1a132a3f, existed in the database before this transaction and was not modified by the transaction.  Second row, with UUID e3afd014-4ab5-4ed9-994f-ce28ff66366e, was inserted by this transaction.","error":"constraint violation"}

The root cause of this appears to be that deleting a route does not also
clear up the corresponding BFD entry.

** Affects: ovn (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to ovn in Ubuntu.
https://bugs.launchpad.net/bugs/1998617

Title:
  Add route with --bfd, delete it and add it again leads to transaction
  error

Status in ovn package in Ubuntu:
  New

Bug description:
  $ sudo ovn-nbctl --bfd \
      lr-route-add 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4 10.78.95.13 \
      lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0
  $ sudo ovn-nbctl lr-route-del 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4
  $ sudo ovn-nbctl --bfd \
      lr-route-add 053a9b2e-cebe-4972-a44c-5596b9dd34b4 1.2.3.4 10.78.95.13 \
      lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0
  2022-12-02T16:04:19Z|00002|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"BFD\" table to have identical values (lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0 and \"10.78.95.13\") for index on columns \"logical_port\" and \"dst_ip\".  First row, with UUID 051b51cb-53bf-4180-96ac-df6b1a132a3f, existed in the database before this transaction and was not modified by the transaction.  Second row, with UUID e3afd014-4ab5-4ed9-994f-ce28ff66366e, was inserted by this transaction.","error":"constraint violation"}
  ovn-nbctl: transaction error: {"details":"Transaction causes multiple rows in \"BFD\" table to have identical values (lrp-0ae8c991-968e-4ae3-9ff8-9cc34383cfe0 and \"10.78.95.13\") for index on columns \"logical_port\" and \"dst_ip\".  First row, with UUID 051b51cb-53bf-4180-96ac-df6b1a132a3f, existed in the database before this transaction and was not modified by the transaction.  Second row, with UUID e3afd014-4ab5-4ed9-994f-ce28ff66366e, was inserted by this transaction.","error":"constraint violation"}

  The root cause of this appears to be that deleting a route does not
  also clear up the corresponding BFD entry.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/ovn/+bug/1998617/+subscriptions