· 9 years ago · Apr 02, 2017, 10:48 PM
1IntegrityError at /api/users/
2duplicate key value violates unique constraint "auth_user_username_key"
3DETAIL: Key (username)=(miles1@likeminded.io) already exists.
4
5
6Request Method: POST
7Request URL: http://127.0.0.1:9910/api/users/
8Django Version: 1.10.6
9Python Executable: /usr/local/bin/python3.5
10Python Version: 3.5.3
11Python Path: ['/app', '/usr/local/bin', '/usr/local/lib/python35.zip', '/usr/local/lib/python3.5', '/usr/local/lib/python3.5/plat-linux', '/usr/local/lib/python3.5/lib-dynload', '/usr/local/lib/python3.5/site-packages']
12Server time: Sun, 2 Apr 2017 22:43:49 +0000
13Installed Applications:
14['django.contrib.admin',
15 'django.contrib.auth',
16 'django.contrib.contenttypes',
17 'django.contrib.sessions',
18 'django.contrib.messages',
19 'django.contrib.staticfiles',
20 'bootstrapform',
21 'rest_framework',
22 'rest_framework.authtoken',
23 'website',
24 'applications']
25Installed Middleware:
26['django.middleware.security.SecurityMiddleware',
27 'django.contrib.sessions.middleware.SessionMiddleware',
28 'django.middleware.common.CommonMiddleware',
29 'django.middleware.csrf.CsrfViewMiddleware',
30 'django.contrib.auth.middleware.AuthenticationMiddleware',
31 'django.contrib.messages.middleware.MessageMiddleware',
32 'django.middleware.clickjacking.XFrameOptionsMiddleware']
33
34
35Traceback:
36
37File "/usr/local/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
38 64. return self.cursor.execute(sql, params)
39
40
41 The above exception (duplicate key value violates unique constraint "auth_user_username_key"
42DETAIL: Key (username)=(miles1@likeminded.io) already exists.
43) was the direct cause of the following exception:
44
45
46
47File "/usr/local/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
48 42. response = get_response(request)
49
50File "/usr/local/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
51 187. response = self.process_exception_by_middleware(e, request)
52
53File "/usr/local/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
54 185. response = wrapped_callback(request, *callback_args, **callback_kwargs)
55
56File "/usr/local/lib/python3.5/site-packages/django/views/decorators/csrf.py" in wrapped_view
57 58. return view_func(*args, **kwargs)
58
59File "/usr/local/lib/python3.5/site-packages/rest_framework/viewsets.py" in view
60 83. return self.dispatch(request, *args, **kwargs)
61
62File "/usr/local/lib/python3.5/site-packages/rest_framework/views.py" in dispatch
63 483. response = self.handle_exception(exc)
64
65File "/usr/local/lib/python3.5/site-packages/rest_framework/views.py" in handle_exception
66 443. self.raise_uncaught_exception(exc)
67
68File "/usr/local/lib/python3.5/site-packages/rest_framework/views.py" in dispatch
69 480. response = handler(request, *args, **kwargs)
70
71File "/app/applications/views.py" in create
72 125. email=form.cleaned_data['email'],
73
74File "/usr/local/lib/python3.5/site-packages/django/contrib/auth/models.py" in create_user
75 157. return self._create_user(username, email, password, **extra_fields)
76
77File "/usr/local/lib/python3.5/site-packages/django/contrib/auth/models.py" in _create_user
78 151. user.save(using=self._db)
79
80File "/usr/local/lib/python3.5/site-packages/django/contrib/auth/base_user.py" in save
81 80. super(AbstractBaseUser, self).save(*args, **kwargs)
82
83File "/usr/local/lib/python3.5/site-packages/django/db/models/base.py" in save
84 796. force_update=force_update, update_fields=update_fields)
85
86File "/usr/local/lib/python3.5/site-packages/django/db/models/base.py" in save_base
87 824. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
88
89File "/usr/local/lib/python3.5/site-packages/django/db/models/base.py" in _save_table
90 908. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
91
92File "/usr/local/lib/python3.5/site-packages/django/db/models/base.py" in _do_insert
93 947. using=using, raw=raw)
94
95File "/usr/local/lib/python3.5/site-packages/django/db/models/manager.py" in manager_method
96 85. return getattr(self.get_queryset(), name)(*args, **kwargs)
97
98File "/usr/local/lib/python3.5/site-packages/django/db/models/query.py" in _insert
99 1045. return query.get_compiler(using=using).execute_sql(return_id)
100
101File "/usr/local/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in execute_sql
102 1054. cursor.execute(sql, params)
103
104File "/usr/local/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
105 79. return super(CursorDebugWrapper, self).execute(sql, params)
106
107File "/usr/local/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
108 64. return self.cursor.execute(sql, params)
109
110File "/usr/local/lib/python3.5/site-packages/django/db/utils.py" in __exit__
111 94. six.reraise(dj_exc_type, dj_exc_value, traceback)
112
113File "/usr/local/lib/python3.5/site-packages/django/utils/six.py" in reraise
114 685. raise value.with_traceback(tb)
115
116File "/usr/local/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
117 64. return self.cursor.execute(sql, params)
118
119Exception Type: IntegrityError at /api/users/
120Exception Value: duplicate key value violates unique constraint "auth_user_username_key"
121DETAIL: Key (username)=(miles1@likeminded.io) already exists.
122
123Request information:
124USER: AnonymousUser
125
126GET: No GET data
127
128POST: No POST data
129
130FILES: No FILES data
131
132COOKIES: No cookie data
133
134META:
135CONTENT_LENGTH = '55'
136CONTENT_TYPE = 'application/json'
137HTTP_ACCEPT = 'application/json'
138HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
139HTTP_ACCEPT_LANGUAGE = 'en-GB,pl-PL;q=0.8,pl;q=0.6,en-US;q=0.4,en;q=0.2'
140HTTP_CONNECTION = 'close'
141HTTP_DNT = '1'
142HTTP_HOST = '127.0.0.1:9910'
143HTTP_ORIGIN = 'http://127.0.0.1:9910'
144HTTP_REFERER = 'http://127.0.0.1:9910/login'
145HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'
146HTTP_X_FORWARD_FOR = '172.19.0.1'
147PATH_INFO = '/api/users/'
148QUERY_STRING = ''
149RAW_URI = '/api/users/'
150REMOTE_ADDR = '172.19.0.5'
151REMOTE_PORT = '55892'
152REQUEST_METHOD = 'POST'
153SCRIPT_NAME = ''
154SERVER_NAME = '0.0.0.0'
155SERVER_PORT = '8000'
156SERVER_PROTOCOL = 'HTTP/1.0'
157SERVER_SOFTWARE = 'gunicorn/19.7.1'
158gunicorn.socket = <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('172.19.0.4', 8000), raddr=('172.19.0.5', 55892)>
159wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f86728755c0>
160wsgi.file_wrapper = ''
161wsgi.input = <gunicorn.http.body.Body object at 0x7f8672875a20>
162wsgi.multiprocess = False
163wsgi.multithread = False
164wsgi.run_once = False
165wsgi.url_scheme = 'http'
166wsgi.version =
167
168Settings:
169Using settings module zeroth.settings
170ABSOLUTE_URL_OVERRIDES = {}
171ACCOUNT_ACTIVATION_DAYS = 30
172ADMINS = []
173ALLOWED_HOSTS = ['127.0.0.1', None]
174APPEND_SLASH = True
175AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
176AUTH_PASSWORD_VALIDATORS = '********************'
177AUTH_USER_MODEL = 'auth.User'
178BASE_DIR = '/app'
179CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
180CACHE_MIDDLEWARE_ALIAS = 'default'
181CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
182CACHE_MIDDLEWARE_SECONDS = 600
183CSRF_COOKIE_AGE = 31449600
184CSRF_COOKIE_DOMAIN = None
185CSRF_COOKIE_HTTPONLY = False
186CSRF_COOKIE_NAME = 'csrftoken'
187CSRF_COOKIE_PATH = '/'
188CSRF_COOKIE_SECURE = False
189CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
190CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
191CSRF_TRUSTED_ORIGINS = []
192DATABASES = {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'NAME': 'zeroth', 'HOST': 'postgres', 'TEST': {'CHARSET': None, 'NAME': None, 'COLLATION': None, 'MIRROR': None}, 'OPTIONS': {}, 'ENGINE': 'django.db.backends.postgresql', 'PASSWORD': '********************', 'PORT': '', 'USER': 'user', 'TIME_ZONE': None}}
193DATABASE_ROUTERS = []
194DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
195DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
196DATETIME_FORMAT = 'N j, Y, P'
197DATETIME_INPUT_FORMATS = ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y']
198DATE_FORMAT = 'N j, Y'
199DATE_INPUT_FORMATS = ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y']
200DEBUG = '1'
201DEBUG_PROPAGATE_EXCEPTIONS = False
202DECIMAL_SEPARATOR = '.'
203DEFAULT_CHARSET = 'utf-8'
204DEFAULT_CONTENT_TYPE = 'text/html'
205DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
206DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
207DEFAULT_FROM_EMAIL = 'webmaster@localhost'
208DEFAULT_INDEX_TABLESPACE = ''
209DEFAULT_TABLESPACE = ''
210DISALLOWED_USER_AGENTS = []
211EMAIL_BACKEND = 'django_mailgun.MailgunBackend'
212EMAIL_HOST = 'localhost'
213EMAIL_HOST_PASSWORD = '********************'
214EMAIL_HOST_USER = ''
215EMAIL_PORT = 25
216EMAIL_SSL_CERTFILE = None
217EMAIL_SSL_KEYFILE = '********************'
218EMAIL_SUBJECT_PREFIX = '[Django] '
219EMAIL_TIMEOUT = None
220EMAIL_USE_SSL = False
221EMAIL_USE_TLS = False
222FILE_CHARSET = 'utf-8'
223FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
224FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
225FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
226FILE_UPLOAD_PERMISSIONS = None
227FILE_UPLOAD_TEMP_DIR = None
228FIRST_DAY_OF_WEEK = 0
229FIXTURE_DIRS = []
230FORCE_SCRIPT_NAME = None
231FORMAT_MODULE_PATH = None
232IGNORABLE_404_URLS = []
233INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrapform', 'rest_framework', 'rest_framework.authtoken', 'website', 'applications']
234INTERNAL_IPS = []
235LANGUAGES = [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')]
236LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
237LANGUAGE_CODE = 'en-us'
238LANGUAGE_COOKIE_AGE = None
239LANGUAGE_COOKIE_DOMAIN = None
240LANGUAGE_COOKIE_NAME = 'django_language'
241LANGUAGE_COOKIE_PATH = '/'
242LOCALE_PATHS = []
243LOGGING = {'disable_existing_loggers': False, 'version': 1, 'loggers': {'django': {'level': 'INFO', 'handlers': ['console']}}, 'handlers': {'console': {'class': 'logging.StreamHandler'}}}
244LOGGING_CONFIG = 'logging.config.dictConfig'
245LOGIN_REDIRECT_URL = '/accounts/profile/'
246LOGIN_URL = '/accounts/login/'
247LOGOUT_REDIRECT_URL = None
248MAILGUN_ACCESS_KEY = '********************'
249MAILGUN_SERVER_NAME = ''
250MANAGERS = []
251MEDIA_ROOT = ''
252MEDIA_URL = ''
253MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
254MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware']
255MIDDLEWARE_CLASSES = ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware']
256MIGRATION_MODULES = {}
257MONTH_DAY_FORMAT = 'F j'
258NUMBER_GROUPING = 0
259PASSWORD_HASHERS = '********************'
260PASSWORD_RESET_TIMEOUT_DAYS = '********************'
261PREPEND_WWW = False
262REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication', 'rest_framework.authentication.BasicAuthentication'), 'DEFAULT_PARSER_CLASSES': ('rest_framework.parsers.JSONParser',)}
263ROOT_URLCONF = 'zeroth.urls'
264SECRET_KEY = '********************'
265SECURE_BROWSER_XSS_FILTER = False
266SECURE_CONTENT_TYPE_NOSNIFF = False
267SECURE_HSTS_INCLUDE_SUBDOMAINS = False
268SECURE_HSTS_SECONDS = 0
269SECURE_PROXY_SSL_HEADER = None
270SECURE_REDIRECT_EXEMPT = []
271SECURE_SSL_HOST = None
272SECURE_SSL_REDIRECT = False
273SERVER_EMAIL = 'root@localhost'
274SESSION_CACHE_ALIAS = 'default'
275SESSION_COOKIE_AGE = 1209600
276SESSION_COOKIE_DOMAIN = None
277SESSION_COOKIE_HTTPONLY = True
278SESSION_COOKIE_NAME = 'sessionid'
279SESSION_COOKIE_PATH = '/'
280SESSION_COOKIE_SECURE = False
281SESSION_ENGINE = 'django.contrib.sessions.backends.db'
282SESSION_EXPIRE_AT_BROWSER_CLOSE = False
283SESSION_FILE_PATH = None
284SESSION_SAVE_EVERY_REQUEST = False
285SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
286SETTINGS_MODULE = 'zeroth.settings'
287SHORT_DATETIME_FORMAT = 'm/d/Y P'
288SHORT_DATE_FORMAT = 'm/d/Y'
289SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
290SILENCED_SYSTEM_CHECKS = []
291STATICFILES_DIRS = []
292STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
293STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
294STATIC_ROOT = '/app/../static'
295STATIC_URL = '/static/'
296TEMPLATES = [{'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}, 'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': []}]
297TEST_NON_SERIALIZED_APPS = []
298TEST_RUNNER = 'django.test.runner.DiscoverRunner'
299THOUSAND_SEPARATOR = ','
300TIME_FORMAT = 'P'
301TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
302TIME_ZONE = 'UTC'
303USE_ETAGS = False
304USE_I18N = True
305USE_L10N = True
306USE_THOUSAND_SEPARATOR = False
307USE_TZ = True
308USE_X_FORWARDED_HOST = False
309USE_X_FORWARDED_PORT = False
310WSGI_APPLICATION = 'zeroth.wsgi.application'
311X_FRAME_OPTIONS = 'SAMEORIGIN'
312YEAR_MONTH_FORMAT = 'F Y'
313
314
315You're seeing this error because you have DEBUG = True in your
316Django settings file. Change that to False, and Django will
317display a standard page generated by the handler for this status code.