Skip to content

no such column: sharedserver.db_res #9940

@deefdragon

Description

@deefdragon

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions