Skip to content

Instantly share code, notes, and snippets.

@evz
Created October 8, 2015 13:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save evz/69a7d61f31ed59c0fb08 to your computer and use it in GitHub Desktop.
Save evz/69a7d61f31ed59c0fb08 to your computer and use it in GitHub Desktop.
NYC loaddata 2015-10-08
Traceback (most recent call last):
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 405, in get_or_create
return self.get(**lookup), False
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 334, in get
self.model._meta.object_name
core.models.DoesNotExist: Event matching query does not exist.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
psycopg2.IntegrityError: duplicate key value violates unique constraint "core_event_slug_key"
DETAIL: Key (slug)=(434664) already exists.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line
utility.execute()
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/core/management/__init__.py", line 330, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/core/management/base.py", line 393, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/core/management/base.py", line 444, in execute
output = self.handle(*args, **options)
File "/home/datamade/nyc-councilmatic/core/management/commands/loaddata.py", line 54, in handle
self.grab_events(delete=options['delete'])
File "/home/datamade/nyc-councilmatic/core/management/commands/loaddata.py", line 481, in grab_events
self.grab_event(result['id'])
File "/home/datamade/nyc-councilmatic/core/management/commands/loaddata.py", line 507, in grab_event
slug = legistar_id,
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 407, in get_or_create
return self._create_object_from_params(lookup, params)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 447, in _create_object_from_params
six.reraise(*exc_info)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/utils/six.py", line 659, in reraise
raise value
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 439, in _create_object_from_params
obj = self.create(**params)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 348, in create
obj.save(force_insert=True, using=self.db)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/base.py", line 710, in save
force_update=force_update, update_fields=update_fields)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/base.py", line 738, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/base.py", line 822, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/base.py", line 861, in _do_insert
using=using, raw=raw)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/query.py", line 920, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql
cursor.execute(sql, params)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/utils.py", line 97, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/utils/six.py", line 658, in reraise
raise value.with_traceback(tb)
File "/home/datamade/.virtualenvs/nyc/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.IntegrityError: duplicate key value violates unique constraint "core_event_slug_key"
DETAIL: Key (slug)=(434664) already exists.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment