changing part on site and renaming files to match in volume causes db error #2915

New issue

Open

opened 2016-04-25 10:35:30 +00:00 by j · 0 comments

j commented

2016-04-25 10:35:30 +00:00

Owner

aised unexpected: <IntegrityError>('duplicate key value violates unique constraint "archive_instance_path_2ebe95be61ef7d2c_uniq"\nDETAIL:  Key (path, volume_id)=(E/Example/..., 8) already exists.\n',)
Traceback (most recent call last):
> File "/srv/pandora/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task
    R = retval = fun(*args, **kwargs)
> File "/srv/pandora/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in *protected_call*
    return self.run(*args, **kwargs)
> File "/srv/pandora/pandora/archive/tasks.py", line 77, in update_files
    update_or_create_instance(volume, f)
> File "/srv/pandora/pandora/archive/tasks.py", line 43, in update_or_create_instance
    instance.save()
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 700, in save
    force_update=force_update, update_fields=update_fields)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 728, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 793, in _save_table
    forced_update)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 843, in _do_update
    return filtered._update(values) > 0
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/query.py", line 645, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1149, in execute_sql
    cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 848, in execute_sql
    cursor.execute(sql, params)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/utils.py", line 95, in *exit*
    six.reraise(dj_exc_type, dj_exc_value, traceback)
> File "/srv/pandora/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
<IntegrityError>: duplicate key value violates unique constraint "archive_instance_path_2ebe95be61ef7d2c_uniq"
DETAIL:  Key (path, volume_id)=(E/Example/..., 8) already exists.

``` aised unexpected: <IntegrityError>('duplicate key value violates unique constraint "archive_instance_path_2ebe95be61ef7d2c_uniq"\nDETAIL: Key (path, volume_id)=(E/Example/..., 8) already exists.\n',) Traceback (most recent call last): > File "/srv/pandora/local/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task R = retval = fun(*args, **kwargs) > File "/srv/pandora/local/lib/python2.7/site-packages/celery/app/trace.py", line 438, in *protected_call* return self.run(*args, **kwargs) > File "/srv/pandora/pandora/archive/tasks.py", line 77, in update_files update_or_create_instance(volume, f) > File "/srv/pandora/pandora/archive/tasks.py", line 43, in update_or_create_instance instance.save() > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 700, in save force_update=force_update, update_fields=update_fields) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 728, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 793, in _save_table forced_update) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/base.py", line 843, in _do_update return filtered._update(values) > 0 > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/query.py", line 645, in _update return query.get_compiler(self.db).execute_sql(CURSOR) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1149, in execute_sql cursor = super(SQLUpdateCompiler, self).execute_sql(result_type) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 848, in execute_sql cursor.execute(sql, params) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/utils.py", line 95, in *exit* six.reraise(dj_exc_type, dj_exc_value, traceback) > File "/srv/pandora/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) <IntegrityError>: duplicate key value violates unique constraint "archive_instance_path_2ebe95be61ef7d2c_uniq" DETAIL: Key (path, volume_id)=(E/Example/..., 8) already exists. ```