700838 - [traceback] [dev] ISE: OperationalError: (1054, "Unknown column 'profile.is_vouched' in 'field list'")

Status: VERIFIED FIXED

(Participation Infrastructure :: Phonebook, defect)

Description

[Matt Brandt [:mbrandt]]

Traceback (most recent call last):

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/core/handlers/base.py", line 111, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django-session-csrf/session_csrf/__init__.py", line 107, in wrapper
   response = f(request, *args, **kw)

 File "/data/www/mozillians-dev.allizom.org/mozillians/apps/users/views.py", line 59, in login
   if request.user.is_anonymous()

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/views/decorators/debug.py", line 69, in wrapper
   return view(request, *args, **kwargs)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/utils/decorators.py", line 91, in _wrapped_view
   response = view_func(request, *args, **kwargs)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/views/decorators/cache.py", line 88, in _wrapped_view_func
   response = view_func(request, *args, **kwargs)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/contrib/auth/views.py", line 36, in login
   if form.is_valid():

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/forms/forms.py", line 121, in is_valid
   return self.is_bound and not bool(self.errors)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/forms/forms.py", line 112, in _get_errors
   self.full_clean()

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/forms/forms.py", line 268, in full_clean
   self._clean_form()

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/forms/forms.py", line 296, in _clean_form
   self.cleaned_data = self.clean()

 File "/data/www/mozillians-dev.allizom.org/mozillians/apps/users/forms.py", line 45, in clean
   profile = self.user_cache.get_profile()

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/contrib/auth/models.py", line 343, in get_profile
   self._profile_cache = model._default_manager.using(self._state.db).get(user__id__exact=self.id)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/models/query.py", line 344, in get
   num = len(clone)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/models/query.py", line 82, in __len__
   self._result_cache = list(self.iterator())

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/models/query.py", line 273, in iterator
   for row in compiler.results_iter():

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 699, in results_iter
   for rows in self.execute_sql(MULTI):

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/models/sql/compiler.py", line 754, in execute_sql
   cursor.execute(sql, params)

 File "/data/www/mozillians-dev.allizom.org/mozillians/vendor/src/django/django/db/backends/mysql/base.py", line 86, in execute
   return self.cursor.execute(query, args)

 File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
   self.errorhandler(self, exc, value)

 File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
   raise errorclass, errorvalue

OperationalError: (1054, "Unknown column 'profile.is_vouched' in 'field list'")

Comment 1

[Matt Brandt [:mbrandt]]

An update from automation, all of our tests that require a login are now failing on dev.

Comment 2

[Stephen Donner [:stephend] Not actively reading bugmail]

Fix from tofumatt landed in https://github.com/mozilla/mozillians/commit/707e2f774da49cdbb9cdbb126cc6efa0efaedcec, but we're still seeing this; odd.

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

(In reply to Stephen Donner [:stephend] from comment #2)
> Fix from tofumatt landed in
> https://github.com/mozilla/mozillians/commit/
> 707e2f774da49cdbb9cdbb126cc6efa0efaedcec, but we're still seeing this; odd.

Oh, needing migrations, I guess?

Comment 4

[tofumatt [:tofumatt]]

Yes, a migration needs to be run. I'll see if I can get to it myself since it's the dev server and I believe I can do that on there.

Comment 5

[tofumatt [:tofumatt]]

Ran the migration and things are fine, though there's a manage.py cron task we need to run to have the vouching status be right everywhere and it's got a bug (so please hold off pointing out that profiles all appear unvouched).

I'll close this out though.

Comment 6

[Trif Andrei-Alin[:AlinT]]

Verified on dev, migration was made with success.