It should be possible to delete an auto-generated bugwatch that has comments attached

Bug #301740 reported by Graham Binns
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
Low
Unassigned

Bug Description

At the moment it's impossible to delete a bug watch which has comments attached. You get OOPS-1046D4100 (see also: bug 296936).

We should make it possible to delete these watches through the UI so that we don't have to remove them manually. We should make this an admin-only function since the comments may be relevant and we don't want just anyone deleting them all.

Related branches

Revision history for this message
Graham Binns (gmb) wrote :

This actually causes an OOPS at the moment, so for all that I've just set it to medium I'm going to bump it up to high.

Changed in malone:
importance: Undecided → Medium
status: New → Triaged
importance: Medium → High
milestone: none → 2.1.12
assignee: nobody → gmb
Revision history for this message
Graham Binns (gmb) wrote :

Pushing this back to 2.2.1.

Changed in malone:
milestone: 2.1.12 → 2.2.1
Revision history for this message
Graham Binns (gmb) wrote :

Un-targeting this for now.

Changed in malone:
milestone: 2.2.1 → none
Graham Binns (gmb)
Changed in malone:
assignee: Graham Binns (gmb) → nobody
Revision history for this message
Micah Gersten (micahg) wrote :

This is actually a big issue now that auto generated watches are being pushed upstream to bugzilla.mozilla.org (bug 499113). I recently found out I can delete some bug watches, but if the comments have been imported, it seems impossible.

tags: added: oops
Changed in launchpad:
importance: High → Critical
William Grant (wgrant)
tags: added: bugwatch
Revision history for this message
Steve Kowalik (stevenk) wrote :

update or delete on table "bugwatch" violates foreign key constraint "bugmessage_bugwatch_fkey" on table "bugmessage"<br /> DETAIL: Key (id)=(13) is still referenced from table "bugmessage".<br /> <br />

Is what I get from trying to reproduce locally.

Revision history for this message
Robert Collins (lifeless) wrote : Re: [Bug 301740] Re: It should be possible to delete an auto-generated bugwatch that has comments attached

Yeah, you'll need to manually break those references.

Steve Kowalik (stevenk)
Changed in launchpad:
assignee: nobody → Steve Kowalik (stevenk)
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
Revision history for this message
Steve Kowalik (stevenk) wrote :

Forgot to land the linked branch with incr, which takes care of the OOPS.

tags: added: qa-ok
removed: qa-needstesting
Changed in launchpad:
importance: Critical → Low
status: Fix Committed → Triaged
tags: removed: oops
Ian Booth (wallyworld)
Changed in launchpad:
status: Triaged → Fix Released
Steve Kowalik (stevenk)
Changed in launchpad:
status: Fix Released → Triaged
assignee: Steve Kowalik (stevenk) → nobody
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.