· 6 years ago · May 31, 2019, 03:46 PM
1IntegrityError at /api/v1/school/school/
2duplicate key value violates unique constraint "school_group_pkey"
3DETAIL: Key (id)=(8) already exists.
4
5
6Request Method: POST
7Request URL: http://api-staging.kitabuli.de/api/v1/school/school/
8Django Version: 2.2.1
9Python Executable: /opt/python/run/venv/bin/python3
10Python Version: 3.6.8
11Python Path: ['/opt/python/current/app', '', '/opt/python/run/venv/local/lib64/python3.6/site-packages', '/opt/python/run/venv/local/lib/python3.6/site-packages', '/opt/python/run/venv/lib64/python3.6', '/opt/python/run/venv/lib/python3.6', '/opt/python/run/venv/lib64/python3.6/site-packages', '/opt/python/run/venv/lib/python3.6/site-packages', '/opt/python/run/venv/lib64/python3.6/lib-dynload', '/usr/lib64/python3.6', '/usr/lib/python3.6']
12Server time: Fri, 31 May 2019 15:42:30 +0000
13Installed Applications:
14['jet',
15 'django.contrib.admin',
16 'django.contrib.auth',
17 'django.contrib.contenttypes',
18 'django.contrib.sessions',
19 'django.contrib.messages',
20 'django.contrib.staticfiles',
21 'corsheaders',
22 'rest_framework',
23 'django_filters',
24 'apps.account',
25 'apps.company',
26 'apps.school',
27 'apps.child',
28 'drf_yasg']
29Installed Middleware:
30['django.middleware.security.SecurityMiddleware',
31 'django.middleware.gzip.GZipMiddleware',
32 'django.contrib.sessions.middleware.SessionMiddleware',
33 'corsheaders.middleware.CorsMiddleware',
34 'django.middleware.common.CommonMiddleware',
35 'django.middleware.csrf.CsrfViewMiddleware',
36 'django.contrib.auth.middleware.AuthenticationMiddleware',
37 'django.contrib.messages.middleware.MessageMiddleware',
38 'django.middleware.clickjacking.XFrameOptionsMiddleware',
39 'apps.common.middleware.AdminLocaleMiddleware',
40 'apps.common.middleware.SchoolMiddleware']
41
42
43Traceback:
44
45File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
46 84. return self.cursor.execute(sql, params)
47
48The above exception (duplicate key value violates unique constraint "school_group_pkey"
49DETAIL: Key (id)=(8) already exists.
50) was the direct cause of the following exception:
51
52File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
53 34. response = get_response(request)
54
55File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
56 115. response = self.process_exception_by_middleware(e, request)
57
58File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
59 113. response = wrapped_callback(request, *callback_args, **callback_kwargs)
60
61File "/usr/lib64/python3.6/contextlib.py" in inner
62 52. return func(*args, **kwds)
63
64File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
65 54. return view_func(*args, **kwargs)
66
67File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/viewsets.py" in view
68 116. return self.dispatch(request, *args, **kwargs)
69
70File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
71 495. response = self.handle_exception(exc)
72
73File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
74 455. self.raise_uncaught_exception(exc)
75
76File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
77 492. response = handler(request, *args, **kwargs)
78
79File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/mixins.py" in create
80 21. self.perform_create(serializer)
81
82File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/mixins.py" in perform_create
83 26. serializer.save()
84
85File "/opt/python/run/venv/local/lib/python3.6/site-packages/rest_framework/serializers.py" in save
86 214. self.instance = self.create(validated_data)
87
88File "/opt/python/current/app/apps/school/serializers.py" in create
89 132. for group_data in groups
90
91File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method
92 82. return getattr(self.get_queryset(), name)(*args, **kwargs)
93
94File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/query.py" in bulk_create
95 468. self._batched_insert(objs_with_pk, fields, batch_size, ignore_conflicts=ignore_conflicts)
96
97File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/query.py" in _batched_insert
98 1204. ignore_conflicts=ignore_conflicts,
99
100File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/query.py" in _insert
101 1186. return query.get_compiler(using=using).execute_sql(return_id)
102
103File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
104 1335. cursor.execute(sql, params)
105
106File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
107 99. return super().execute(sql, params)
108
109File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
110 67. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
111
112File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
113 76. return executor(sql, params, many, context)
114
115File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
116 84. return self.cursor.execute(sql, params)
117
118File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
119 89. raise dj_exc_value.with_traceback(traceback) from exc_value
120
121File "/opt/python/run/venv/local/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute
122 84. return self.cursor.execute(sql, params)
123
124Exception Type: IntegrityError at /api/v1/school/school/
125Exception Value: duplicate key value violates unique constraint "school_group_pkey"
126DETAIL: Key (id)=(8) already exists.
127
128Request information:
129USER: mirzadelic1@gmail.com
130
131GET: No GET data
132
133POST: No POST data
134
135FILES: No FILES data
136
137COOKIES: No cookie data
138
139META:
140CONTENT_LENGTH = '1583'
141CONTENT_TYPE = 'application/json;charset=UTF-8'
142CONTEXT_DOCUMENT_ROOT = '/var/www/html'
143CONTEXT_PREFIX = ''
144DOCUMENT_ROOT = '/var/www/html'
145GATEWAY_INTERFACE = 'CGI/1.1'
146HTTP_ACCEPT = 'application/json, text/plain, */*'
147HTTP_ACCEPT_ENCODING = 'gzip, deflate'
148HTTP_ACCEPT_LANGUAGE = 'sr-RS,sr;q=0.9,en-US;q=0.8,en;q=0.7,bg;q=0.6,bs;q=0.5,de;q=0.4,es;q=0.3,fr;q=0.2,hr;q=0.1,hu;q=0.1,it;q=0.1,lt;q=0.1,mk;q=0.1,pl;q=0.1,ru;q=0.1,sl;q=0.1,sq;q=0.1,tr;q=0.1,zh-TW;q=0.1,zh;q=0.1'
149HTTP_AUTHORIZATION = 'JWT eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VybmFtZSI6Im1pcnphZGVsaWMxQGdtYWlsLmNvbSIsImV4cCI6MTU1OTI1NTE5NCwiZW1haWwiOiJtaXJ6YWRlbGljMUBnbWFpbC5jb20ifQ.RdryvlOx5-hBztiXeJtyVNvzwMNfr1mBWwS2y_T15C8'
150HTTP_CONNECTION = 'keep-alive'
151HTTP_HOST = 'api-staging.kitabuli.de'
152HTTP_ORIGIN = 'http://localhost:3000'
153HTTP_REFERER = 'http://localhost:3000/schools/school/16'
154HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36'
155PATH_INFO = '/api/v1/school/school/'
156PATH_TRANSLATED = '/opt/python/current/app/kitabuli/wsgi.py/api/v1/school/school/'
157QUERY_STRING = ''
158REMOTE_ADDR = '109.245.39.126'
159REMOTE_PORT = '15667'
160REQUEST_METHOD = 'POST'
161REQUEST_SCHEME = 'http'
162REQUEST_URI = '/api/v1/school/school/'
163SCRIPT_FILENAME = '/opt/python/current/app/kitabuli/wsgi.py'
164SCRIPT_NAME = ''
165SERVER_ADDR = '172.31.43.172'
166SERVER_ADMIN = 'root@localhost'
167SERVER_NAME = 'api-staging.kitabuli.de'
168SERVER_PORT = '80'
169SERVER_PROTOCOL = 'HTTP/1.1'
170SERVER_SIGNATURE = ''
171SERVER_SOFTWARE = 'Apache/2.4.39 (Amazon) mod_wsgi/3.5 Python/3.6.8'
172mod_wsgi.application_group = 'ip-172-31-43-172.eu-central-1.compute.internal|'
173mod_wsgi.callable_object = 'application'
174mod_wsgi.enable_sendfile = '0'
175mod_wsgi.handler_script = ''
176mod_wsgi.input_chunked = '0'
177mod_wsgi.listener_host = ''
178mod_wsgi.listener_port = '80'
179mod_wsgi.process_group = 'wsgi'
180mod_wsgi.queue_start = '1559317350652682'
181mod_wsgi.request_handler = 'wsgi-script'
182mod_wsgi.script_reloading = '1'
183mod_wsgi.version = '(3, 5)'
184wsgi.errors = <_io.TextIOWrapper encoding='utf-8'>
185wsgi.file_wrapper = ''
186wsgi.input = <mod_wsgi.Input object at 0x7f44919baeb0>
187wsgi.multiprocess = True
188wsgi.multithread = True
189wsgi.run_once = False
190wsgi.url_scheme = 'http'
191wsgi.version = '(1, 0)'
192
193Settings:
194Using settings module kitabuli.settings
195ABSOLUTE_URL_OVERRIDES = {}
196ADMINS = []
197ALLOWED_HOSTS = ['*']
198API_URL = '********************'
199APPEND_SLASH = True
200AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
201AUTH_PASSWORD_VALIDATORS = '********************'
202AUTH_USER_MODEL = 'account.User'
203BASE_DIR = '/opt/python/current/app'
204CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
205CACHE_MIDDLEWARE_ALIAS = 'default'
206CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
207CACHE_MIDDLEWARE_SECONDS = 600
208CORS_ORIGIN_ALLOW_ALL = True
209CSRF_COOKIE_AGE = 31449600
210CSRF_COOKIE_DOMAIN = None
211CSRF_COOKIE_HTTPONLY = False
212CSRF_COOKIE_NAME = 'csrftoken'
213CSRF_COOKIE_PATH = '/'
214CSRF_COOKIE_SAMESITE = 'Lax'
215CSRF_COOKIE_SECURE = False
216CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
217CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
218CSRF_TRUSTED_ORIGINS = []
219CSRF_USE_SESSIONS = False
220DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql', 'NAME': 'ebdb', 'USER': 'kitabuli', 'PASSWORD': '********************', 'HOST': 'aa94cx2halyypy.cb8nmnggwaqh.eu-central-1.rds.amazonaws.com', 'PORT': '5432', 'ATOMIC_REQUESTS': True, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
221DATABASE_ROUTERS = []
222DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
223DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
224DATETIME_FORMAT = 'N j, Y, P'
225DATETIME_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']
226DATE_FORMAT = 'N j, Y'
227DATE_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']
228DEBUG = True
229DEBUG_PROPAGATE_EXCEPTIONS = False
230DECIMAL_SEPARATOR = '.'
231DEFAULT_CHARSET = 'utf-8'
232DEFAULT_CONTENT_TYPE = 'text/html'
233DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
234DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
235DEFAULT_FROM_EMAIL = 'no-reply@kitabuli.de'
236DEFAULT_INDEX_TABLESPACE = ''
237DEFAULT_TABLESPACE = ''
238DISALLOWED_USER_AGENTS = []
239DJANGO_ENV_HOSTS = '*'
240EMAIL_BACKEND = 'sendgrid_backend.SendgridBackend'
241EMAIL_HOST = 'localhost'
242EMAIL_HOST_PASSWORD = '********************'
243EMAIL_HOST_USER = ''
244EMAIL_PORT = 25
245EMAIL_SSL_CERTFILE = None
246EMAIL_SSL_KEYFILE = '********************'
247EMAIL_SUBJECT_PREFIX = '[Django] '
248EMAIL_TIMEOUT = None
249EMAIL_USE_LOCALTIME = False
250EMAIL_USE_SSL = False
251EMAIL_USE_TLS = False
252FILE_CHARSET = 'utf-8'
253FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
254FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
255FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
256FILE_UPLOAD_PERMISSIONS = None
257FILE_UPLOAD_TEMP_DIR = None
258FIRST_DAY_OF_WEEK = 0
259FIXTURE_DIRS = "('/opt/python/current/app/fixtures',)"
260FORCE_SCRIPT_NAME = None
261FORMAT_MODULE_PATH = None
262FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
263IGNORABLE_404_URLS = []
264INSTALLED_APPS = ['jet', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'corsheaders', 'rest_framework', 'django_filters', 'apps.account', 'apps.company', 'apps.school', 'apps.child', 'drf_yasg']
265INTERNAL_IPS = []
266JET_CHANGE_FORM_SIBLING_LINKS = False
267JET_DEFAULT_THEME = 'light-gray'
268JET_SIDE_MENU_COMPACT = True
269JWT_AUTH = {'JWT_VERIFY_EXPIRATION': False, 'JWT_RESPONSE_PAYLOAD_HANDLER': 'apps.account.utils.user_jwt_response_payload_handler'}
270LANGUAGES = "(('en-us', 'English'), ('de-de', 'German'))"
271LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
272LANGUAGE_CODE = 'en-us'
273LANGUAGE_COOKIE_AGE = None
274LANGUAGE_COOKIE_DOMAIN = None
275LANGUAGE_COOKIE_NAME = 'django_language'
276LANGUAGE_COOKIE_PATH = '/'
277LOCALE_PATHS = "('/opt/python/current/app/kitabuli/locale',)"
278LOGGING = {}
279LOGGING_CONFIG = 'logging.config.dictConfig'
280LOGIN_REDIRECT_URL = '/accounts/profile/'
281LOGIN_URL = '/accounts/login/'
282LOGOUT_REDIRECT_URL = None
283MANAGERS = []
284MEDIA_ROOT = 'media'
285MEDIA_URL = '/media/'
286MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
287MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', 'django.middleware.gzip.GZipMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'apps.common.middleware.AdminLocaleMiddleware', 'apps.common.middleware.SchoolMiddleware']
288MIGRATION_MODULES = {}
289MONTH_DAY_FORMAT = 'F j'
290NUMBER_GROUPING = 0
291PASSWORD_HASHERS = '********************'
292PASSWORD_RESET_TIMEOUT_DAYS = '********************'
293PREPEND_WWW = False
294REST_FRAMEWORK = {'DATETIME_FORMAT': '%Y-%m-%dT%H:%M:%S', 'TEST_REQUEST_DEFAULT_FORMAT': 'json', 'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAuthenticated', 'apps.account.permissions.UserPermission'), 'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework_jwt.authentication.JSONWebTokenAuthentication',), 'DEFAULT_FILTER_BACKENDS': ('django_filters.rest_framework.DjangoFilterBackend', 'rest_framework.filters.OrderingFilter'), 'DEFAULT_PAGINATION_CLASS': 'apps.common.pagination.CustomPageNumberPagination', 'PAGE_SIZE': 15}
295ROOT_URLCONF = 'kitabuli.urls'
296SECRET_KEY = '********************'
297SECURE_BROWSER_XSS_FILTER = False
298SECURE_CONTENT_TYPE_NOSNIFF = False
299SECURE_HSTS_INCLUDE_SUBDOMAINS = False
300SECURE_HSTS_PRELOAD = False
301SECURE_HSTS_SECONDS = 0
302SECURE_PROXY_SSL_HEADER = None
303SECURE_REDIRECT_EXEMPT = []
304SECURE_SSL_HOST = None
305SECURE_SSL_REDIRECT = False
306SENDGRID_API_KEY = '********************'
307SENDGRID_SANDBOX_MODE_IN_DEBUG = False
308SERVER_EMAIL = 'admin@kitabuli.de'
309SESSION_CACHE_ALIAS = 'default'
310SESSION_COOKIE_AGE = 1209600
311SESSION_COOKIE_DOMAIN = None
312SESSION_COOKIE_HTTPONLY = True
313SESSION_COOKIE_NAME = 'sessionid'
314SESSION_COOKIE_PATH = '/'
315SESSION_COOKIE_SAMESITE = 'Lax'
316SESSION_COOKIE_SECURE = False
317SESSION_ENGINE = 'django.contrib.sessions.backends.db'
318SESSION_EXPIRE_AT_BROWSER_CLOSE = False
319SESSION_FILE_PATH = None
320SESSION_SAVE_EVERY_REQUEST = False
321SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
322SETTINGS_MODULE = 'kitabuli.settings'
323SHORT_DATETIME_FORMAT = 'm/d/Y P'
324SHORT_DATE_FORMAT = 'm/d/Y'
325SHOW_IN_PERMISSION_APPS = ['account', 'company', 'school', 'child']
326SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
327SILENCED_SYSTEM_CHECKS = []
328STATICFILES_DIRS = []
329STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
330STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
331STATIC_ROOT = 'static'
332STATIC_URL = '/static/'
333SWAGGER_SETTINGS = {'USE_SESSION_AUTH': False, 'DEFAULT_MODEL_RENDERING': 'example', 'DEFAULT_MODEL_DEPTH': 0, 'SECURITY_DEFINITIONS': {'api_key': '********************'}}
334TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/opt/python/current/app/kitabuli/templates'], 'APP_DIRS': True, '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']}}]
335TEST_NON_SERIALIZED_APPS = []
336TEST_RUNNER = 'django.test.runner.DiscoverRunner'
337THOUSAND_SEPARATOR = ','
338TIME_FORMAT = 'P'
339TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
340TIME_ZONE = 'UTC'
341TRIAL_DAYS = 14
342USE_I18N = False
343USE_L10N = True
344USE_THOUSAND_SEPARATOR = False
345USE_TZ = False
346USE_X_FORWARDED_HOST = False
347USE_X_FORWARDED_PORT = False
348WEB_URL = 'http://app-staging.kitabuli.de/'
349WSGI_APPLICATION = 'kitabuli.wsgi.application'
350X_FRAME_OPTIONS = 'SAMEORIGIN'
351YEAR_MONTH_FORMAT = 'F Y'
352
353
354You're seeing this error because you have DEBUG = True in your
355Django settings file. Change that to False, and Django will
356display a standard page generated by the handler for this status code.