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

Status: VERIFIED FIXED

(Marketplace Graveyard :: Developer Pages, defect)

Description

[krupa raj[:krupa]]

Sometimes, https://marketplace-dev.allizom.org/developers/submit/ fails to load and tracebacks instead

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

traceback details:


DatabaseError: (1146, "Table 'addons_dev_allizom_org.waffle_flag_users' doesn't exist")

Stacktrace (most recent call last):

  File "django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "newrelic/api/object_wrapper.py", line 216, in __call__
    self._nr_instance, args, kwargs)
  File "newrelic/hooks/framework_django.py", line 475, in wrapper
    return wrapped(*args, **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 "mkt/submit/views.py", line 42, in submit
    return manifest(request)
  File "amo/decorators.py", line 32, in wrapper
    return func(request, *args, **kw)
  File "mkt/submit/decorators.py", line 37, in wrapper
    return f(request, *args, **kw)
  File "mkt/submit/decorators.py", line 21, in wrapper
    return f(request, *args, **kw)
  File "django/db/transaction.py", line 224, in inner
    return func(*args, **kwargs)
  File "mkt/submit/views.py", line 86, in manifest
    form = forms.NewWebappForm(request.POST or None, request=request)
  File "mkt/submit/forms.py", line 159, in __init__
    if (not waffle.flag_is_active(request, 'allow-b2g-paid-submission')
  File "waffle/__init__.py", line 54, in flag_is_active
    cache_flag(instance=flag)
  File "waffle/__init__.py", line 162, in cache_flag
    cache.add(keyfmt(FLAG_USERS_CACHE_KEY, f.name), f.users.all())
  File "caching/backends/memcached.py", line 11, in add
    return super(CacheClass, self).add(key, value, timeout, version)
  File "django/core/cache/backends/memcached.py", line 53, in add
    return self._cache.add(key, value, self._get_memcache_timeout(timeout))
  File "newrelic/api/memcache_trace.py", line 73, in __call__
    return self._nr_next_object(*args, **kwargs)
  File "site-packages/memcache.py", line 525, in add
    return self._set("add", key, val, time, min_compress_len)
  File "site-packages/memcache.py", line 835, in _set
    return _unsafe_set()
  File "site-packages/memcache.py", line 812, in _unsafe_set
    store_info = self._val_to_store_info(val, min_compress_len)
  File "site-packages/memcache.py", line 782, in _val_to_store_info
    pickler.dump(val)
  File "python2.6/copy_reg.py", line 84, in _reduce_ex
    dict = getstate()
  File "django/db/models/query.py", line 65, in __getstate__
    len(self)
  File "django/db/models/query.py", line 85, in __len__
    self._result_cache = list(self.iterator())
  File "django/db/models/query.py", line 291, in iterator
    for row in compiler.results_iter():
  File "django/db/models/sql/compiler.py", line 763, in results_iter
    for rows in self.execute_sql(MULTI):
  File "django/db/models/sql/compiler.py", line 818, in execute_sql
    cursor.execute(sql, params)
  File "django/db/backends/mysql/base.py", line 114, in execute
    return self.cursor.execute(query, args)
  File "newrelic/hooks/database_dbapi2.py", line 36, in execute
    return self._nr_cursor.execute(sql, *args, **kwargs)
  File "MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)
  File "MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue

Comment 1

[krupa raj[:krupa]]

STR:
1. As an anonymous user, load https://marketplace.allizom.org/developers/submit/
2. Sign in using persona

expected behavior:
User proceeds to the next step in app submission

actual behavior:
traceback!

Comment 2

[Christopher Van Wiemeersch [:cvan]]

Looks like a regression from https://github.com/mozilla/zamboni/commit/2946307

Comment 3

[Christopher Van Wiemeersch [:cvan]]

https://github.com/jsocol/django-waffle/blob/master/waffle/models.py#L38-L40

Comment 4

[Christopher Van Wiemeersch [:cvan]]

https://github.com/mozilla/zamboni/commit/ae0cf92c9

Comment 5

[Victor Carciu]

Verified as fixed following the steps from comment #1 .