1160670 - [dev] Unable to submit /contribute page

Status: RESOLVED FIXED

(www.mozilla.org :: Bedrock, defect)

Description

[Rebecca Billings [:rbillings]]

After signing up to contribute on demo5, the user is then redirected back to /contribute and the open form they just filled out with an error - and is never able to fully submit.  Found by automation, able to repro manually.

This does not repro on staging but does repro on demo5 & dev

Found here: https://webqa-ci.mozilla.com/job/mozilla.org.dev.saucelabs/1817/HTML_Report/

Comment 1

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

pmac / jgmize - as this is currently making automation on dev fail, would you mind taking a look?  Thanks!

Comment 2

[Josh Mize [:jgmize]]

Attachment: mcom-tests PR 297

Comment 3

[Josh Mize [:jgmize]]

Initially I thought these tests weren't actually passing in any environment, because I was under the impression that we were only running destructive tests against the dev environment, where it was failing. However, I see now that we are, in fact, running destructive tests against stage, just not prod, and I've closed the PR I initially opened.

After looking through the code and doing further manual testing, I found that there is an easy to miss "We apologize, but an error occurred in our system. Please try again later." message that is automatically scrolled past when there is a basket error, which in this case there is. Unfortunately, I haven't been able to trace down exactly what error we're getting from basket, but I did verify that the dev and demo environments are using a different basket environment (basket-dev.allizom.org) from stage (basket.allizom.org), and I did not find any differences in the bedrock code other than that (no branches based on settings.DEV). 

:pmac, would you mind looking into the basket errors?

Comment 4

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

Looking in New Relic [1] while mozilla.org.dev ran, I saw this error:

 django.db.utils:DatabaseError: (1146, "Table 'basket_dev_allizom_org.news_blockedemail' doesn't exist")
Sample stack trace
Traceback (most recent call last):
File "/usr/lib64/python2.6/site-packages/newrelic-2.32.0.28/newrelic/hooks/framework_django.py", line 497, in wrapper return wrapped(*args, **kwargs)
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/views/decorators/http.py", line 41, in inner return func(request, *args, **kwargs)
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/views/decorators/csrf.py", line 77, in wrapped_view return view_func(*args, **kwargs)
File "/data/www/basket-dev.allizom.org/basket/news/views.py", line 126, in get_involved if email_is_blocked(data['email']):
File "/data/www/basket-dev.allizom.org/basket/news/utils.py", line 73, in email_is_blocked for blocked in get_email_block_list():
File "/data/www/basket-dev.allizom.org/basket/news/utils.py", line 65, in get_email_block_list block_list = list(BlockedEmail.objects.values_list('email_domain', flat=True))
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/models/query.py", line 108, in __len__ self._result_cache.extend(self._iter)
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/models/query.py", line 1140, in iterator for row in self.query.get_compiler(self.db).results_iter():
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/models/sql/compiler.py", line 775, in results_iter for rows in self.execute_sql(MULTI):
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/models/sql/compiler.py", line 846, in execute_sql cursor.execute(sql, params)
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/backends/mysql/base.py", line 130, in execute six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2])
File "/data/www/basket-dev.allizom.org/basket/vendor/src/django/django/db/backends/mysql/base.py", line 120, in execute return self.cursor.execute(query, args)
File "/usr/lib64/python2.6/site-packages/newrelic-2.32.0.28/newrelic/hooks/database_dbapi2.py", line 22, in execute *args, **kwargs)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue
DatabaseError: (1146, "Table 'basket_dev_allizom_org.news_blockedemail' doesn't exist")


[1] https://rpm.newrelic.com/accounts/263620/applications/2639061/traced_errors/3759902474
[2] https://webqa-ci.mozilla.com/view/Mozilla.org/job/mozilla.org.dev/181/console

Comment 5

[Paul [:pmac] McLanahan]

HA! Good catch Stephen. Apparently the auto-deploy script doesn't run migrations :( I've now run them and at least this problem should now be gone.

Comment 6

[Dave Hunt [:davehunt] [he/him] ⌚BST]

Automated tests are passing again! Many thanks! :)