Postgresql errors

[charlesnw]

Anyone else having errors with Postgresql connection on paperless? All of my paperless instances broke recently.

Not sure if it makes sense to debug here, or open a support ticket or what?

[charlesnw]

ul 16 10:05:00 django.db.utils.OperationalError: connection failed: connection to server at "172.18.30.2", port 5432 failed: FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute
Jul 16 10:05:00 num = len(clone)
Jul 16 10:05:00 obj, created = self.using(using).get_or_create(task_id=task_id,
Jul 16 10:05:00 psycopg.OperationalError: connection failed: connection to server at "172.18.30.2", port 5432 failed: FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute
Jul 16 10:05:00 raise dj_exc_value.with_traceback(traceback) from exc_value
Jul 16 10:05:00 raise type(last_ex)("\n".join(lines)).with_traceback(None)
Jul 16 10:05:00 raise type(last_ex)("\n".join(lines)).with_traceback(None)
Jul 16 10:05:00 results = compiler.execute_sql(
Jul 16 10:05:00 return fun(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return func(*args, **kwargs)
Jul 16 10:05:00 return self._cursor()
Jul 16 10:05:00 return self.get(**kwargs), False
Jul 16 10:05:00 self.TaskModel._default_manager.store_result(**task_props)
Jul 16 10:05:00 self._fetch_all()
Jul 16 10:05:00 self._result_cache = list(self._iterable_class(self))
Jul 16 10:05:00 self._store_result(task_id, result, state, traceback,
Jul 16 10:05:00 self.connect()
Jul 16 10:05:00 self.connect()
Jul 16 10:05:00 self.connection = self.get_new_connection(conn_params)
Jul 16 10:05:00 self.connection = self.get_new_connection(conn_params)
Jul 16 10:05:00 self.ensure_connection()
Jul 16 10:05:00 task.backend.store_result(
Jul 16 10:05:00 with self.wrap_database_errors:
Jul 16 10:05:01 13:M 16 Jul 2026 15:05:01.058 * 10 changes in 300 seconds. Saving...
Jul 16 10:05:01 13:M 16 Jul 2026 15:05:01.059 * Background saving started by pid 383
Jul 16 10:05:01 13:M 16 Jul 2026 15:05:01.164 * Background saving terminated with success
Jul 16 10:05:01 383:C 16 Jul 2026 15:05:01.060 * BGSAVE done, 4 keys saved, 0 keys skipped, 3027 bytes written.
Jul 16 10:05:01 383:C 16 Jul 2026 15:05:01.063 * DB saved on disk
Jul 16 10:05:01 383:C 16 Jul 2026 15:05:01.064 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB

[charlesnw]

All of my paperless instances broke in the exact same way with that same error message.

[charlesnw]

ul 16 10:17:40 [previous exception] [object] (PDOException(code: 7): SQLSTATE[08006] [7] connection to server at "postgresql" (fd00:c107:d509::9b), port 5432 failed: FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:67)

Anyone else seeing this?

[nebulon]

Can you try to restart the postgres service?

[charlesnw]

that fixed it in all the apps! thx!

[james]

Hello @charlesnw
Is this also resolved by restarting the PostgreSQL service?

[charlesnw]

Yes it’s also resolved by restarting Postgres service.