Skip to content

[runix/pgadmin4] timeout with traefik and oauth2-proxy #9403

@svmnkg

Description

@svmnkg

Describe the bug
after about one minute, the connection breaks down, and following log entry appears in pgadmin container

2025-11-27 09:01:55,727: ERROR pgadmin: Expecting value: line 1 column 1 (char 0)
Traceback (most recent call last): File "/venv/lib/python3.12/site-packages/flask/app.py", line 917, in full_dispatch_request
rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^
File "/venv/lib/python3.12/site-packages/flask/app.py", line 902, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/venv/lib/python3.12/site-packages/flask_login/utils.py", line 290, in decorated_view
return current_app.ensure_sync(func)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/pgadmin4/pgadmin/authenticate/mfa/utils.py", line 304, in inner return mfa_enabled(
^^^^^^^^^^^^ File "/pgadmin4/pgadmin/authenticate/mfa/utils.py", line 169, in mfa_enabled
return execute_if_enabled() ^^^^^^^^^^^^^^^^^^^^
File "/pgadmin4/pgadmin/authenticate/mfa/utils.py", line 301, in if_else_func_inner return _func(first, second)
^^^^^^^^^^^^^^^^^^^^ File "/pgadmin4/pgadmin/authenticate/mfa/utils.py", line 242, in mfa_session_authenticated
return authenticated() if session.get('mfa_authenticated', False) is True \ ^^^^^^^^^^^^^^^
File "/pgadmin4/pgadmin/authenticate/mfa/utils.py", line 297, in execute_func return wrapped(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^ File "/pgadmin4/pgadmin/user_login_check.py", line 22, in wrapper
return func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^
File "/pgadmin4/pgadmin/misc/file_manager/init.py", line 1321, in file_manager kwargs = json.loads(req.data)
^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/json/init.py", line 346, in loads
return _default_decoder.decode(s) ^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/json/decoder.py", line 338, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/json/decoder.py", line 356, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

Version of Helm and Kubernetes:
AWS EKS 1.33, chart version 1.50.0

Which chart:
pgadmin

What happened:
after authentication with GitHub and EAS / oauth2-proxy, and logging into pgadmin
file upload in pgadmin storage manager breaks after about one minute.
also some long running queries inside pgadmin break.
(using k9s kubernetes port-forward allows for very long session time without this issue)

What you expected to happen:
according to settings in all components, session should last 24hrs.
expected to do file uploads of 2GB files / 5 minutes and have long-running queries.

How to reproduce it (as minimally and precisely as possible):
traefik chart 36.3.0 and oauth2-proxy, and without middleware in traefik

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions