You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It would be great to allow superusers to view the table and optimally to truncate it by date via the admin dashboard, or helpful to allow a superuser to export the table and truncate it via API.
As of this morning, our DB's actionlogrecord table holds 7,821,589 entries. Of those, 7,512,823 contain useridentifier :guest.
Some of these are successes (like CreateGuestbookResponseCommand, the results of which in theory appear in guestbookresponse) but others (3,545,322) are PermissionError from bots denied their naughty endeavors.
If, and this is a big if, the actionlogrecord table's :guest entries aren't entirely useful on their own merit, this feature request might be simplified by the addition of a :DontLogGuestActions or some such DB setting.
Overview of the Feature Request
Currently, the Admin Guide recommends that the
actionlogrecord
be regularly purged: https://guides.dataverse.org/en/latest/admin/troubleshooting.html#what-s-with-this-table-actionlogrecord-in-our-database-it-seems-to-be-growing-uncontrollablyIt would be great to allow superusers to view the table and optimally to truncate it by date via the admin dashboard, or helpful to allow a superuser to export the table and truncate it via API.
What kind of user is the feature intended for?
API user, Archivist, Admin
What inspired the request?
https://guides.dataverse.org/en/latest/admin/troubleshooting.html#what-s-with-this-table-actionlogrecord-in-our-database-it-seems-to-be-growing-uncontrollably
What existing behavior do you want changed?
https://guides.dataverse.org/en/latest/admin/troubleshooting.html#what-s-with-this-table-actionlogrecord-in-our-database-it-seems-to-be-growing-uncontrollably
Any brand new behavior do you want to add to Dataverse?
These two(?) API endpoints and potentially a page in the admin dashboard.
Any related open or closed issues to this feature request?
#9356 mentioned the condition, and prompted this issue.
The text was updated successfully, but these errors were encountered: