9.2: Opening query tool results in blank screen

[simon-kempster]

On Windows Server 2019, verion 1809, build 17763.7009, running in Desktop mode. I've just upgraded from pgAdmin 9.1 to 9.2. I open it, connect to a database, and try to open the query tool. This can be either using the icon on the toolbar, right-clicking on the database and selecting the Query Tool menu option, or using Alt-Shift-Q. There is a brief flash where it looks like the query tool is trying to open, then the pane goes blank and stays that way. The resulting tabs then refuse to close.

[InceptusSolutions]

I have this issue as well - it means the tool is effectively unusable as I cannot issue any commands or view any data.

[InceptusSolutions]

Sorry I meant to add this occurred when I opened the query history, now it seems to be trying to open the query history view all the time and I cannot stop this, I would suggest when you open a new query tool or data view it should never default to query history.

[adityatoshniwal]

@simon-kempster @InceptusSolutions This is fixed with #8623. Are you using v9.2?
Can you share logs from View -> Toggle Dev tools -> Console?

[InceptusSolutions]

This?
VM4 sandbox_bundle:2 Electron Security Warning (Insecure Content-Security-Policy) This renderer process has either no Content Security
Policy set or a policy with "unsafe-eval" enabled. This exposes users of
this app to unnecessary security risks.

For more information and help, consult
https://electronjs.org/docs/tutorial/security.
This warning will not show up
once the app is packaged.
warnAboutInsecureCSP @ VM4 sandbox_bundle:2

[adityatoshniwal]

This? VM4 sandbox_bundle:2 Electron Security Warning (Insecure Content-Security-Policy) This renderer process has either no Content Security Policy set or a policy with "unsafe-eval" enabled. This exposes users of this app to unnecessary security risks.

For more information and help, consult https://electronjs.org/docs/tutorial/security. This warning will not show up once the app is packaged. warnAboutInsecureCSP @ VM4 sandbox_bundle:2

No. The logs after query tool goes blank.

[InceptusSolutions]

Yes I am using 9.2 but on windows 11 not macOS

[simon-kempster]

This is the log that I get after trying to open 3 query tool windows:

VM4 sandbox_bundle:2 Electron Security Warning (Insecure Content-Security-Policy) This renderer process has either no Content Security
Policy set or a policy with "unsafe-eval" enabled. This exposes users of
this app to unnecessary security risks.

For more information and help, consult
https://electronjs.org/docs/tutorial/security.
This warning will not show up
once the app is packaged.
warnAboutInsecureCSP @ VM4 sandbox_bundle:2
vendor.react.js?ver=90200:2 RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
dl @ vendor.react.js?ver=90200:2
vendor.react.js?ver=90200:2 Uncaught RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
vendor.react.js?ver=90200:2 RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
dl @ vendor.react.js?ver=90200:2
vendor.react.js?ver=90200:2 Uncaught RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
vendor.react.js?ver=90200:2 RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
dl @ vendor.react.js?ver=90200:2
vendor.react.js?ver=90200:2 Uncaught RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
vendor.react.js?ver=90200:2 RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
dl @ vendor.react.js?ver=90200:2
vendor.react.js?ver=90200:2 Uncaught RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)

[InceptusSolutions]

Ah here.

VM4 sandbox_bundle:2 Electron Security Warning (Insecure Content-Security-Policy) This renderer process has either no Content Security
Policy set or a policy with "unsafe-eval" enabled. This exposes users of
this app to unnecessary security risks.

