Closed Bug 1416001 Opened 4 years ago Closed 4 years ago

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

Categories

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

defect

Tracking

(Not tracked)

RESOLVED WONTFIX

People

(Reporter: emorley, Unassigned)

References

(Blocks 1 open bug)

Details

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	
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.
Yeah taskcluster-github blocking non-ascii branch names would be ideal, in which case this is then wontfix :-)
Status: NEW → RESOLVED
Closed: 4 years ago
Resolution: --- → WONTFIX
See Also: → 1416856
You need to log in before you can comment on or make changes to this bug.