Problem z rejestracją użytkowników na środowisku produkcyjnym

szymonsiecinski commented 7 years ago

Po zatwierdzeniu formularza rejestracji (z podanym loginem i hasłem) pojawia się błąd

IntegrityError at /register

duplicate key value violates unique constraint "auth_user_username_key" DETAIL: Key (username)=(trabis) already exists.

Request Method: POST Request URL: https://django-tasklist.herokuapp.com/register Django Version: 1.11.1 Exception Type: IntegrityError Exception Value:

duplicate key value violates unique constraint "auth_user_username_key" DETAIL: Key (username)=(trabis) already exists.

Exception Location: /app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py in execute, line 65 Python Executable: /app/.heroku/python/bin/python Python Version: 3.6.1 Python Path:

['/app', '/app/.heroku/python/bin', '/app', '/app/.heroku/python/lib/python36.zip', '/app/.heroku/python/lib/python3.6', '/app/.heroku/python/lib/python3.6/lib-dynload', '/app/.heroku/python/lib/python3.6/site-packages']

Server time: Czw, 18 Maj 2017 13:57:36 +0000 Traceback Switch to copy-and-paste view

/app/TaskList/auth_views.py in form_valid

                User.objects.get(username__exact=form_data['username'])

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/manager.py in manager_method

                    return getattr(self.get_queryset(), name)(*args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py in get

                    self.model._meta.object_name

     ...
▶ Local vars
During handling of the above exception (User matching query does not exist.), another exception occurred:
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py in execute

                    return self.cursor.execute(sql, params)

     ...
▶ Local vars
The above exception (duplicate key value violates unique constraint "auth_user_username_key" DETAIL: Key (username)=(trabis) already exists. ) was the direct cause of the following exception:
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/exception.py in inner

                response = get_response(request)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py in _legacy_get_response

                response = self._get_response(request)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py in _get_response

                    response = self.process_exception_by_middleware(e, request)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/core/handlers/base.py in _get_response

                    response = wrapped_callback(request, *callback_args, **callback_kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/base.py in view

                return self.dispatch(request, *args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/base.py in dispatch

            return handler(request, *args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/edit.py in post

            return super(BaseCreateView, self).post(request, *args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/edit.py in post

                return self.form_valid(form)

     ...
▶ Local vars
/app/TaskList/auth_views.py in form_valid

                return super(RegisterView, self).form_valid(form)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/views/generic/edit.py in form_valid

            self.object = form.save()

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/forms/models.py in save

                self.instance.save()

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/contrib/auth/base_user.py in save

            super(AbstractBaseUser, self).save(*args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py in save

                           force_update=force_update, update_fields=update_fields)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py in save_base

                updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py in _save_table

                result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/base.py in _do_insert

                                   using=using, raw=raw)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/manager.py in manager_method

                    return getattr(self.get_queryset(), name)(*args, **kwargs)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/query.py in _insert

            return query.get_compiler(using=using).execute_sql(return_id)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/models/sql/compiler.py in execute_sql

                    cursor.execute(sql, params)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py in execute

                return super(CursorDebugWrapper, self).execute(sql, params)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py in execute

                    return self.cursor.execute(sql, params)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/utils.py in __exit__

                    six.reraise(dj_exc_type, dj_exc_value, traceback)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/utils/six.py in reraise

                raise value.with_traceback(tb)

     ...
▶ Local vars
/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/utils.py in execute

                    return self.cursor.execute(sql, params)

     ...
▶ Local vars

Request information USER

AnonymousUser GET

No GET data POST Variable Value csrfmiddlewaretoken

'RA8Q7JIpFQosTe1KcglGXaOCnNdVZseICAyschC3ADaLJlEhO1v4TUk2WiZObJOm'

username

'trabis'

password

'trabisto'

confirm_password

'trabisto'

FILES

No FILES data COOKIES Variable Value csrftoken

'0iBaNhZ8NTHNBTGm3fdpbBF898xZ1gmZLi1MSPTMIGt6r0jTF0nN7lbyIDjSdxWD'

META Variable Value CONTENT_LENGTH

'144'

CONTENT_TYPE

'application/x-www-form-urlencoded'

CSRF_COOKIE

'0iBaNhZ8NTHNBTGm3fdpbBF898xZ1gmZLi1MSPTMIGt6r0jTF0nN7lbyIDjSdxWD'

HTTP_ACCEPT

'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'

HTTP_ACCEPT_ENCODING

'gzip, deflate, br'

HTTP_ACCEPT_LANGUAGE

'en-US,en;q=0.5'

HTTP_CONNECTION

'close'

HTTP_CONNECT_TIME

'0'

HTTP_COOKIE

'csrftoken=0iBaNhZ8NTHNBTGm3fdpbBF898xZ1gmZLi1MSPTMIGt6r0jTF0nN7lbyIDjSdxWD'

HTTP_HOST

'django-tasklist.herokuapp.com'

HTTP_REFERER

'https://django-tasklist.herokuapp.com/register'

HTTP_TOTAL_ROUTE_TIME

'0'

HTTP_UPGRADE_INSECURE_REQUESTS

'1'

HTTP_USER_AGENT

'Mozilla/5.0 (X11; Linux x86_64; rv:53.0) Gecko/20100101 Firefox/53.0'

HTTP_VIA

'1.1 vegur'

HTTP_X_FORWARDED_FOR

'83.22.253.113'

HTTP_X_FORWARDED_PORT

'443'

HTTP_X_FORWARDED_PROTO

'https'

HTTP_X_REQUEST_ID

'063a8488-3d42-4f03-a835-bd4de36ec948'

HTTP_X_REQUEST_START

'1495115856115'

PATH_INFO

'/register'

QUERY_STRING

''

RAW_URI

'/register'

REMOTE_ADDR

'10.105.187.54'

REMOTE_PORT

'20813'

REQUEST_METHOD

'POST'

SCRIPT_NAME

''

SERVER_NAME

'0.0.0.0'

SERVER_PORT

'54595'

SERVER_PROTOCOL

'HTTP/1.1'

SERVER_SOFTWARE

'gunicorn/19.7.1'

gunicorn.socket

<socket.socket fd=10, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('172.18.169.214', 54595), raddr=('10.105.187.54', 20813)>

wsgi.errors

<gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f2d56ad2ac8>

wsgi.file_wrapper

''

wsgi.input

<gunicorn.http.body.Body object at 0x7f2d56ad2d68>

wsgi.multiprocess

True

wsgi.multithread

False

wsgi.run_once

False

wsgi.url_scheme

'https'

wsgi.version

(1, 0)

Settings Using settings module TaskList.settings Setting Value ABSOLUTE_URL_OVERRIDES

{}

ADMINS

[]

ALLOWED_HOSTS

['*']

APPEND_SLASH

True

AUTHENTICATION_BACKENDS

['TaskList.AuthenticationBackend.AuthenticationBackend']

AUTH_PASSWORD_VALIDATORS

'****'

AUTH_USER_MODEL

'auth.User'

BASE_DIR

'/app'

CACHES

{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}

CACHE_MIDDLEWARE_ALIAS

'default'

CACHE_MIDDLEWARE_KEY_PREFIX

'****'

CACHE_MIDDLEWARE_SECONDS

600

CSRF_COOKIE_AGE

31449600

CSRF_COOKIE_DOMAIN

None

CSRF_COOKIE_HTTPONLY

False

CSRF_COOKIE_NAME

'csrftoken'

CSRF_COOKIE_PATH

'/'

CSRF_COOKIE_SECURE

False

CSRF_FAILURE_VIEW

'django.views.csrf.csrf_failure'

CSRF_HEADER_NAME

'HTTP_X_CSRFTOKEN'

CSRF_TRUSTED_ORIGINS

[]

CSRF_USE_SESSIONS

False

DATABASES

{'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 500, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'HOST': 'ec2-54-247-166-129.eu-west-1.compute.amazonaws.com', 'NAME': 'd21kd5lf2t5t3o', 'OPTIONS': {}, 'PASSWORD': '****', 'PORT': 5432, 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'zrpidqwtwntmzm'}}

DATABASE_ROUTERS

[]

DATA_UPLOAD_MAX_MEMORY_SIZE

2621440

DATA_UPLOAD_MAX_NUMBER_FIELDS

1000

DATETIME_FORMAT

'N j, Y, P'

DATETIME_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']

DATE_FORMAT

'N j, Y'

DATE_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']

DEBUG

True

DEBUG_PROPAGATE_EXCEPTIONS

False

DECIMAL_SEPARATOR

'.'

DEFAULT_CHARSET

'utf-8'

DEFAULT_CONTENT_TYPE

'text/html'

DEFAULT_EXCEPTION_REPORTER_FILTER

'django.views.debug.SafeExceptionReporterFilter'

DEFAULT_FILE_STORAGE

'django.core.files.storage.FileSystemStorage'

DEFAULT_FROM_EMAIL

'webmaster@localhost'

DEFAULT_INDEX_TABLESPACE

''

DEFAULT_TABLESPACE

''

DISALLOWED_USER_AGENTS

[]

EMAIL_BACKEND

'django.core.mail.backends.smtp.EmailBackend'

EMAIL_HOST

'localhost'

EMAIL_HOST_PASSWORD

'****'

EMAIL_HOST_USER

''

EMAIL_PORT

25

EMAIL_SSL_CERTFILE

None

EMAIL_SSL_KEYFILE

'****'

EMAIL_SUBJECT_PREFIX

'[Django] '

EMAIL_TIMEOUT

None

EMAIL_USE_LOCALTIME

False

EMAIL_USE_SSL

False

EMAIL_USE_TLS

False

FILE_CHARSET

'utf-8'

FILE_UPLOAD_DIRECTORY_PERMISSIONS

None

FILE_UPLOAD_HANDLERS

['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']

FILE_UPLOAD_MAX_MEMORY_SIZE

2621440

FILE_UPLOAD_PERMISSIONS

None

FILE_UPLOAD_TEMP_DIR

None

FIRST_DAY_OF_WEEK

0

FIXTURE_DIRS

[]

FORCE_SCRIPT_NAME

None

FORMAT_MODULE_PATH

None

FORM_RENDERER

'django.forms.renderers.DjangoTemplates'

IGNORABLE_404_URLS

[]

INSTALLED_APPS

['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrapform', 'datetimewidget', 'TaskList']

INTERNAL_IPS

[]

LANGUAGES

[('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')]

LANGUAGES_BIDI

['he', 'ar', 'fa', 'ur']

LANGUAGE_CODE

'pl-pl'

LANGUAGE_COOKIE_AGE

None

LANGUAGE_COOKIE_DOMAIN

None

LANGUAGE_COOKIE_NAME

'django_language'

LANGUAGE_COOKIE_PATH

'/'

LOCALE_PATHS

[]

LOGGING

{}

LOGGING_CONFIG

'logging.config.dictConfig'

LOGIN_REDIRECT_URL

'/accounts/profile/'

LOGIN_URL

'/accounts/login/'

LOGOUT_REDIRECT_URL

None

MANAGERS

[]

MEDIA_ROOT

''

MEDIA_URL

''

MESSAGE_STORAGE

'django.contrib.messages.storage.fallback.FallbackStorage'

MIDDLEWARE

None

MIDDLEWARE_CLASSES

['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.auth.middleware.SessionAuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware']

MIGRATION_MODULES

{}

MONTH_DAY_FORMAT

'F j'

NUMBER_GROUPING

0

PASSWORD_HASHERS

'****'

PASSWORD_RESET_TIMEOUT_DAYS

'****'

PREPEND_WWW

False

ROOT_URLCONF

'TaskList.urls'

SECRET_KEY

'****'

SECURE_BROWSER_XSS_FILTER

False

SECURE_CONTENT_TYPE_NOSNIFF

False

SECURE_HSTS_INCLUDE_SUBDOMAINS

False

SECURE_HSTS_PRELOAD

False

SECURE_HSTS_SECONDS

0

SECURE_PROXY_SSL_HEADER

None

SECURE_REDIRECT_EXEMPT

[]

SECURE_SSL_HOST

None

SECURE_SSL_REDIRECT

False

SERVER_EMAIL

'root@localhost'

SESSION_CACHE_ALIAS

'default'

SESSION_COOKIE_AGE

1209600

SESSION_COOKIE_DOMAIN

None

SESSION_COOKIE_HTTPONLY

True

SESSION_COOKIE_NAME

'sessionid'

SESSION_COOKIE_PATH

'/'

SESSION_COOKIE_SECURE

False

SESSION_ENGINE

'django.contrib.sessions.backends.db'

SESSION_EXPIRE_AT_BROWSER_CLOSE

False

SESSION_FILE_PATH

None

SESSION_SAVE_EVERY_REQUEST

False

SESSION_SERIALIZER

'django.contrib.sessions.serializers.JSONSerializer'

SETTINGS_MODULE

'TaskList.settings'

SHORT_DATETIME_FORMAT

'm/d/Y P'

SHORT_DATE_FORMAT

'm/d/Y'

SIGNING_BACKEND

'django.core.signing.TimestampSigner'

SILENCED_SYSTEM_CHECKS

[]

STATICFILES_DIRS

('/app/TaskList/static',)

STATICFILES_FINDERS

['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']

STATICFILES_STORAGE

'whitenoise.django.GzipManifestStaticFilesStorage'

STATIC_ROOT

'/app/static'

STATIC_URL

'/static/'

TEMPLATES

[{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/app/templates'], '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']}}]

TEST_NON_SERIALIZED_APPS

[]

TEST_RUNNER

'django.test.runner.DiscoverRunner'

THOUSAND_SEPARATOR

','

TIME_FORMAT

'P'

TIME_INPUT_FORMATS

['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']

TIME_ZONE

'UTC'

USE_ETAGS

False

USE_I18N

True

USE_L10N

True

USE_THOUSAND_SEPARATOR

False

USE_TZ

True

USE_X_FORWARDED_HOST

False

USE_X_FORWARDED_PORT

False

WSGI_APPLICATION

'TaskList.wsgi.application'

X_FRAME_OPTIONS

'SAMEORIGIN'

YEAR_MONTH_FORMAT

'F Y'

You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard page generated by the handler for this status code.

szymonsiecinski commented 7 years ago

Zobaczymy, co da ta podpowiedź ze StackOverflow.com...

szymonsiecinski commented 7 years ago

Pomogło usunięcie nadmiarowego ograniczenia w tabeli auth_user

szymonsiecinski / tasklist

Problem z rejestracją użytkowników na środowisku produkcyjnym #4