pgAdmin Runtime Environment -------------------------------------------------------- Python Path: "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/Current/bin/python3" Runtime Config File: "/Users/rajiv/Library/Preferences/pgadmin/runtime_config.json" pgAdmin Config File: "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/config.py" Webapp Path: "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgAdmin4.py" pgAdmin Command: "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/Current/bin/python3 -s /Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgAdmin4.py" Environment: - PWD: / - MallocNanoZone: 0 - USER: rajiv - COMMAND_MODE: unix2003 - __CFBundleIdentifier: org.pgadmin.pgadmin4 - PATH: /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin - LOGNAME: rajiv - SYSTEM_VERSION_COMPAT: 0 - SSH_AUTH_SOCK: /private/tmp/com.apple.launchd.Z3wuCB3U1v/Listeners - SHLVL: 1 - HOME: /Users/rajiv - SHELL: /bin/zsh - _: /usr/bin/open - TMPDIR: /var/folders/4q/zxpnp2tj289_1_ypfd52yhl40000gn/T/ - __CF_USER_TEXT_ENCODING: 0x1F5:0x0:0x0 - XPC_SERVICE_NAME: application.org.pgadmin.pgadmin4.11181088.11188219 - XPC_FLAGS: 0x0 - PGADMIN_INT_PORT: 49813 - PGADMIN_INT_KEY: b4a200bc-2686-4d49-8602-553b177dbca3 - PGADMIN_SERVER_MODE: OFF -------------------------------------------------------- Total spawn time to start the pgAdmin4 server: 0.286 Sec 2023-02-16 13:39:58,778: WARNING werkzeug: WebSocket transport not available. Install simple-websocket for improved performance. * Serving Flask app 'pgadmin' (lazy loading) * Environment: production WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Debug mode: off ------------------------------------------ Total time taken to ping pgAdmin4 server: 6.702 Sec ------------------------------------------ Total launch time of pgAdmin4: 7.142 Sec ------------------------------------------ Application Server URL: http://127.0.0.1:49813/?key=b4a200bc-2686-4d49-8602-553b177dbca3 2023-02-16 13:40:08,698: ERROR pgadmin: (sqlite3.OperationalError) no such column: server.hostaddr [SQL: SELECT server.id AS server_id, server.user_id AS server_user_id, server.servergroup_id AS server_servergroup_id, server.name AS server_name, server.host AS server_host, server.hostaddr AS server_hostaddr, server.port AS server_port, server.maintenance_db AS server_maintenance_db, server.username AS server_username, server.password AS server_password, server.save_password AS server_save_password, server.role AS server_role, server.ssl_mode AS server_ssl_mode, server.comment AS server_comment, server.discovery_id AS server_discovery_id, server.db_res AS server_db_res, server.passfile AS server_passfile, server.passexec_cmd AS server_passexec_cmd, server.passexec_expiration AS server_passexec_expiration, server.sslcert AS server_sslcert, server.sslkey AS server_sslkey, server.sslrootcert AS server_sslrootcert, server.sslcrl AS server_sslcrl, server.sslcompression AS server_sslcompression, server.bgcolor AS server_bgcolor, server.fgcolor AS server_fgcolor, server.service AS server_service, server.connect_timeout AS server_connect_timeout, server.use_ssh_tunnel AS server_use_ssh_tunnel, server.tunnel_host AS server_tunnel_host, server.tunnel_port AS server_tunnel_port, server.tunnel_username AS server_tunnel_username, server.tunnel_authentication AS server_tunnel_authentication, server.tunnel_identity_file AS server_tunnel_identity_file, server.tunnel_password AS server_tunnel_password, server.shared AS server_shared, server.kerberos_conn AS server_kerberos_conn, server.cloud_status AS server_cloud_status, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name FROM server LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = server.servergroup_id WHERE server.user_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: server.hostaddr The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1517, in full_dispatch_request rv = self.dispatch_request() File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1503, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/__init__.py", line 851, in set_master_password reencrpyt_server_passwords( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/utils.py", line 239, in reencrpyt_server_passwords for server in Server.query.filter_by(user_id=user_id).all(): File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all return self._iter().all() File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter result = self.session.execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1714, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection return connection._execute_clauseelement( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception util.raise_( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: server.hostaddr [SQL: SELECT server.id AS server_id, server.user_id AS server_user_id, server.servergroup_id AS server_servergroup_id, server.name AS server_name, server.host AS server_host, server.hostaddr AS server_hostaddr, server.port AS server_port, server.maintenance_db AS server_maintenance_db, server.username AS server_username, server.password AS server_password, server.save_password AS server_save_password, server.role AS server_role, server.ssl_mode AS server_ssl_mode, server.comment AS server_comment, server.discovery_id AS server_discovery_id, server.db_res AS server_db_res, server.passfile AS server_passfile, server.passexec_cmd AS server_passexec_cmd, server.passexec_expiration AS server_passexec_expiration, server.sslcert AS server_sslcert, server.sslkey AS server_sslkey, server.sslrootcert AS server_sslrootcert, server.sslcrl AS server_sslcrl, server.sslcompression AS server_sslcompression, server.bgcolor AS server_bgcolor, server.fgcolor AS server_fgcolor, server.service AS server_service, server.connect_timeout AS server_connect_timeout, server.use_ssh_tunnel AS server_use_ssh_tunnel, server.tunnel_host AS server_tunnel_host, server.tunnel_port AS server_tunnel_port, server.tunnel_username AS server_tunnel_username, server.tunnel_authentication AS server_tunnel_authentication, server.tunnel_identity_file AS server_tunnel_identity_file, server.tunnel_password AS server_tunnel_password, server.shared AS server_shared, server.kerberos_conn AS server_kerberos_conn, server.cloud_status AS server_cloud_status, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name FROM server LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = server.servergroup_id WHERE server.user_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8) 2023-02-16 13:40:11,142: ERROR pgadmin: (sqlite3.OperationalError) no such column: server.hostaddr [SQL: SELECT server.id AS server_id, server.user_id AS server_user_id, server.servergroup_id AS server_servergroup_id, server.name AS server_name, server.host AS server_host, server.hostaddr AS server_hostaddr, server.port AS server_port, server.maintenance_db AS server_maintenance_db, server.username AS server_username, server.password AS server_password, server.save_password AS server_save_password, server.role AS server_role, server.ssl_mode AS server_ssl_mode, server.comment AS server_comment, server.discovery_id AS server_discovery_id, server.db_res AS server_db_res, server.passfile AS server_passfile, server.passexec_cmd AS server_passexec_cmd, server.passexec_expiration AS server_passexec_expiration, server.sslcert AS server_sslcert, server.sslkey AS server_sslkey, server.sslrootcert AS server_sslrootcert, server.sslcrl AS server_sslcrl, server.sslcompression AS server_sslcompression, server.bgcolor AS server_bgcolor, server.fgcolor AS server_fgcolor, server.service AS server_service, server.connect_timeout AS server_connect_timeout, server.use_ssh_tunnel AS server_use_ssh_tunnel, server.tunnel_host AS server_tunnel_host, server.tunnel_port AS server_tunnel_port, server.tunnel_username AS server_tunnel_username, server.tunnel_authentication AS server_tunnel_authentication, server.tunnel_identity_file AS server_tunnel_identity_file, server.tunnel_password AS server_tunnel_password, server.shared AS server_shared, server.kerberos_conn AS server_kerberos_conn, server.cloud_status AS server_cloud_status, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name FROM server LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = server.servergroup_id WHERE (server.user_id = ? OR server.shared = 1) AND server.servergroup_id = ?] [parameters: (1, 1)] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: server.hostaddr The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1517, in full_dispatch_request rv = self.dispatch_request() File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/app.py", line 1503, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/flask/views.py", line 84, in view return current_app.ensure_sync(self.dispatch_request)(*args, **kwargs) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 311, in dispatch_request return method(*args, **kwargs) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 346, in children children = self.get_children_nodes(*args, **kwargs) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 367, in get_children_nodes children.extend(module.get_nodes(*args, **kwargs)) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/__init__.py", line 213, in get_nodes servers = self.get_servers(servers, hide_shared_server, gid) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/__init__.py", line 179, in get_servers for server in all_servers: File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2901, in __iter__ result = self._iter() File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter result = self.session.execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1714, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection return connection._execute_clauseelement( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception util.raise_( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/Library/PostgreSQL/15/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: server.hostaddr [SQL: SELECT server.id AS server_id, server.user_id AS server_user_id, server.servergroup_id AS server_servergroup_id, server.name AS server_name, server.host AS server_host, server.hostaddr AS server_hostaddr, server.port AS server_port, server.maintenance_db AS server_maintenance_db, server.username AS server_username, server.password AS server_password, server.save_password AS server_save_password, server.role AS server_role, server.ssl_mode AS server_ssl_mode, server.comment AS server_comment, server.discovery_id AS server_discovery_id, server.db_res AS server_db_res, server.passfile AS server_passfile, server.passexec_cmd AS server_passexec_cmd, server.passexec_expiration AS server_passexec_expiration, server.sslcert AS server_sslcert, server.sslkey AS server_sslkey, server.sslrootcert AS server_sslrootcert, server.sslcrl AS server_sslcrl, server.sslcompression AS server_sslcompression, server.bgcolor AS server_bgcolor, server.fgcolor AS server_fgcolor, server.service AS server_service, server.connect_timeout AS server_connect_timeout, server.use_ssh_tunnel AS server_use_ssh_tunnel, server.tunnel_host AS server_tunnel_host, server.tunnel_port AS server_tunnel_port, server.tunnel_username AS server_tunnel_username, server.tunnel_authentication AS server_tunnel_authentication, server.tunnel_identity_file AS server_tunnel_identity_file, server.tunnel_password AS server_tunnel_password, server.shared AS ser ver_shared, server.kerberos_conn AS server_kerberos_conn, server.cloud_status AS server_cloud_status, servergroup_1.id AS servergroup_1_id, servergroup_1.user_id AS servergroup_1_user_id, servergroup_1.name AS servergroup_1_name FROM server LEFT OUTER JOIN servergroup AS servergroup_1 ON servergroup_1.id = server.servergroup_id WHERE (server.user_id = ? OR server.shared = 1) AND server.servergroup_id = ?] [parameters: (1, 1)] (Background on this error at: https://sqlalche.me/e/14/e3q8)