-- The nuclear option:
TRUNCATE TABLE maasserver_event;
-- A slightly nicer option:
ALTER TABLE maasserver_event DISABLE TRIGGER maasserver_event_event_delete_notify;
DELETE FROM maasserver_event WHERE id < 6000000;
ALTER TABLE maasserver_event ENABLE TRIGGER maasserver_event_event_delete_notify;
I'm not sure we actually want this trigger to be there; it's
automatically created to keep the UI up to date. For the event log I
think we could dispense with tracking DELETE.
A couple of workarounds:
-- The nuclear option:
TRUNCATE TABLE maasserver_event;
-- A slightly nicer option: event_event_ delete_ notify; event_event_ delete_ notify;
ALTER TABLE maasserver_event DISABLE TRIGGER maasserver_
DELETE FROM maasserver_event WHERE id < 6000000;
ALTER TABLE maasserver_event ENABLE TRIGGER maasserver_
I'm not sure we actually want this trigger to be there; it's
automatically created to keep the UI up to date. For the event log I
think we could dispense with tracking DELETE.