sregistry
sregistry copied to clipboard
singularityhub
Database connection isn't set to UTC
Describe the bug Commit #f41371a
Accessing the home page of the server results in an error
uwsgi_1 | Internal Server Error: /
uwsgi_1 | Traceback (most recent call last):
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/sessions/backends/base.py", line 189, in _get_session
uwsgi_1 | return self._session_cache
uwsgi_1 | AttributeError: 'SessionStore' object has no attribute '_session_cache'
uwsgi_1 |
uwsgi_1 | During handling of the above exception, another exception occurred:
uwsgi_1 |
uwsgi_1 | Traceback (most recent call last):
nginx_1 | 131.181.240.91 - - [22/Jul/2021:23:24:04 +0000] "GET / HTTP/1.1" 500 850 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36 Edg/91.0.864.71" "-"
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
uwsgi_1 | response = get_response(request)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
uwsgi_1 | response = self.process_exception_by_middleware(e, request)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
uwsgi_1 | response = wrapped_callback(request, *callback_args, **callback_kwargs)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/ratelimit/decorators.py", line 30, in _wrapped
uwsgi_1 | return fn(*args, **kw)
uwsgi_1 | File "./shub/apps/base/views/main.py", line 24, in index_view
uwsgi_1 | return render(request, "main/index.html")
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/shortcuts.py", line 36, in render
uwsgi_1 | content = loader.render_to_string(template_name, context, request, using=using)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/loader.py", line 62, in render_to_string
uwsgi_1 | return template.render(context, request)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/backends/django.py", line 61, in render
uwsgi_1 | return self.template.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 171, in render
uwsgi_1 | return self._render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
uwsgi_1 | return self.nodelist.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
uwsgi_1 | bit = node.render_annotated(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
uwsgi_1 | return self.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 150, in render
uwsgi_1 | return compiled_parent._render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
uwsgi_1 | return self.nodelist.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
uwsgi_1 | bit = node.render_annotated(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
uwsgi_1 | return self.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 62, in render
uwsgi_1 | result = block.nodelist.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
uwsgi_1 | bit = node.render_annotated(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
uwsgi_1 | return self.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/loader_tags.py", line 188, in render
uwsgi_1 | return template.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 173, in render
uwsgi_1 | return self._render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 163, in _render
uwsgi_1 | return self.nodelist.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 937, in render
uwsgi_1 | bit = node.render_annotated(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 904, in render_annotated
uwsgi_1 | return self.render(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 302, in render
uwsgi_1 | match = condition.eval(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/defaulttags.py", line 876, in eval
uwsgi_1 | return self.value.resolve(context, ignore_failures=True)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 671, in resolve
uwsgi_1 | obj = self.var.resolve(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 796, in resolve
uwsgi_1 | value = self._resolve_lookup(context)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/template/base.py", line 829, in _resolve_lookup
uwsgi_1 | current = current[bit]
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/utils/functional.py", line 256, in inner
uwsgi_1 | self._setup()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/utils/functional.py", line 392, in _setup
uwsgi_1 | self._wrapped = self._setupfunc()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/middleware.py", line 24, in <lambda>
uwsgi_1 | request.user = SimpleLazyObject(lambda: get_user(request))
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/middleware.py", line 12, in get_user
uwsgi_1 | request._cached_user = auth.get_user(request)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/__init__.py", line 182, in get_user
uwsgi_1 | user_id = _get_user_session_key(request)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/__init__.py", line 59, in _get_user_session_key
uwsgi_1 | return get_user_model()._meta.pk.to_python(request.session[SESSION_KEY])
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/sessions/backends/base.py", line 54, in __getitem__
uwsgi_1 | return self._session[key]
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/sessions/backends/base.py", line 194, in _get_session
uwsgi_1 | self._session_cache = self.load()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/sessions/backends/db.py", line 43, in load
uwsgi_1 | s = self._get_session_from_db()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/contrib/sessions/backends/db.py", line 34, in _get_session_from_db
uwsgi_1 | expire_date__gt=timezone.now()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method
uwsgi_1 | return getattr(self.get_queryset(), name)(*args, **kwargs)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 402, in get
uwsgi_1 | num = len(clone)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 256, in __len__
uwsgi_1 | self._fetch_all()
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 1242, in _fetch_all
uwsgi_1 | self._result_cache = list(self._iterable_class(self))
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 55, in __iter__
uwsgi_1 | results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
uwsgi_1 | return list(result)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1554, in cursor_iter
uwsgi_1 | for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1554, in <lambda>
uwsgi_1 | for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line 96, in inner
uwsgi_1 | return func(*args, **kwargs)
uwsgi_1 | File "/usr/local/lib/python3.6/site-packages/django/db/backends/postgresql/utils.py", line 6, in utc_tzinfo_factory
uwsgi_1 | raise AssertionError("database connection isn't set to UTC")
uwsgi_1 | AssertionError: database connection isn't set to UTC
To Reproduce Deploy Commit #f41371a and access home page
Expected behavior The home page is displayed without error.
This looks like a relatively new error, and it results from the pyscogp2-binary:
https://stackoverflow.com/questions/38807296/django-1-9-2-assertionerror-database-connection-isnt-set-to-utc So I think you can set USE_TZ to False or pin that version. Oup you have a PR - maybe you've already figured this out! :laughing:
