1301698 - PerformanceSignatureViewSet.list "ValueError: MySQL backend does not support timezone-aware datetimes when USE_TZ is False."

Status: RESOLVED DUPLICATE of bug 1209474

(Tree Management :: Perfherder, defect, P1)

Description

[Ed Morley [:emorley]]

https://rpm.newrelic.com/accounts/677903/applications/4180461/traced_errors/faf880a0-769c-11e6-a90b-b82a72d22a14_0_6714

Traceback (most recent call last):
...
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/rest_framework/views.py", line 463, in dispatch
File "/data/www/treeherder.mozilla.org/treeherder-service/treeherder/webapp/api/performance_data.py", line 100, in list
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/query.py", line 162, in __iter__
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/query.py", line 965, in _fetch_all
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/query.py", line 1220, in iterator
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 794, in results_iter
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 829, in execute_sql
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 387, in as_sql
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 357, in compile
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/where.py", line 104, in as_sql
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 357, in compile
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/lookups.py", line 219, in as_sql
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/lookups.py", line 177, in process_rhs
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/lookups.py", line 148, in get_db_prep_lookup
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/fields/__init__.py", line 766, in get_db_prep_lookup
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/models/fields/__init__.py", line 1483, in get_db_prep_value
File "/data/www/treeherder.mozilla.org/venv/lib/python2.7/site-packages/django/db/backends/mysql/operations.py", line 150, in value_to_db_datetime
 exceptions:ValueError: MySQL backend does not support timezone-aware datetimes when USE_TZ is False.

Comment 1

[William Lachance (:wlach)]

This is related to :rwood's patch in bug 1288007.

I am getting pretty sick of this bug (it's the 3rd time I've been bitten by it). As discussed with :emorley on irc, we should probably just fix bug 1209474 and be done with it.

Comment 2

[Ed Morley [:emorley]]

Fixed by bug 1209474 (setting `USE_TZ = True`).