Ticket #111 (closed Feature Request: fixed)

Opened 14 years ago

Last modified 12 years ago

Add a mechanism for completely deleting a node

Reported by: max-horvath Owned by:
Priority: normal Milestone: WifiDog Auth Server 1.1
Component: Auth server, Other Version: Auth Server SVN
Keywords: administration, database error Cc:

Description (last modified by benoitg) (diff)

While seldom needed (setting a node PERMANENTLY_CLOSED is generally preferable), deleting a node including all connections ever to take place there is sometimes usefull, for example when the node was never put in production.

This requires changing the SQL constraints and implementing the delete function with a "Big Fat Warning (tm)"


A node cannot be deleted, even after every content and owner and tech officers have been removed ...

Following error occurs:

DELETE FROM nodes WHERE node_id='0014BFC92DDB'
Error: 
ERROR: update or delete on "nodes" violates foreign key constraint "node_stakeholders_node_id_fkey" on "node_stakeholders" DETAIL: Key (node_id)=(0014BFC92DDB) is still referenced from table "node_stakeholders".

Change History

Changed 14 years ago by fproulx

I tried here on my database (which is a dump of ISF database) I removed a stakeholder and I'm getting the foreign key error for connection stats but not on "node_stakeholders". I guess we might add a checkbox like ("I understand that this will drop all nodes statistics etc...")

Changed 14 years ago by max-horvath

  • keywords administration, database error added; administration removed

Well, a owner (stakeholder) can't delete a node, anyway (I added this a few weeks ago as this is a task for an administrator, ONLY).

So I don't think we'd need a fancy checkbox. A network admin knows, why he's going to delete a node and what's going to happen.

Anyway ... as I'm not so much into Postgres I'd be very happy if you could add a constrain or whatever is needed so that I as an administrator can delete a node within WiFiDog and not via Postgres command line ;) ...

Changed 14 years ago by fproulx

  • owner fproulx deleted

Changed 14 years ago by benoitg

  • priority changed from high to normal
  • type changed from Bug report to Feature Request
  • description modified (diff)
  • summary changed from Node cannot be deleted to Add a mechanism for completely deleting a node

Changed 14 years ago by benoitg

  • milestone changed from WifiDog Auth Server 1.0 to WifiDog Auth Server 1.1

Changed 13 years ago by benoitg

  • status changed from new to closed
  • resolution set to fixed

This has been fixed (accidentally, but still) many revisions back.

Note: See TracTickets for help on using tickets.