psycopg2.pool.PoolError: connection pool exhausted

[sebix]

2025-09-02 07:33:16 [FALCON] [ERROR] GET /api/contactdb/org/manual/1 => Traceback (most recent call last):, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "falcon/app.py", line 365, in falcon.app.App.__call__, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "hug/interface.py", line 947, in hug.interface.HTTP.__call__, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "hug/interface.py", line 918, in hug.interface.HTTP.__call__, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "hug/interface.py", line 840, in hug.interface.HTTP.call_function, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "hug/interface.py", line 129, in hug.interface.Interfaces.__call__, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/contactdb_api/contactdb_api/serve.py", line 1322, in get_manual_org_details, referer: http://example.intelmq.org:8000/contacts?email=%40
    return __db_query_org(id, ""), referer: http://example.intelmq.org:8000/contacts?email=%40
           ^^^^^^^^^^^^^^^^^^^^^^, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/contactdb_api/contactdb_api/serve.py", line 335, in __db_query_org, referer: http://example.intelmq.org:8000/contacts?email=%40
    description, results = _db_query(operation_str, (org_id,)), referer: http://example.intelmq.org:8000/contacts?email=%40
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/contactdb_api/contactdb_api/serve.py", line 218, in _db_query, referer: http://example.intelmq.org:8000/contacts?email=%40
    with db_connection() as conn:, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3.12/contextlib.py", line 137, in __enter__, referer: http://example.intelmq.org:8000/contacts?email=%40
    return next(self.gen), referer: http://example.intelmq.org:8000/contacts?email=%40
           ^^^^^^^^^^^^^^, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/contactdb_api/contactdb_api/serve.py", line 174, in db_connection, referer: http://example.intelmq.org:8000/contacts?email=%40
    connection = contactdb_pool.getconn(), referer: http://example.intelmq.org:8000/contacts?email=%40
                 ^^^^^^^^^^^^^^^^^^^^^^^^, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 169, in getconn, referer: http://example.intelmq.org:8000/contacts?email=%40
    return self._getconn(key), referer: http://example.intelmq.org:8000/contacts?email=%40
           ^^^^^^^^^^^^^^^^^^, referer: http://example.intelmq.org:8000/contacts?email=%40
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 92, in _getconn, referer: http://example.intelmq.org:8000/contacts?email=%40
    raise PoolError("connection pool exhausted"), referer: http://example.intelmq.org:8000/contacts?email=%40
psycopg2.pool.PoolError: connection pool exhausted, referer: http://example.intelmq.org:8000/contacts?email=%40
, referer: http://example.intelmq.org:8000/contacts?email=%40

The contact db likely needs a bigger pool.

Also, make the pool size configurable?