For more information and help, consult
https://electronjs.org/docs/tutorial/security.
This warning will not show up
once the app is packaged.
warnAboutInsecureCSP @ VM4 sandbox_bundle:2
vendor.react.js?ver=90200:2 RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
dl @ vendor.react.js?ver=90200:2
n.callback @ vendor.react.js?ver=90200:2
Va @ vendor.react.js?ver=90200:2
bs @ vendor.react.js?ver=90200:2
ys @ vendor.react.js?ver=90200:2
xs @ vendor.react.js?ver=90200:2
(anonymous) @ vendor.react.js?ver=90200:2
wc @ vendor.react.js?ver=90200:2
oc @ vendor.react.js?ver=90200:2
O @ vendor.others.js?ver=90200:97
C @ vendor.others.js?ver=90200:97
vendor.react.js?ver=90200:2 Uncaught RangeError: Incorrect locale information provided
at Date.toLocaleDateString ()
at A (sqleditor.js?ver=90200:1:1314554)
at I.isDaysBefore (sqleditor.js?ver=90200:1:1314942)
at I.getDatePrefix (sqleditor.js?ver=90200:1:1315034)
at I.getGroupHeader (sqleditor.js?ver=90200:1:1315669)
at sqleditor.js?ver=90200:1:1315798
at Array.map ()
at I.getGroups (sqleditor.js?ver=90200:1:1315773)
at sqleditor.js?ver=90200:1:1310243
at Object.$i [as useMemo] (vendor.react.js?ver=90200:2:274873)
A @ sqleditor.js?ver=90200:1
isDaysBefore @ sqleditor.js?ver=90200:1
getDatePrefix @ sqleditor.js?ver=90200:1
getGroupHeader @ sqleditor.js?ver=90200:1
(anonymous) @ sqleditor.js?ver=90200:1
getGroups @ sqleditor.js?ver=90200:1
(anonymous) @ sqleditor.js?ver=90200:1
$i @ vendor.react.js?ver=90200:2
(anonymous) @ vendor.react.js?ver=90200:2
t.QueryHistory @ sqleditor.js?ver=90200:1
gi @ vendor.react.js?ver=90200:2
Rl @ vendor.react.js?ver=90200:2
ks @ vendor.react.js?ver=90200:2
yc @ vendor.react.js?ver=90200:2
vc @ vendor.react.js?ver=90200:2
gc @ vendor.react.js?ver=90200:2
ac @ vendor.react.js?ver=90200:2
oc @ vendor.react.js?ver=90200:2
O @ vendor.others.js?ver=90200:97
C @ vendor.others.js?ver=90200:97

[adityatoshniwal]

@simon-kempster @InceptusSolutions please share the pgAdmin about screenshot.

[InceptusSolutions]

[simon-kempster]

