1416001 - Unicode branch names cause store-pulse-jobs "OperationalError: (1267, "Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='")"

Status: RESOLVED WONTFIX

(Tree Management :: Treeherder: Data Ingestion, defect, P3)

Description

[Ed Morley [:emorley]]

This PR used a non-ascii github branch name:
https://github.com/taskcluster/taskcluster-lib-iterate/pull/7

Which resulted in...

Traceback (most recent call last):
...
File "/app/treeherder/etl/tasks/pulse_tasks.py", line 30, in store_pulse_resultsets
File "/app/treeherder/etl/push_loader.py", line 26, in process
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 374, in get
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 232, in __len__
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 1118, in _fetch_all
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py", line 53, in __iter__
File "/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 894, in execute_sql
django.db.utils:OperationalError: (1267, "Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='")

https://rpm.newrelic.com/accounts/677903/applications/14179757/filterable_errors?tw%5Bend%5D=1510262237&tw%5Bstart%5D=1510003037#/show/4aceeca8-c4e0-11e7-8a03-0242ac11000b_4677_9337/stack_trace?top_facet=transactionUiName&primary_facet=error.class&barchart=barchart&_k=71yjtp

Error attributes
exchange	exchange/taskcluster-github/v1/push
number_of_prior_retries	10
routing_key	primary.taskcluster.taskcluster-lib-iterate
url	https://github.com/taskcluster/taskcluster-lib-iterate
branch	

Comment 1

[Brian Stack [:bstack]]

It actually caused taskcluster-github to fail as well due to non-ascii not being allowed in scopes. I think probably the best way to move forward would be for taskcluster-github to not allow non-ascii branches to build at all.

Comment 2

[Ed Morley [:emorley]]

Yeah taskcluster-github blocking non-ascii branch names would be ideal, in which case this is then wontfix :-)