906939 - [traceback] IntegrityError: (1062, "Duplicate entry ... - Collections cannot be saved

Status: RESOLVED FIXED

(Marketplace Graveyard :: General, defect, P1)

Description

[Christopher Van Wiemeersch [:cvan]]

Can reproduce locally. As reproduced on -dev:

    >>> Collection
    <class 'mkt.collections.models.Collection'>
    >>> Collection.objects.all()[0]
    <Collection: lhwfdlvkfhv>
    >>> c=Collection.objects.all()[0]
    >>> c.save()
    Traceback (most recent call last):
      File "<console>", line 1, in <module>
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/models/base.py", line 463, in save
        self.save_base(using=using, force_insert=force_insert, force_update=force_update)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/models/base.py", line 551, in save_base
        result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/models/manager.py", line 203, in _insert
        return insert_query(self.model, objs, fields, **kwargs)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/models/query.py", line 1593, in insert_query
        return query.get_compiler(using=using).execute_sql(return_id)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 912, in execute_sql
        cursor.execute(sql, params)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/django/db/backends/mysql/base.py", line 114, in execute
        return self.cursor.execute(query, args)
      File "/data/addons-dev/www/addons-dev.allizom.org/deploy-zamboni-dev-20130819151712-55e2ed4f79/venv/lib/python2.6/site-packages/newrelic-1.11.0.55/newrelic/hooks/database_dbapi2.py", line 32, in execute
        return self._nr_cursor.execute(sql, *args, **kwargs)
      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
    IntegrityError: (1062, "Duplicate entry '37' for key 'PRIMARY'")

Comment 1

[Mathieu Pillard [:mat]]

Fixed in https://github.com/mozilla/zamboni/commit/0c44d590956e8f92468028863bc09fe9b28a1b05