1198367 - [dev][traceback] Error with /usr/bin/env python -W ignore /data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/manage.py update_leaderboard

Status: VERIFIED WONTFIX

(Firefox Affiliates Graveyard :: affiliates.mozilla.org, defect)

Description

[Matt Brandt [:mbrandt]]

Tracebacks from affiliates-dev appear to have started roughly 2 days ago and are consistently streaming in. I don't have better data, it appears that neither New Relic or ErrorMill is logging this data.

    Traceback (most recent call last):
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/manage.py", line 23, in <module>
        manage.main()
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor/src/funfactory/funfactory/manage.py", line 143, in main
        execute_manager(current_settings)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/core/management/__init__.py", line 459, in execute_manager
        utility.execute()
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/core/management/__init__.py", line 382, in execute
        self.fetch_command(subcommand).run_from_argv(self.argv)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/core/management/base.py", line 196, in run_from_argv
        self.execute(*args, **options.__dict__)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/core/management/base.py", line 232, in execute
        output = self.handle(*args, **options)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/affiliates/base/management/commands/__init__.py", line 15, in handle
        return self.handle_quiet(*args, **kwargs)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/affiliates/links/management/commands/update_leaderboard.py", line 45, in handle_quiet
        LeaderboardStanding.objects.bulk_create(new_standings, batch_size=1000)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/manager.py", line 140, in bulk_create
        return self.get_query_set().bulk_create(*args, **kwargs)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/query.py", line 419, in bulk_create
        self._batched_insert(objs_without_pk, fields, batch_size)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/query.py", line 868, in _batched_insert
        using=self.db)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/manager.py", line 203, in _insert
        return insert_query(self.model, objs, fields, **kwargs)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/query.py", line 1593, in insert_query
        return query.get_compiler(using=using).execute_sql(return_id)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/models/sql/compiler.py", line 912, in execute_sql
        cursor.execute(sql, params)
      File "/data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/vendor-local/src/django/django/db/backends/mysql/base.py", line 114, in execute
        return self.cursor.execute(query, args)
      File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
        self.errorhandler(self, exc, value)
      File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
        raise errorclass, errorvalue
    django.db.utils.IntegrityError: (1062, "Duplicate entry '1-link_clicks' for key 'links_leaderboardstanding_ranking_629414cbea77acb7_uniq'")
    Error with /usr/bin/env python -W ignore /data/genericrhel6-dev/src/affiliates-dev.allizom.org/affiliates-app/manage.py update_leaderboard

Comment 1

[Giorgos Logiotatidis [:giorgos]]

Seems something is broken with the database. Since we're phasing out affiliates by the end of 2015 and development has already stopped, I suggest that we shut down dev instance entirely. In the unlikely case we need to develop or fix something we still have stage to test things.

What do you think :bsternthal?

Comment 2

[Ben (:bensternthal)]

Agree. Dev can be shut down.

Comment 3

[Giorgos Logiotatidis [:giorgos]]

ACK. Filed bug 1199123 and closing this one as WONTFIX. Thanks for reporting Matt.

Comment 4

[Matt Brandt [:mbrandt]]

Perfecto! Bumping to verified wontfix