764889 - [traceback] DatabaseError: (1146, "Table 'addons_dev_allizom_org.ratings' doesn't exist")

Status: VERIFIED FIXED

(Marketplace Graveyard :: Developer Pages, defect)

Description

[Victor Carciu]

Prerequisites:
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/16.0 Firefox/16.0a1

Steps to reproduce:
1.Go to https://marketplace-dev.allizom.org/en-US/developers/submissions 
2.Select an app with a developer profile already set up and try to remove the developer profile(https://marketplace-dev.allizom.org/en-US/developers/app/test-app-abcdefff/profile).

Expected results:
Developer profile is successfully deleted.

Actual results:
"Oops " page is returned .

Please see screencast for this issue: http://screencast.com/t/QBahCIxp5Q

Note: 
Not reproducible in production.

Comment 1

[krupa raj[:krupa]]

Stacktrace (most recent call last):

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

  File "amo/decorators.py", line 157, in wrapper
    return f(*args, **kw)

  File "amo/decorators.py", line 149, in wrapper
    return f(*args, **kw)

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

  File "amo/decorators.py", line 30, in wrapper
    return func(request, *args, **kw)

  File "mkt/developers/decorators.py", line 50, in wrapper
    return fun()

  File "mkt/developers/decorators.py", line 29, in <lambda>
    *args, **kw)

  File "amo/decorators.py", line 51, in wrapper
    return f(request, *args, **kw)

  File "mkt/developers/views.py", line 595, in remove_profile
    delete_translation(addon, 'the_future')

  File "translations/models.py", line 161, in delete_translation
    Translation.objects.filter(id=trans.id).delete()

  File "django/db/models/query.py", line 444, in delete
    collector.collect(del_query)

  File "django/db/models/deletion.py", line 167, in collect
    if not sub_objs:

  File "django/db/models/query.py", line 113, in __nonzero__
    iter(self).next()

  File "django/db/models/query.py", line 89, in __iter__
    self._iter = self.iterator()

  File "caching/base.py", line 136, in iterator
    return iter(iterator())

  File "queryset_transform/__init__.py", line 20, in iterator
    results = list(result_iter)

  File "django/db/models/query.py", line 273, in iterator
    for row in compiler.results_iter():

  File "django/db/models/sql/compiler.py", line 695, in results_iter
    for rows in self.execute_sql(MULTI):

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

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

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

  File "MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
DatabaseError: (1146, "Table 'addons_dev_allizom_org.ratings' doesn't exist")

http://sentry.dmz.phx1.mozilla.com/marketplace-dev/group/458/

Comment 2

[Christopher Van Wiemeersch [:cvan]]

FWIW, this has the same bug description as bug 763734 and bug 764868. That's confusing!

Comment 3

[Christopher Van Wiemeersch [:cvan]]

https://github.com/mozilla/zamboni/commit/1bc3c77

Hat tip to robhudson for the help!

Comment 4

[Victor Carciu]

Verified as fixed.

Please see screencast: http://screencast.com/t/5ofRnQKfIXm7