Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-10674

Can not delete node due to database table constraint

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 24.0.0
    • Fix Version/s: 24.1.0
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None
    • Sprint:
      Horizon 2019 - 19, Horizon 2019 - May 15th 2019

      Description

      If a node has an entry in the ipnettomedia table it can not be deleted.

      opennms=# delete from node where nodeid=114 ;
      ERROR: update or delete on table "node" violates foreign key constraint "fk_ipnettomedia_nodeid" on table "ipnettomedia"
      DETAIL: Key (nodeid)=(114) is still referenced from table "ipnettomedia".

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                j-white Jesse White
                Reporter:
                tarus Tarus Balog
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: