1226001 - [traceback] Some referrers are too long for HelpfulVoteMetadata

Status: RESOLVED WONTFIX

(support.mozilla.org :: Code Quality, task)

Description

[Michael Cooper [:mythmon]]

The data that is too long is a primarily a referrer that we are trying to put in the metadata. It is a Yandex search page hat includes a lot of URI encoded data and unicode and a variable called "state" and "sign". Overall it is just really really long. I'm not going to include the actual referrer here, because it might be sensitive data (I'm not sure).

https://errormill.mozilla.org/support/support/group/397066/

DataError: (1406, "Data too long for column 'value' at row 1")

Stacktrace (most recent call last):

  File "django/core/handlers/base.py", line 111, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "newrelic/hooks/framework_django.py", line 497, in wrapper
    return wrapped(*args, **kwargs)
  File "django/views/decorators/http.py", line 41, in inner
    return func(request, *args, **kwargs)
  File "django/views/decorators/csrf.py", line 57, in wrapped_view
    return view_func(*args, **kwargs)
  File "kitsune/sumo/decorators.py", line 129, in _wrapped
    return fn(request, *args, **kwargs)
  File "kitsune/wiki/views.py", line 1118, in helpful_vote
    vote.add_metadata(name, val)
  File "kitsune/wiki/models.py", line 1130, in add_metadata
    HelpfulVoteMetadata.objects.create(vote=self, key=key, value=value)
  File "django/db/models/manager.py", line 92, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "django/db/models/query.py", line 372, in create
    obj.save(force_insert=True, using=self.db)
  File "django/db/models/base.py", line 589, in save
    force_update=force_update, update_fields=update_fields)
  File "django/db/models/base.py", line 617, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "django/db/models/base.py", line 698, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "django/db/models/base.py", line 731, in _do_insert
    using=using, raw=raw)
  File "django/db/models/manager.py", line 92, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "django/db/models/query.py", line 921, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "django/db/models/sql/compiler.py", line 921, in execute_sql
    cursor.execute(sql, params)
  File "django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "django/db/backends/mysql/base.py", line 129, in execute
    return self.cursor.execute(query, args)
  File "newrelic/hooks/database_dbapi2.py", line 22, in execute
    *args, **kwargs)
  File "MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)
  File "MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue

Comment 1

[Paul]

Closed as per https://blog.mozilla.org/sumo/2019/06/07/sumo-platform-roadmap/