Fill in the gaps in the activity log using data from bug notifications

Bug #253242 reported by Gavin Panella
4
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Low
Unassigned

Bug Description

Our future goal is for BugActivity to have a complete historical log of bug changes, so that BugNotification can be trimmed from time to time. Currently it is not trimmed because it is sometimes useful as a secondary activity log, often with more information than BugActivity.

Before trimming BugNotification for the first time, we should see if we can add to the (currently, sparse) information in BugActivity by parsing non-comment notifications as referenced by BugNotification.

Graham Binns (gmb)
Changed in malone:
importance: Undecided → Wishlist
status: New → Confirmed
Revision history for this message
Stuart Bishop (stub) wrote :

A fix that will prune BugNotification has been approved and is being landed.

If this bug is still an issue, we should improve this work to move records to an archive table rather than delete. Otherwise, flag this wont fix. We currently have 3.8 million BugNotification and 48.8 million BugNotificationRecipient records.

Revision history for this message
Stuart Bishop (stub) wrote :

Bug #407288 is the bug tracking the pruning.

Revision history for this message
Robert Collins (lifeless) wrote :

We have trimmed, so this was either done or forgotten.

Changed in launchpad:
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.