Closed Bug 779484 Opened 12 years ago Closed 11 years ago

"Oops! We had an error." page displayed when deleting a developer profile.


(Marketplace Graveyard :: Developer Pages, defect)

Windows 7
Not set


(Not tracked)



(Reporter: vcarciu, Unassigned)



(Keywords: regression)

Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0

Steps to reproduce:
1.Login to marketplace and open any submitted app.
2.From "Manage developer profile" , create a new dev profile.
3.Try to delete the developer profile

Expected results:
Developer profile is deleted without any issue

Actual results:
Oops! We had an error." page displayed when deleting a developer profile.

Not reproducible on prod.
After pressing "Remove profile " twice, both fields were deleted even if "Oops.." page was displayed. Please see screencast for this bug below:
Issue is also reproducing on AMO
Screencast for this issue

IntegrityError: (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`addons_dev_allizom_org_new`.`addons_collections`, CONSTRAINT `addons_collections_ibfk_4` FOREIGN KEY (`comments`) REFERENCES `translations` (`id`))')

Stacktrace (most recent call last):

  File "django/core/handlers/", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "amo/", line 156, in wrapper
    return f(*args, **kw)

  File "amo/", line 148, in wrapper
    return f(*args, **kw)

  File "addons/", line 32, in wrapper
    return f(request, addon, *args, **kw)

  File "amo/", line 29, in wrapper
    return func(request, *args, **kw)

  File "devhub/", line 34, in wrapper
    return fun()

  File "devhub/", line 26, in <lambda>
    *args, **kw)

  File "amo/", line 50, in wrapper
    return f(request, *args, **kw)

  File "devhub/", line 580, in remove_profile
    delete_translation(addon, 'the_reason')

  File "translations/", line 161, in delete_translation

  File "django/db/models/", line 445, in delete

  File "django/db/models/", line 62, in decorated
    func(self, *args, **kwargs)

  File "django/db/models/", line 253, in delete
    query.delete_batch(pk_list, self.using)

  File "django/db/models/sql/", line 44, in delete_batch
    self.do_query(self.model._meta.db_table, where, using=using)

  File "django/db/models/sql/", line 29, in do_query

  File "django/db/models/sql/", line 750, in execute_sql
    cursor.execute(sql, params)

  File "django/db/backends/mysql/", line 86, in execute
    return self.cursor.execute(query, args)

  File "MySQLdb/", line 173, in execute
    self.errorhandler(self, exc, value)

  File "MySQLdb/", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
Target Milestone: --- → 2012-08-02
Target Milestone: 2012-08-02 → 2012-08-09
Assignee: nobody → ashort
Target Milestone: 2012-08-09 → 2012-08-16
After talking to basta about this, it seems like this is a result of hitting an edge case in MySQL replication.
Target Milestone: 2012-08-16 → 2012-08-23
I got rid of this page in bug 742902, but the issues are indicative of a bigger issue. Seems like something we don't need to worry about right now since it was caused by the db refresh.
Closing since this page has been removed.
Closed: 12 years ago
Resolution: --- → INVALID
(In reply to Allen Short [:ashort] from comment #5)
> Closing since this page has been removed.

See comment 4. Bug's still valid and page is still up. We're just not linking to it anymore. And this is very much related to bug 779740.
Assignee: ashort → nobody
Resolution: INVALID → ---
Target Milestone: 2012-08-23 → ---
Is this fixed with our new mysql settings?
I cant see "Manage developer profile" on MP anymore, but this issue is still reproducible on AMO.
This page is gone from Marketplace but issue persists on AMO.
Closed: 12 years ago11 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.