· 6 years ago · Oct 21, 2019, 10:02 AM
1ProgrammingError at /api/v1/arrival-applications/
2relation "arrival_applications" does not exist
3LINE 1: ...UNT("deliveries"."id") AS "deliveries_count" FROM "arrival_a...
4 ^
5
6
7Request Method: GET
8Request URL: http://warehouse:8000/api/v1/arrival-applications/
9Django Version: 2.2.6
10Python Executable: /usr/local/bin/python
11Python Version: 3.7.2
12Python Path: ['/src', '/usr/local/bin', '/usr/local/lib/python37.zip', '/usr/local/lib/python3.7', '/usr/local/lib/python3.7/lib-dynload', '/usr/local/lib/python3.7/site-packages']
13Server time: Пн, 21 Окт 2019 09:58:46 +0000
14Installed Applications:
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 'rest_framework',
22 'django_filters',
23 'drf_yasg',
24 'warehouse.items',
25 'warehouse.orders',
26 'warehouse.structures',
27 'warehouse.logistics']
28Installed Middleware:
29['django.middleware.security.SecurityMiddleware',
30 'django.contrib.sessions.middleware.SessionMiddleware',
31 'django.middleware.common.CommonMiddleware',
32 'django.middleware.csrf.CsrfViewMiddleware',
33 'django.contrib.auth.middleware.AuthenticationMiddleware',
34 'django.contrib.messages.middleware.MessageMiddleware',
35 'django.middleware.clickjacking.XFrameOptionsMiddleware',
36 'pyinstrument.middleware.ProfilerMiddleware']
37
38
39Traceback:
40
41File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
42 84. return self.cursor.execute(sql, params)
43
44The above exception (relation "arrival_applications" does not exist
45LINE 1: ...UNT("deliveries"."id") AS "deliveries_count" FROM "arrival_a...
46 ^
47) was the direct cause of the following exception:
48
49File "/usr/local/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
50 34. response = get_response(request)
51
52File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
53 115. response = self.process_exception_by_middleware(e, request)
54
55File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
56 113. response = wrapped_callback(request, *callback_args, **callback_kwargs)
57
58File "/usr/local/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
59 54. return view_func(*args, **kwargs)
60
61File "/usr/local/lib/python3.7/site-packages/rest_framework/viewsets.py" in view
62 114. return self.dispatch(request, *args, **kwargs)
63
64File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
65 497. response = self.handle_exception(exc)
66
67File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
68 457. self.raise_uncaught_exception(exc)
69
70File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in raise_uncaught_exception
71 468. raise exc
72
73File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
74 494. response = handler(request, *args, **kwargs)
75
76File "/src/warehouse/logistics/views.py" in list
77 36. return super().list(request, *args, **kwargs)
78
79File "/usr/local/lib/python3.7/site-packages/rest_framework/mixins.py" in list
80 40. page = self.paginate_queryset(queryset)
81
82File "/usr/local/lib/python3.7/site-packages/rest_framework/generics.py" in paginate_queryset
83 171. return self.paginator.paginate_queryset(queryset, self.request, view=self)
84
85File "/src/warehouse/pagination.py" in paginate_queryset
86 9. self.count = self.get_count(queryset)
87
88File "/usr/local/lib/python3.7/site-packages/rest_framework/pagination.py" in get_count
89 467. return queryset.count()
90
91File "/usr/local/lib/python3.7/site-packages/django/db/models/query.py" in count
92 392. return self.query.get_count(using=self.db)
93
94File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/query.py" in get_count
95 504. number = obj.get_aggregation(using, ['__count'])['__count']
96
97File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/query.py" in get_aggregation
98 489. result = compiler.execute_sql(SINGLE)
99
100File "/usr/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
101 1100. cursor.execute(sql, params)
102
103File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
104 99. return super().execute(sql, params)
105
106File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
107 67. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
108
109File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
110 76. return executor(sql, params, many, context)
111
112File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
113 84. return self.cursor.execute(sql, params)
114
115File "/usr/local/lib/python3.7/site-packages/django/db/utils.py" in __exit__
116 89. raise dj_exc_value.with_traceback(traceback) from exc_value
117
118File "/usr/local/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
119 84. return self.cursor.execute(sql, params)
120
121Exception Type: ProgrammingError at /api/v1/arrival-applications/
122Exception Value: relation "arrival_applications" does not exist
123LINE 1: ...UNT("deliveries"."id") AS "deliveries_count" FROM "arrival_a...
124 ^
125
126Request information:
127USER: AnonymousUser
128
129GET: No GET data
130
131POST: No POST data
132
133FILES: No FILES data
134
135COOKIES: No cookie data
136
137META:
138HTTP_ACCEPT = '*/*'
139HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
140HTTP_ACCEPT_LANGUAGE = 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7'
141HTTP_AUTHORIZATION = 'Basic cm9vdDpwYTV2dVBTZnha'
142HTTP_CACHE_CONTROL = 'no-cache'
143HTTP_CONNECTION = 'close'
144HTTP_HOST = 'warehouse:8000'
145HTTP_PRAGMA = 'no-cache'
146HTTP_REFERER = 'http://localhost:3000/orders'
147HTTP_SEC_FETCH_MODE = 'cors'
148HTTP_SEC_FETCH_SITE = 'same-origin'
149HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36'
150HTTP_VIA = '1.1 google'
151HTTP_X_CLOUD_TRACE_CONTEXT = '4eb53dc4264cbeaf99950ee0d6b42763/15677360737875390723'
152HTTP_X_COMPRESS = 'null'
153HTTP_X_FORWARDED_FOR = '141.101.202.230, 35.227.201.178, 10.12.1.1'
154HTTP_X_FORWARDED_PROTO = 'https'
155HTTP_X_REAL_IP = '10.12.1.1'
156PATH_INFO = '/api/v1/arrival-applications/'
157QUERY_STRING = ''
158RAW_URI = '/api/v1/arrival-applications/'
159REMOTE_ADDR = '10.12.1.209'
160REMOTE_PORT = '51816'
161REQUEST_METHOD = 'GET'
162SCRIPT_NAME = ''
163SERVER_NAME = '0.0.0.0'
164SERVER_PORT = '8000'
165SERVER_PROTOCOL = 'HTTP/1.0'
166SERVER_SOFTWARE = 'gunicorn/19.9.0'
167gunicorn.socket = <eventlet.greenio.base.GreenSocket object at 0x7fc43c5cde10>
168wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7fc43c578f60>
169wsgi.file_wrapper = ''
170wsgi.input = <gunicorn.http.body.Body object at 0x7fc43c578a58>
171wsgi.multiprocess = True
172wsgi.multithread = True
173wsgi.run_once = False
174wsgi.url_scheme = 'http'
175wsgi.version = '(1, 0)'
176
177Settings:
178Using settings module warehouse.settings
179ABSOLUTE_URL_OVERRIDES = {}
180ADMINS = []
181ALLOWED_HOSTS = ['warehouse', 'localhost', '127.0.0.1']
182APPEND_SLASH = True
183AUTHENTICATION_BACKENDS = ['django.contrib.auth.backends.ModelBackend']
184AUTH_PASSWORD_VALIDATORS = '********************'
185AUTH_USER_MODEL = 'auth.User'
186BASE_DIR = '/src'
187CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
188CACHE_MIDDLEWARE_ALIAS = 'default'
189CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
190CACHE_MIDDLEWARE_SECONDS = 600
191CSRF_COOKIE_AGE = 31449600
192CSRF_COOKIE_DOMAIN = None
193CSRF_COOKIE_HTTPONLY = False
194CSRF_COOKIE_NAME = 'csrftoken'
195CSRF_COOKIE_PATH = '/'
196CSRF_COOKIE_SAMESITE = 'Lax'
197CSRF_COOKIE_SECURE = False
198CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
199CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
200CSRF_TRUSTED_ORIGINS = []
201CSRF_USE_SESSIONS = False
202DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'warehouse', 'USER': 'kubernetes-dev', 'PASSWORD': '********************', 'HOST': '10.66.48.11', 'PORT': '5432', 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
203DATABASE_ROUTERS = []
204DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
205DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
206DATETIME_FORMAT = 'N j, Y, P'
207DATETIME_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']
208DATE_FORMAT = 'N j, Y'
209DATE_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']
210DEBUG = True
211DEBUG_PROPAGATE_EXCEPTIONS = False
212DEBUG_TOOLBAR = False
213DECIMAL_SEPARATOR = '.'
214DEFAULT_CHARSET = 'utf-8'
215DEFAULT_CONTENT_TYPE = 'text/html'
216DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
217DEFAULT_FILE_STORAGE = 'storages.backends.gcloud.GoogleCloudStorage'
218DEFAULT_FROM_EMAIL = 'webmaster@localhost'
219DEFAULT_INDEX_TABLESPACE = ''
220DEFAULT_SWAGGER_URL = ''
221DEFAULT_TABLESPACE = ''
222DISALLOWED_USER_AGENTS = []
223EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
224EMAIL_HOST = 'localhost'
225EMAIL_HOST_PASSWORD = '********************'
226EMAIL_HOST_USER = ''
227EMAIL_PORT = 25
228EMAIL_SSL_CERTFILE = None
229EMAIL_SSL_KEYFILE = '********************'
230EMAIL_SUBJECT_PREFIX = '[Django] '
231EMAIL_TIMEOUT = None
232EMAIL_USE_LOCALTIME = False
233EMAIL_USE_SSL = False
234EMAIL_USE_TLS = False
235FILE_CHARSET = 'utf-8'
236FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
237FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
238FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
239FILE_UPLOAD_PERMISSIONS = None
240FILE_UPLOAD_TEMP_DIR = None
241FIRST_DAY_OF_WEEK = 0
242FIXTURE_DIRS = []
243FORCE_SCRIPT_NAME = None
244FORMAT_MODULE_PATH = None
245FORM_RENDERER = 'django.forms.renderers.DjangoTemplates'
246IGNORABLE_404_URLS = []
247INSTALLED_APPS = ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'rest_framework', 'django_filters', 'drf_yasg', 'warehouse.items', 'warehouse.orders', 'warehouse.structures', 'warehouse.logistics']
248INTERNAL_IPS = []
249LANGUAGES = [('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'), ('hy', 'Armenian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('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')]
250LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
251LANGUAGE_CODE = 'ru-RU'
252LANGUAGE_COOKIE_AGE = None
253LANGUAGE_COOKIE_DOMAIN = None
254LANGUAGE_COOKIE_NAME = 'django_language'
255LANGUAGE_COOKIE_PATH = '/'
256LOCALE_PATHS = []
257LOGGING = {'version': 1, 'formatters': {'verbose': {'format': '%(asctime)s.%(msecs)03d | %(name)s | %(processName)s|%(threadName)s [%(levelname)s]: %(message)s'}}, 'handlers': {'console': {'class': 'logging.StreamHandler', 'formatter': 'verbose', 'stream': <_io.TextIOWrapper name='<stdout>' mode='w' encoding='UTF-8'>}}, 'loggers': {'django.db.backends': {'level': 'INFO', 'handlers': ['console']}, 'django': {'handlers': ['console'], 'level': 'INFO', 'propagate': False}, 'warehouse': {'level': 'DEBUG', 'handlers': ['console'], 'propagate': False}, 'django.request': {'handlers': ['console'], 'level': 'DEBUG', 'propagate': False}, 'gunicorn.access': {'level': 'DEBUG', 'handlers': ['console'], 'propagate': False}}}
258LOGGING_CONFIG = 'logging.config.dictConfig'
259LOGIN_REDIRECT_URL = '/accounts/profile/'
260LOGIN_URL = '/accounts/login/'
261LOGOUT_REDIRECT_URL = None
262LOG_LEVEL = 'DEBUG'
263MANAGERS = []
264MEDIA_ROOT = '/src/media/'
265MEDIA_URL = '/media/'
266MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
267MIDDLEWARE = ['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', 'pyinstrument.middleware.ProfilerMiddleware']
268MIGRATION_MODULES = {}
269MONTH_DAY_FORMAT = 'F j'
270NUMBER_GROUPING = 0
271PASSWORD_HASHERS = '********************'
272PASSWORD_RESET_TIMEOUT_DAYS = '********************'
273PREPEND_WWW = False
274REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.SessionAuthentication',), 'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.AllowAny',), 'TEST_REQUEST_DEFAULT_FORMAT': 'json', 'DEFAULT_FILTER_BACKENDS': ('django_filters.rest_framework.DjangoFilterBackend',), 'EXCEPTION_HANDLER': 'warehouse.rest_utils.custom_exception_handler', 'DEFAULT_PAGINATION_CLASS': 'warehouse.pagination.ForcedLimitOffsetPagination', 'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer', 'warehouse.rest_utils.BrowsableAPIRendererWithoutForms')}
275ROOT_URLCONF = 'warehouse.urls'
276SECRET_KEY = '********************'
277SECURE_BROWSER_XSS_FILTER = False
278SECURE_CONTENT_TYPE_NOSNIFF = False
279SECURE_HSTS_INCLUDE_SUBDOMAINS = False
280SECURE_HSTS_PRELOAD = False
281SECURE_HSTS_SECONDS = 0
282SECURE_PROXY_SSL_HEADER = None
283SECURE_REDIRECT_EXEMPT = []
284SECURE_SSL_HOST = None
285SECURE_SSL_REDIRECT = False
286SERVER_EMAIL = 'root@localhost'
287SESSION_CACHE_ALIAS = 'default'
288SESSION_COOKIE_AGE = 1209600
289SESSION_COOKIE_DOMAIN = None
290SESSION_COOKIE_HTTPONLY = True
291SESSION_COOKIE_NAME = 'sessionid'
292SESSION_COOKIE_PATH = '/'
293SESSION_COOKIE_SAMESITE = 'Lax'
294SESSION_COOKIE_SECURE = False
295SESSION_ENGINE = 'django.contrib.sessions.backends.db'
296SESSION_EXPIRE_AT_BROWSER_CLOSE = False
297SESSION_FILE_PATH = None
298SESSION_SAVE_EVERY_REQUEST = False
299SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
300SETTINGS_MODULE = 'warehouse.settings'
301SHORT_DATETIME_FORMAT = 'm/d/Y P'
302SHORT_DATE_FORMAT = 'm/d/Y'
303SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
304SILENCED_SYSTEM_CHECKS = []
305STATICFILES_DIRS = []
306STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
307STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
308STATIC_ROOT = '/src/static/'
309STATIC_URL = '/static/'
310TEMPLATES = [{'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], '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']}}]
311TEST_NON_SERIALIZED_APPS = []
312TEST_RUNNER = 'django.test.runner.DiscoverRunner'
313THOUSAND_SEPARATOR = ','
314TIME_FORMAT = 'P'
315TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
316TIME_ZONE = 'UTC'
317USE_I18N = True
318USE_L10N = True
319USE_THOUSAND_SEPARATOR = False
320USE_TZ = True
321USE_X_FORWARDED_HOST = False
322USE_X_FORWARDED_PORT = False
323WSGI_APPLICATION = 'warehouse.wsgi.application'
324X_FRAME_OPTIONS = 'SAMEORIGIN'
325YEAR_MONTH_FORMAT = 'F Y'
326
327
328You're seeing this error because you have DEBUG = True in your
329Django settings file. Change that to False, and Django will
330display a standard page generated by the handler for this status code.