ALLOW_SAVE_PASSWORD = True
ALLOW_SAVE_TUNNEL_PASSWORD = False
ALLOW_SPECIAL_EMAIL_DOMAINS = []
APP_COPYRIGHT = "Copyright (C) 2013 - 2025, The pgAdmin Development Team"
APP_DEFAULT_EMAIL = "pgadmin4@pgadmin.org"
APP_ICON = "pg-icon"
APP_NAME = "pgAdmin 4"
APP_PATH = "pgadmin"
APP_RELEASE = 9
APP_REVISION = 2
APP_SHORT_NAME = "pgadmin4"
APP_SUFFIX = ""
APP_VERSION = "9.2"
APP_VERSION_EXTN = ('.css', '.js', '.html', '.svg', '.png', '.gif', '.ico')
APP_VERSION_INT = 90200
APP_VERSION_PARAM = "ver"
APP_WIN_PATH = "pgAdmin"
AUTHENTICATION_SOURCES = ['internal']
AUTO_DISCOVER_SERVERS = True
AZURE_CREDENTIAL_CACHE_DIR = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\azurecredentialcache"
CA_FILE = "C:\Program Files\pgAdmin 4\web\cacert.pem"
CHECK_EMAIL_DELIVERABILITY = False
CHECK_SESSION_FILES_INTERVAL = 24
CHECK_SUPPORTED_BROWSER = True
COMMIT_HASH = "73fefb860369ce660eb4b04d304d63d048935b83 2025-04-02"
COMPRESS_LEVEL = 9
COMPRESS_MIMETYPES = ['text/html', 'text/css', 'text/xml', 'text/javascript', 'application/json', 'application/javascript']
COMPRESS_MIN_SIZE = 500
CONFIG_DATABASE_CONNECTION_MAX_OVERFLOW = 100
CONFIG_DATABASE_CONNECTION_POOL_SIZE = 5
CONFIG_DATABASE_URI = ""
CONSOLE_LOG_FORMAT = "%(asctime)s: %(levelname)s %(name)s: %(message)s"
CONSOLE_LOG_FORMAT_JSON = OrderedDict({'time': 'asctime', 'message': 'message', 'level': 'levelname'})
CONSOLE_LOG_LEVEL = 30
CONTENT_SECURITY_POLICY = "default-src ws: http: data: blob: 'unsafe-inline' 'unsafe-eval';"
COOKIE_DEFAULT_DOMAIN = None
COOKIE_DEFAULT_PATH = "/"
DATA_DIR = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin"
DATA_RESULT_ROWS_PER_PAGE = 1000
DEBUG = False
DEFAULT_BINARY_PATHS = {'pg': '$DIR/../runtime', 'ppas': ''}
DEFAULT_SERVER = "127.0.0.1"
DEFAULT_SERVER_PORT = 5050
DESKTOP_USER = "pgadmin4@pgadmin.org"
EFFECTIVE_SERVER_PORT = 62568
ENABLE_BINARY_PATH_BROWSING = False
ENABLE_PSQL = True
ENABLE_SERVER_PASS_EXEC_CMD = False
ENHANCED_COOKIE_PROTECTION = True
FILE_LOG_FORMAT = "%(asctime)s: %(levelname)s %(name)s: %(message)s"
FILE_LOG_FORMAT_JSON = OrderedDict({'time': 'asctime', 'message': 'message', 'level': 'levelname'})
FILE_LOG_LEVEL = 30
FIXED_BINARY_PATHS = {'pg': '', 'pg-13': '', 'pg-14': '', 'pg-15': '', 'pg-16': '', 'pg-17': '', 'ppas': '', 'ppas-13': '', 'ppas-14': '', 'ppas-15': '', 'ppas-16': '', 'ppas-17': ''}
GLOBALLY_DELIVERABLE = True
HELP_PATH = "../../../docs/en_US/html/"
IS_WIN = True
JSON_LOGGER = False
KERBEROS_CCACHE_DIR = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\krbccache"
KEYRING_NAME = "Windows WinVaultKeyring"
KRB_APP_HOST_NAME = "127.0.0.1"
KRB_AUTO_CREATE_USER = True
KRB_KTNAME = "<KRB5_KEYTAB_FILE>"
LANGUAGES = {'en': 'English', 'zh_Hans_CN': 'Chinese (Simplified)', 'zh_Hant_TW': 'Chinese (Traditional)', 'cs': 'Czech', 'fr': 'French', 'de': 'German', 'id': 'Indonesian', 'it': 'Italian', 'ja': 'Japanese', 'ko': 'Korean', 'pl': 'Polish', 'pt_BR': 'Portuguese (Brazilian)', 'ru': 'Russian', 'es': 'Spanish'}
LDAP_ANONYMOUS_BIND = False
LDAP_AUTO_CREATE_USER = True
LDAP_BASE_DN = ""
LDAP_BIND_FORMAT = "{LDAP_USERNAME_ATTRIBUTE}={LDAP_USERNAME},{LDAP_BASE_DN}"
LDAP_BIND_USER = None
LDAP_CA_CERT_FILE = ""
LDAP_CERT_FILE = ""
LDAP_CONNECTION_TIMEOUT = 10
LDAP_DN_CASE_SENSITIVE = False
LDAP_IGNORE_MALFORMED_SCHEMA = False
LDAP_KEY_FILE = ""
LDAP_SEARCH_BASE_DN = ""
LDAP_SEARCH_FILTER = "(objectclass=*)"
LDAP_SEARCH_SCOPE = "SUBTREE"
LDAP_SERVER_URI = "ldap://:"
LDAP_USERNAME_ATTRIBUTE = ""
LDAP_USE_STARTTLS = False
LOGIN_ATTEMPT_FIELDS = ['password']
LOGIN_BANNER = ""
LOG_FILE = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\pgadmin4.log"
LOG_ROTATION_AGE = 1440
LOG_ROTATION_MAX_LOG_FILES = 90
LOG_ROTATION_SIZE = 10
MAIL_DEBUG = False
MAIL_PORT = 25
MAIL_SERVER = "localhost"
MAIL_USERNAME = ""
MAIL_USE_SSL = False
MAIL_USE_TLS = False
MASTER_PASSWORD_HOOK = None
MASTER_PASSWORD_REQUIRED = True
MAX_LOGIN_ATTEMPTS = 3
MAX_QUERY_HIST_STORED = 20
MAX_SERVER_TAGS_ALLOWED = 5
MAX_SESSION_IDLE_TIME = 60
MFA_EMAIL_SUBJECT = None
MFA_ENABLED = False
MFA_FORCE_REGISTRATION = False
MFA_SUPPORTED_METHODS = ['email', 'authenticator']
MODULE_BLACKLIST = ['test']
NODE_BLACKLIST = []
OAUTH2_AUTO_CREATE_USER = True
OAUTH2_CONFIG = [{'OAUTH2_NAME': None, 'OAUTH2_DISPLAY_NAME': '', 'OAUTH2_CLIENT_ID': None, 'OAUTH2_CLIENT_SECRET': None, 'OAUTH2_TOKEN_URL': None, 'OAUTH2_AUTHORIZATION_URL': None, 'OAUTH2_SERVER_METADATA_URL': None, 'OAUTH2_API_BASE_URL': None, 'OAUTH2_USERINFO_ENDPOINT': None, 'OAUTH2_SCOPE': None, 'OAUTH2_USERNAME_CLAIM': None, 'OAUTH2_ICON': None, 'OAUTH2_BUTTON_COLOR': None, 'OAUTH2_ADDITIONAL_CLAIMS': None, 'OAUTH2_SSL_CERT_VERIFICATION': True, 'OAUTH2_LOGOUT_URL': None}]
ON_DEMAND_LOG_COUNT = 10000
OVERRIDE_USER_INACTIVITY_TIMEOUT = True
PASSWORD_LENGTH_MIN = 6
PG_DEFAULT_DRIVER = "psycopg3"
PROXY_X_FOR_COUNT = 1
PROXY_X_HOST_COUNT = 0
PROXY_X_PORT_COUNT = 1
PROXY_X_PREFIX_COUNT = 0
PROXY_X_PROTO_COUNT = 1
SECURITY_EMAIL_SENDER = "no-reply@localhost"
SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE = "Your password for pgAdmin 4 has been changed"
SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE = "Your pgAdmin 4 password has been reset"
SECURITY_EMAIL_SUBJECT_PASSWORD_RESET = "Password reset instructions for pgAdmin 4"
SECURITY_EMAIL_VALIDATOR_ARGS = {'check_deliverability': False}
SEND_FILE_MAX_AGE_DEFAULT = 31556952
SERVER_HEARTBEAT_TIMEOUT = 30
SERVER_MODE = False
SESSION_COOKIE_DOMAIN = None
SESSION_COOKIE_HTTPONLY = True
SESSION_COOKIE_NAME = "pga4_session"
SESSION_COOKIE_PATH = "/"
SESSION_COOKIE_SAMESITE = "Lax"
SESSION_COOKIE_SECURE = False
SESSION_DB_PATH = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\sessions"
SESSION_EXPIRATION_TIME = 7
SESSION_SKIP_PATHS = ['/misc/ping']
SETTINGS_SCHEMA_VERSION = 43
SHARED_STORAGE = []
SHOW_GRAVATAR_IMAGE = True
SQLALCHEMY_TRACK_MODIFICATIONS = False
SQLITE_PATH = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\pgadmin4.db"
SQLITE_TIMEOUT = 500
STORAGE_DIR = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\storage"
STRICT_TRANSPORT_SECURITY = "max-age=31536000; includeSubDomains"
STRICT_TRANSPORT_SECURITY_ENABLED = False
SUPPORT_SSH_TUNNEL = True
TEST_SQLITE_PATH = "C:\Users\simon.kempster\AppData\Roaming\PGAdmin\test_pgadmin4.db"
THREADED_MODE = True
UPGRADE_CHECK_ENABLED = True
UPGRADE_CHECK_KEY = "pgadmin4"
UPGRADE_CHECK_URL = "https://www.pgadmin.org/versions.json"
USER_INACTIVITY_TIMEOUT = 0
USE_OS_SECRET_STORAGE = True
WEBSERVER_AUTO_CREATE_USER = True
WEBSERVER_REMOTE_USER = "REMOTE_USER"
WEB_SERVER = "Python"
WTF_CSRF_HEADERS = ['X-pgA-CSRFToken']
X_CONTENT_TYPE_OPTIONS = "nosniff"
X_FRAME_OPTIONS = "SAMEORIGIN"
X_XSS_PROTECTION = "1; mode=block"

