Launchpad itself

OOPS when rendering bug activity

Bug #408738 reported by Björn Tillenius
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Stuart Bishop
Launchpad itself 3.0

Bug Description

Sometimes when rendering bug activity an OOPS is triggered. It looks like the author of the activity is None, but I don't know why that is.

OOPS-1311A2033
OOPS-1311H2745

A related OOPS: OOPS-1311H1296

See original description
Tags: lp-bugs oops
Revision history for this message
Björn Tillenius (bjornt) wrote :

The main issue is probably that somehow a BugActivity.person is None (see OOPS-1311H1296). Either we created a BugActivity item with a None person, or some db surgery was done.

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

BugActivity.person is missing its foreign key constraint declaration.

This means that the person merge code doesn't know about this table, nor does the Person remover.

It looks like we have removed Person records that were referenced in BugActivity. In these cases, BugActivity.personID will contain an integer but BugActivity.person will return None.

We need to add the missing foreign key constraint. We need to repair the data.

Changed in malone:
status: New → Triaged
assignee: nobody → Stuart Bishop (stub)
Revision history for this message
Eleanor Berger (intellectronica) wrote :

It appears that this OOPS is now happening quite frequently, so I think it will be a good idea to prepare a simple fix which recovers from this gracefully. That in addition to investigating how we end up with these records and stopping that, which is less urgent.

Deryck Hodge (deryck)
Changed in malone:
importance: Undecided → High
milestone: 2.2.8 → 3.0
Diogo Matsubara (matsubara)
Changed in malone:
milestone: 3.0 → 3.1.10
Revision history for this message
Stuart Bishop (stub) wrote :

I'm landing a DB patch that reassigns the lost BugActivity records to 'janitor' and adds the missing foreign key constraint.

Revision history for this message
Diogo Matsubara (matsubara) wrote : Bug fixed by a commit

Fixed in db r8477 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/db-devel/revision/8477>

Changed in malone:
status: Triaged → Fix Committed
Deryck Hodge (deryck)
Changed in malone:
milestone: 3.1.10 → 3.0
Stuart Bishop (stub)
Changed in malone:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

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