Unable to delete node after upgrade to Horizon 24

#1

Hi everybody,

we just did an upgrade from Horizon 23 to 24. We tried to delete a node, but even after a reboot the node won’t be deleted.

Actual the node has a log entry “A request has been made to delete a node with interface: .” and in the requisition there’re 80 nodes defined und 81 in the database.

Is it possible that the vaccumd is no running, how can i force the daemon to delete the node finally?

Thank you very much!

#2

This is a bug caused by a reference in the database that doesn’t get deleted when deleting nodes.

1 Like
#3

Hi,

is there a workaround, which i can apply manually? When will 24.0.1 be released?

Thx!

#4

Access the database, usually:

psql -U opennms opennms

then

ALTER TABLE ipNetToMedia DROP CONSTRAINT fk_ipnettomedia_nodeid, ADD CONSTRAINT fk_ipnettomedia_nodeid FOREIGN KEY (nodeid) REFERENCES node (nodeid) ON DELETE CASCADE;

and

ALTER TABLE ipNetToMedia DROP CONSTRAINT fk_ipnettomedia_sourcenodeid, ADD CONSTRAINT fk_ipnettomedia_sourcenodeid FOREIGN KEY (sourcenodeid) REFERENCES node (nodeid) ON DELETE CASCADE;
1 Like
#5

Hi,

seems to be working, thx!