There is no way to clear the event log for a Node
Bug #1403080 reported by
Graham Binns
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MAAS |
Invalid
|
Wishlist
|
Unassigned | ||
maas-ui |
Fix Released
|
Unknown
|
Bug Description
See bug 1402237. It's possible for a Node to have tens of thousands of event log entries, but there's no way for a user to dispose of them should they no longer be needed.
tags: | added: oil |
Changed in maas: | |
milestone: | none → next |
Changed in maas: | |
status: | Invalid → Triaged |
importance: | Medium → High |
no longer affects: | maas-ui |
Changed in maas-ui: | |
status: | Unknown → New |
Changed in maas-ui: | |
status: | New → Fix Released |
To post a comment you must log in.
These days, even trying to delete them with a manual SQL statement doesn't work. I tried this query, let it run for 90 minutes and then gave up:
maasdb=# delete from maasserver_event where id < 6000000; 'event_ delete' ,CAST(OLD. id AS text))" notify( ) line 4 at PERFORM
^CCancel request sent
ERROR: canceling statement due to user request
CONTEXT: SQL statement "SELECT pg_notify(
PL/pgSQL function event_delete_
It takes about 20 seconds to delete 50k records.