[InceptusSolutions]

ALLOW_SAVE_PASSWORD = True
ALLOW_SAVE_TUNNEL_PASSWORD = False
ALLOW_SPECIAL_EMAIL_DOMAINS = []
APP_COPYRIGHT = "Copyright (C) 2013 - 2025, The pgAdmin Development Team"
APP_DEFAULT_EMAIL = "pgadmin4@pgadmin.org"
APP_ICON = "pg-icon"
APP_NAME = "pgAdmin 4"
APP_PATH = "pgadmin"
APP_RELEASE = 9
APP_REVISION = 2
APP_SHORT_NAME = "pgadmin4"
APP_SUFFIX = ""
APP_VERSION = "9.2"
APP_VERSION_EXTN = ('.css', '.js', '.html', '.svg', '.png', '.gif', '.ico')
APP_VERSION_INT = 90200
APP_VERSION_PARAM = "ver"
APP_WIN_PATH = "pgAdmin"
AUTHENTICATION_SOURCES = ['internal']
AUTO_DISCOVER_SERVERS = True
AZURE_CREDENTIAL_CACHE_DIR = "C:\Users\paulm\AppData\Roaming\pgAdmin\azurecredentialcache"
CA_FILE = "C:\Users\paulm\AppData\Local\Programs\pgAdmin 4\web\cacert.pem"
CHECK_EMAIL_DELIVERABILITY = False
CHECK_SESSION_FILES_INTERVAL = 24
CHECK_SUPPORTED_BROWSER = True
COMMIT_HASH = "73fefb860369ce660eb4b04d304d63d048935b83 2025-04-02"
COMPRESS_LEVEL = 9
COMPRESS_MIMETYPES = ['text/html', 'text/css', 'text/xml', 'text/javascript', 'application/json', 'application/javascript']
COMPRESS_MIN_SIZE = 500
CONFIG_DATABASE_CONNECTION_MAX_OVERFLOW = 100
CONFIG_DATABASE_CONNECTION_POOL_SIZE = 5
CONFIG_DATABASE_URI = ""
CONSOLE_LOG_FORMAT = "%(asctime)s: %(levelname)s %(name)s: %(message)s"
CONSOLE_LOG_FORMAT_JSON = OrderedDict({'time': 'asctime', 'message': 'message', 'level': 'levelname'})
CONSOLE_LOG_LEVEL = 30
CONTENT_SECURITY_POLICY = "default-src ws: http: data: blob: 'unsafe-inline' 'unsafe-eval';"
COOKIE_DEFAULT_DOMAIN = None
COOKIE_DEFAULT_PATH = "/"
DATA_DIR = "C:\Users\paulm\AppData\Roaming\pgAdmin"
DATA_RESULT_ROWS_PER_PAGE = 1000
DEBUG = False
DEFAULT_BINARY_PATHS = {'pg': '$DIR/../runtime', 'ppas': ''}
DEFAULT_SERVER = "127.0.0.1"
DEFAULT_SERVER_PORT = 5050
DESKTOP_USER = "pgadmin4@pgadmin.org"
EFFECTIVE_SERVER_PORT = 57387
ENABLE_BINARY_PATH_BROWSING = False
ENABLE_PSQL = True
ENABLE_SERVER_PASS_EXEC_CMD = False
ENHANCED_COOKIE_PROTECTION = True
FILE_LOG_FORMAT = "%(asctime)s: %(levelname)s %(name)s: %(message)s"
FILE_LOG_FORMAT_JSON = OrderedDict({'time': 'asctime', 'message': 'message', 'level': 'levelname'})
FILE_LOG_LEVEL = 30
FIXED_BINARY_PATHS = {'pg': '', 'pg-13': '', 'pg-14': '', 'pg-15': '', 'pg-16': '', 'pg-17': '', 'ppas': '', 'ppas-13': '', 'ppas-14': '', 'ppas-15': '', 'ppas-16': '', 'ppas-17': ''}
GLOBALLY_DELIVERABLE = True
HELP_PATH = "../../../docs/en_US/html/"
IS_WIN = True
JSON_LOGGER = False
KERBEROS_CCACHE_DIR = "C:\Users\paulm\AppData\Roaming\pgAdmin\krbccache"
KEYRING_NAME = "Windows WinVaultKeyring"
KRB_APP_HOST_NAME = "127.0.0.1"
KRB_AUTO_CREATE_USER = True
KRB_KTNAME = "<KRB5_KEYTAB_FILE>"
LANGUAGES = {'en': 'English', 'zh_Hans_CN': 'Chinese (Simplified)', 'zh_Hant_TW': 'Chinese (Traditional)', 'cs': 'Czech', 'fr': 'French', 'de': 'German', 'id': 'Indonesian', 'it': 'Italian', 'ja': 'Japanese', 'ko': 'Korean', 'pl': 'Polish', 'pt_BR': 'Portuguese (Brazilian)', 'ru': 'Russian', 'es': 'Spanish'}
LDAP_ANONYMOUS_BIND = False
LDAP_AUTO_CREATE_USER = True
LDAP_BASE_DN = ""
LDAP_BIND_FORMAT = "{LDAP_USERNAME_ATTRIBUTE}={LDAP_USERNAME},{LDAP_BASE_DN}"
LDAP_BIND_USER = None
LDAP_CA_CERT_FILE = ""
LDAP_CERT_FILE = ""
LDAP_CONNECTION_TIMEOUT = 10
LDAP_DN_CASE_SENSITIVE = False
LDAP_IGNORE_MALFORMED_SCHEMA = False
LDAP_KEY_FILE = ""
LDAP_SEARCH_BASE_DN = ""
LDAP_SEARCH_FILTER = "(objectclass=*)"
LDAP_SEARCH_SCOPE = "SUBTREE"
LDAP_SERVER_URI = "ldap://:"
LDAP_USERNAME_ATTRIBUTE = ""
LDAP_USE_STARTTLS = False
LOGIN_ATTEMPT_FIELDS = ['password']
LOGIN_BANNER = ""
LOG_FILE = "C:\Users\paulm\AppData\Roaming\pgAdmin\pgadmin4.log"
LOG_ROTATION_AGE = 1440
LOG_ROTATION_MAX_LOG_FILES = 90
LOG_ROTATION_SIZE = 10
MAIL_DEBUG = False
MAIL_PORT = 25
MAIL_SERVER = "localhost"
MAIL_USERNAME = ""
MAIL_USE_SSL = False
MAIL_USE_TLS = False
MASTER_PASSWORD_HOOK = None
MASTER_PASSWORD_REQUIRED = True
MAX_LOGIN_ATTEMPTS = 3
MAX_QUERY_HIST_STORED = 20
MAX_SERVER_TAGS_ALLOWED = 5
MAX_SESSION_IDLE_TIME = 60
MFA_EMAIL_SUBJECT = None
MFA_ENABLED = False
MFA_FORCE_REGISTRATION = False
MFA_SUPPORTED_METHODS = ['email', 'authenticator']
MODULE_BLACKLIST = ['test']
NODE_BLACKLIST = []
OAUTH2_AUTO_CREATE_USER = True
OAUTH2_CONFIG = [{'OAUTH2_NAME': None, 'OAUTH2_DISPLAY_NAME': '', 'OAUTH2_CLIENT_ID': None, 'OAUTH2_CLIENT_SECRET': None, 'OAUTH2_TOKEN_URL': None, 'OAUTH2_AUTHORIZATION_URL': None, 'OAUTH2_SERVER_METADATA_URL': None, 'OAUTH2_API_BASE_URL': None, 'OAUTH2_USERINFO_ENDPOINT': None, 'OAUTH2_SCOPE': None, 'OAUTH2_USERNAME_CLAIM': None, 'OAUTH2_ICON': None, 'OAUTH2_BUTTON_COLOR': None, 'OAUTH2_ADDITIONAL_CLAIMS': None, 'OAUTH2_SSL_CERT_VERIFICATION': True, 'OAUTH2_LOGOUT_URL': None}]
ON_DEMAND_LOG_COUNT = 10000
OVERRIDE_USER_INACTIVITY_TIMEOUT = True
PASSWORD_LENGTH_MIN = 6
PG_DEFAULT_DRIVER = "psycopg3"
PROXY_X_FOR_COUNT = 1
PROXY_X_HOST_COUNT = 0
PROXY_X_PORT_COUNT = 1
PROXY_X_PREFIX_COUNT = 0
PROXY_X_PROTO_COUNT = 1
SECURITY_EMAIL_SENDER = "no-reply@localhost"
SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE = "Your password for pgAdmin 4 has been changed"
SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE = "Your pgAdmin 4 password has been reset"
SECURITY_EMAIL_SUBJECT_PASSWORD_RESET = "Password reset instructions for pgAdmin 4"
SECURITY_EMAIL_VALIDATOR_ARGS = {'check_deliverability': False}
SEND_FILE_MAX_AGE_DEFAULT = 31556952
SERVER_HEARTBEAT_TIMEOUT = 30
SERVER_MODE = False
SESSION_COOKIE_DOMAIN = None
SESSION_COOKIE_HTTPONLY = True
SESSION_COOKIE_NAME = "pga4_session"
SESSION_COOKIE_PATH = "/"
SESSION_COOKIE_SAMESITE = "Lax"
SESSION_COOKIE_SECURE = False
SESSION_DB_PATH = "C:\Users\paulm\AppData\Roaming\pgAdmin\sessions"
SESSION_EXPIRATION_TIME = 7
SESSION_SKIP_PATHS = ['/misc/ping']
SETTINGS_SCHEMA_VERSION = 43
SHARED_STORAGE = []
SHOW_GRAVATAR_IMAGE = True
SQLALCHEMY_TRACK_MODIFICATIONS = False
SQLITE_PATH = "C:\Users\paulm\AppData\Roaming\pgAdmin\pgadmin4.db"
SQLITE_TIMEOUT = 500
STORAGE_DIR = "C:\Users\paulm\AppData\Roaming\pgAdmin\storage"
STRICT_TRANSPORT_SECURITY = "max-age=31536000; includeSubDomains"
STRICT_TRANSPORT_SECURITY_ENABLED = False
SUPPORT_SSH_TUNNEL = True
TEST_SQLITE_PATH = "C:\Users\paulm\AppData\Roaming\pgAdmin\test_pgadmin4.db"
THREADED_MODE = True
UPGRADE_CHECK_ENABLED = True
UPGRADE_CHECK_KEY = "pgadmin4"
UPGRADE_CHECK_URL = "https://www.pgadmin.org/versions.json"
USER_INACTIVITY_TIMEOUT = 0
USE_OS_SECRET_STORAGE = True
WEBSERVER_AUTO_CREATE_USER = True
WEBSERVER_REMOTE_USER = "REMOTE_USER"
WEB_SERVER = "Python"
WTF_CSRF_HEADERS = ['X-pgA-CSRFToken']
X_CONTENT_TYPE_OPTIONS = "nosniff"
X_FRAME_OPTIONS = "SAMEORIGIN"
X_XSS_PROTECTION = "1; mode=block"

[akshay-joshi]

Hi @InceptusSolutions and @simon-kempster

I just tried the upgrade scenario from v9.1 to v9.2 on Windows 11 but was unable to reproduce the issue. Regarding opening the Query History every time, pgAdmin remembers the last open tab (I need to confirm). Please try running some queries from the Query Editor and Launching the new Query Tool.

Screen Recording: