1080166 - [traceback] IntegrityError: (1062, "Duplicate entry '21-433028' for key 'obj_id'")

Status: RESOLVED FIXED

(Marketplace Graveyard :: Curation Tools, defect)

Description

[krupa raj[:krupa]]

steps to reproduce:
1. Go to https://marketplace.firefox.com/api/v2/feed/collections/essential-utilities/
2. Add localization in en-us and save
3. Add localization in all other locales and hit save

actual behavior:
sentry: http://sentry.mktmon.services.phx1.mozilla.com/mkt/marketplacefirefoxcom/group/9061/

traceback details:


Stacktrace (most recent call last):

  File "rest_framework/views.py", line 396, in dispatch
    response = handler(request, *args, **kwargs)
  File "mkt/feed/views.py", line 133, in update
    self.set_apps(self.get_object(), apps)
  File "mkt/feed/views.py", line 282, in set_apps
    super(FeedCollectionViewSet, self).set_apps(obj, apps)
  File "mkt/feed/views.py", line 111, in set_apps
    obj.set_apps(apps)
  File "mkt/feed/models.py", line 145, in set_apps
    self.add_app(Webapp.objects.get(pk=app))
  File "mkt/feed/models.py", line 113, in add_app
    order=order)
  File "django/db/models/manager.py", line 157, in create
    return self.get_queryset().create(**kwargs)
  File "django/db/models/query.py", line 322, in create
    obj.save(force_insert=True, using=self.db)
  File "django/db/models/base.py", line 545, in save
    force_update=force_update, update_fields=update_fields)
  File "django/db/models/base.py", line 573, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "django/db/models/base.py", line 654, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "django/db/models/base.py", line 687, in _do_insert
    using=using, raw=raw)
  File "django/db/models/manager.py", line 232, in _insert
    return insert_query(self.model, objs, fields, **kwargs)
  File "django/db/models/query.py", line 1514, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "django/db/models/sql/compiler.py", line 903, in execute_sql
    cursor.execute(sql, params)
  File "django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)
  File "django/db/backends/mysql/base.py", line 124, in execute
    return self.cursor.execute(query, args)
  File "MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue