System stops responding for a minute every 10 minutes or so [Solved]
Here is the output of
docker logs -f
common.middleware.error_logging <10582> [ERROR] "process_exception() line 17 Exception caught by request middleware; <WSGIRequest: GET '/authentication/login/'>, FATAL: sorry, too many clients already
"
Traceback (most recent call last):
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 215, in _get_response
response = response.render()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/response.py", line 107, in render
self.content = self.rendered_content
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/response.py", line 84, in rendered_content
content = template.render(context, self._request)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/backends/django.py", line 66, in render
return self.template.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 207, in render
return self._render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 199, in _render
return self.nodelist.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 990, in render
bit = node.render_annotated(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 957, in render_annotated
return self.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 177, in render
return compiled_parent._render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 199, in _render
return self.nodelist.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 990, in render
bit = node.render_annotated(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 957, in render_annotated
return self.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/defaulttags.py", line 411, in render
return strip_spaces_between_tags(self.nodelist.render(context).strip())
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 990, in render
bit = node.render_annotated(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 957, in render_annotated
return self.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/loader_tags.py", line 72, in render
result = block.nodelist.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 990, in render
bit = node.render_annotated(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/base.py", line 957, in render_annotated
return self.render(context)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/template/library.py", line 203, in render
output = self.func(*resolved_args, **resolved_kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/autoadmin/templatetags/autoadmin_tags.py", line 13, in autoadmin_properties
context['autoadmin_properties'] = AutoAdminSingleton.objects.get()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 374, in get
num = len(clone)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 1121, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 887, in execute_sql
cursor = self.connection.cursor()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
OperationalError: FATAL: sorry, too many clients already
[2019-06-13 18:26:58 +0000] [10582] [INFO] Autorestarting worker after current request.
[2019-06-13 18:27:00 +0000] [10582] [INFO] Worker exiting (pid: 10582)
[2019-06-13 18:27:00 +0000] [10658] [INFO] Booting worker with pid: 10658
[2019-06-13 18:28:07 +0000] [10578] [INFO] Autorestarting worker after current request.
[2019-06-13 18:28:10 +0000] [10578] [INFO] Worker exiting (pid: 10578)
[2019-06-13 18:28:10 +0000] [10664] [INFO] Booting worker with pid: 10664
common.middleware.error_logging <10658> [ERROR] "process_exception() line 17 Exception caught by request middleware; <WSGIRequest: GET '/documents/list/recent_added/'>, Cannot filter a query once a slice has been taken."
Traceback (most recent call last):
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/views/generic/base.py", line 68, in view
return self.dispatch(request, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/mixins.py", line 345, in dispatch
).dispatch(request, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/mixins.py", line 237, in dispatch
return super(ObjectListPermissionFilterMixin, self).dispatch(request, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/mixins.py", line 310, in dispatch
).dispatch(request, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/views/generic/base.py", line 88, in dispatch
return handler(request, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/views/generic/list.py", line 160, in get
self.object_list = self.get_queryset()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/generics.py", line 506, in get_queryset
return super(SingleObjectListView, self).get_queryset()
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/mixins.py", line 244, in get_queryset
self.object_permission, self.request.user, queryset=queryset
File "/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/acls/managers.py", line 189, in filter_by_access
return queryset.filter(parent_acl_query | acl_query)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 787, in filter
return self._filter_or_exclude(False, *args, **kwargs)
File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/models/query.py", line 799, in _filter_or_exclude
"Cannot filter a query once a slice has been taken."
AssertionError: Cannot filter a query once a slice has been taken.
Edited by Vikas Kedia