Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

invalid target_session_attrs value: ""read-write"" in "cybertec/pgwatch2-webui:latest". #674

Closed
pashagolub opened this issue Aug 18, 2023 · 0 comments · Fixed by #675
Closed

invalid target_session_attrs value: ""read-write"" in "cybertec/pgwatch2-webui:latest". #674

pashagolub opened this issue Aug 18, 2023 · 0 comments · Fixed by #675
Assignees
@pashagolub
Labels
bug webui

Comments

@pashagolub
Copy link
Collaborator 

webui_1                      | 2023-08-16 15:40:04,927 ERROR 1 failed to execute "select 1 as x" on datastore
webui_1                      | Traceback (most recent call last):
webui_1                      |   File "/pgwatch2/webpy/datadb.py", line 45, in execute
webui_1                      |     conn = getConnection(connection_string_metrics) if on_metric_store else getConnection(conn_str)
webui_1                      |   File "/pgwatch2/webpy/datadb.py", line 35, in getConnection
webui_1                      |     conn = psycopg2.connect(conn_str if conn_str else connection_string)    # default to configDB
webui_1                      |   File "/usr/local/lib/python3.10/dist-packages/psycopg2/init.py", line 122, in connect
webui_1                      |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
webui_1                      | psycopg2.OperationalError: invalid target_session_attrs value: ""read-write""
webui_1                      |
webui_1                      | 2023-08-16 15:40:04,927 WARNING 1 config DB connection test failed: invalid target_session_attrs value: ""read-write""
@pashagolub pashagolub changed the title error when starting a Docker container "cybertec/pgwatch2-webui:latest". invalid target_session_attrs value: ""read-write"" in "cybertec/pgwatch2-webui:latest". Aug 18, 2023
@pashagolub pashagolub self-assigned this Aug 18, 2023
pashagolub added a commit that referenced this issue Aug 18, 2023
@pashagolub
[-] fix invalid target_session_attrs value in WebUI URI, fixes #674
f315e93
@pashagolub pashagolub linked a pull request Aug 18, 2023 that will close this issue
[-] fix invalid target_session_attrs value in WebUI URI, fixes #674 #675
Merged
pashagolub added a commit that referenced this issue Aug 18, 2023
@pashagolub
Merge pull request #675 from cybertec-postgresql/674-invalid-target-s…
660ed95 
…ession-attrs-webui

[-] fix invalid `target_session_attrs` value in WebUI URI, fixes #674
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pashagolub pashagolub

Labels
bug webui
Projects
pgwatch2
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[-] fix invalid target_session_attrs value in WebUI URI, fixes #674 cybertec-postgresql/pgwatch2
1 participant
@pashagolub