Please note that security bugs or issues should be reported to security@pgadmin.org.
Describe the bug
For unknown reasons (and twice now) my pgadmin instance has started throwing this error when I attempt to connect and open the server dropdown.
To Reproduce
Unknown exact cause. Appeared on fresh install that was otherwise working normally after a few days of sitting running. Persists through container restarts.
Expected behavior
Ability to list and connect to servers with no error produced.
Error message
(sqlite3.OperationalError) no such column: sharedserver.db_res
[SQL: SELECT sharedserver.id AS sharedserver_id, sharedserver.osid AS sharedserver_osid, sharedserver.user_id AS sharedserver_user_id, sharedserver.server_owner AS sharedserver_server_owner, sharedserver.servergroup_id AS sharedserver_servergroup_id, sharedserver.name AS sharedserver_name, sharedserver.host AS sharedserver_host, sharedserver.port AS sharedserver_port, sharedserver.maintenance_db AS sharedserver_maintenance_db, sharedserver.username AS sharedserver_username, sharedserver.password AS sharedserver_password, sharedserver.save_password AS sharedserver_save_password, sharedserver.role AS sharedserver_role, sharedserver.comment AS sharedserver_comment, sharedserver.discovery_id AS sharedserver_discovery_id, sharedserver.db_res AS sharedserver_db_res, sharedserver.bgcolor AS sharedserver_bgcolor, sharedserver.fgcolor AS sharedserver_fgcolor, sharedserver.service AS sharedserver_service, sharedserver.use_ssh_tunnel AS sharedserver_use_ssh_tunnel, sharedserver.tunnel_host AS sharedserver_tunnel_host, sharedserver.tunnel_port AS sharedserver_tunnel_port, sharedserver.tunnel_username AS sharedserver_tunnel_username, sharedserver.tunnel_authentication AS sharedserver_tunnel_authentication, sharedserver.tunnel_identity_file AS sharedserver_tunnel_identity_file, sharedserver.tunnel_prompt_password AS sharedserver_tunnel_prompt_password, sharedserver.tunnel_password AS sharedserver_tunnel_password, sharedserver.tunnel_keep_alive AS sharedserver_tunnel_keep_alive, sharedserver.shared AS sharedserver_shared, sharedserver.connection_params AS sharedserver_connection_params, sharedserver.prepare_threshold AS sharedserver_prepare_threshold, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name
FROM sharedserver LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = sharedserver.servergroup_id
WHERE sharedserver.name = ? AND sharedserver.user_id = ? AND sharedserver.servergroup_id = ? AND sharedserver.osid = ?
LIMIT ? OFFSET ?]
[parameters: ('Business DBs', 2, 4, 6, 1, 0)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
- OS: nixos
- pgAdmin version: 9.13
- Mode: server
- Browser (if running in server mode): firefox
- Package type: docker container
Additional context
It appears that I can still connect to the servers I provided in the file when logged in as the admin, but when I use the sso, it fails to load those. In both cases I get the error message above. I am unsure if there is a similar cause.
Please note that security bugs or issues should be reported to security@pgadmin.org.
Describe the bug
For unknown reasons (and twice now) my pgadmin instance has started throwing this error when I attempt to connect and open the server dropdown.
To Reproduce
Unknown exact cause. Appeared on fresh install that was otherwise working normally after a few days of sitting running. Persists through container restarts.
Expected behavior
Ability to list and connect to servers with no error produced.
Error message
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context
It appears that I can still connect to the servers I provided in the file when logged in as the admin, but when I use the sso, it fails to load those. In both cases I get the error message above. I am unsure if there is a similar cause.