[0.19.0-rc1] Internal Server Error: remaining connection slots are reserved for non-replication superuser connections
After succefuly upgrading from 0.18.3 to 0.19.0-rc1 everithing works fine.
Then, go to /manage/library/edits, nothing is displayed regardless of the filter.
We have this in the server logs :
2019-05-10 06:09:27,443 ERROR Internal Server Error: /api/v1/mutations/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
And then when you go back to library views, same error in the log, need to restart the server for displaying library, tracks, albums…
2019-05-10 06:16:17,174 ERROR Internal Server Error: /.well-known/nodeinfo
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
2019-05-10 06:16:21,728 ERROR Internal Server Error: /api/v1/favorites/tracks/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
2019-05-10 06:16:21,730 ERROR Internal Server Error: /api/v1/history/listenings/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
2019-05-10 06:16:21,735 ERROR Internal Server Error: /api/v1/playlists/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
2019-05-10 06:16:21,749 ERROR Internal Server Error: /api/v1/albums/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
Same when trying to manage users :
2019-05-10 06:18:51,121 ERROR Internal Server Error: /api/v1/manage/users/users/
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.6/contextlib.py", line 51, in inner
with self._recreate_cm():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/transaction.py", line 175, in __enter__
if not connection.get_autocommit():
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 379, in get_autocommit
self.ensure_connection()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/django/db/backends/postgresql/base.py", line 178, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/www/funkwhale/virtualenv/lib/python3.6/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections