Duplicate submission key error

[markkuriekkinen]

An example from the logs with some censored parts.

radar_celery_io[26007]: [2020-12-14 TIME: ERROR/ForkPoolWorker-1] provider.tasks.create_submission[None]: Submission with key 1234567 already exists, will not create a duplicate.

radar_celery_io[26007]: [2020-12-14 TIME: INFO/tokenizer] Tokenizing submission Basics in Programming Y1/1.4 |en:Substitutive exercise 4: Bookshelf|fi:Rästitehtävä 4: Kirjahylly|: -XXXXXX- grade=XYZ.0 (created: 2020-12-14 TIME) (submitted: -XYZ-)
radar_celery_io[26007]: [2020-12-14 TIME: INFO/ForkPoolWorker-3] Tokenizing submission Basics in Programming Y1/1.4 |en:Substitutive exercise 4: Bookshelf|fi:Rästitehtävä 4: Kirjahylly|: 540104 grade=315.0 (created: 2020-12-14 TIME) (submitted: 2020-11-28T19:04:02.829618+02:00)
radar_celery_io[26007]: [2020-12-14 TIME: ERROR/ForkPoolWorker-3] Task provider.tasks.reload_exercise_submissions[09a07924-c385-4371-a83f-a6e2fe507b54] raised unexpected: IntegrityError('duplicate key value violates unique constraint "data_submission_key_key"\nDETAIL:  Key (key)=(1234567) already exists.\n',)
radar_celery_io[26007]: Traceback (most recent call last):
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 85, in _execute
radar_celery_io[26007]:     return self.cursor.execute(sql, params)
radar_celery_io[26007]: psycopg2.IntegrityError: duplicate key value violates unique constraint "data_submission_key_key"
radar_celery_io[26007]: DETAIL:  Key (key)=(3611770) already exists.
radar_celery_io[26007]: The above exception was the direct cause of the following exception:
radar_celery_io[26007]: Traceback (most recent call last):
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/celery/app/trace.py", line 375, in trace_task
radar_celery_io[26007]:     R = retval = fun(*args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/celery/app/trace.py", line 632, in __protected_call__
radar_celery_io[26007]:     return self.run(*args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/radar/provider/tasks.py", line 158, in reload_exercise_submissions
radar_celery_io[26007]:     create_submission(submission["id"], exercise.course.key, submission["url"], exercise.matching_start_time)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/celery/local.py", line 193, in __call__
radar_celery_io[26007]:     return self._get_current_object()(*a, **kw)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/celery/app/trace.py", line 633, in __protected_call__
radar_celery_io[26007]:     return orig(self, *args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/celery/app/task.py", line 379, in __call__
radar_celery_io[26007]:     return self.run(*args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/radar/provider/tasks.py", line 95, in create_submission
radar_celery_io[26007]:     grade=data["grade"],
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/manager.py", line 82, in manager_method
radar_celery_io[26007]:     return getattr(self.get_queryset(), name)(*args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/query.py", line 417, in create
radar_celery_io[26007]:     obj.save(force_insert=True, using=self.db)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/base.py", line 729, in save
radar_celery_io[26007]:     force_update=force_update, update_fields=update_fields)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/base.py", line 759, in save_base
radar_celery_io[26007]:     updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/base.py", line 842, in _save_table
radar_celery_io[26007]:     result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/base.py", line 880, in _do_insert
radar_celery_io[26007]:     using=using, raw=raw)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/manager.py", line 82, in manager_method
radar_celery_io[26007]:     return getattr(self.get_queryset(), name)(*args, **kwargs)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/query.py", line 1128, in _insert
radar_celery_io[26007]:     return query.get_compiler(using=using).execute_sql(return_id)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 1285, in execute_sql
radar_celery_io[26007]:     cursor.execute(sql, params)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 68, in execute
radar_celery_io[26007]:     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
radar_celery_io[26007]:     return executor(sql, params, many, context)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 85, in _execute
radar_celery_io[26007]:     return self.cursor.execute(sql, params)
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/utils.py", line 89, in __exit__
radar_celery_io[26007]:     raise dj_exc_value.with_traceback(traceback) from exc_value
radar_celery_io[26007]:   File "/srv/radar/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 85, in _execute
radar_celery_io[26007]:     return self.cursor.execute(sql, params)
radar_celery_io[26007]: django.db.utils.IntegrityError: duplicate key value violates unique constraint "data_submission_key_key"
radar_celery_io[26007]: DETAIL:  Key (key)=(1234567) already exists.