public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alex Escott <[email protected]>
To: [email protected] <[email protected]>
Subject: PgAdmin4 Runtime Environment Error
Date: Fri, 25 Oct 2024 14:08:37 +0000
Message-ID: <BL1PR12MB507973F4B69C9760ECE499DAE14F2@BL1PR12MB5079.namprd12.prod.outlook.com> (raw)
Hello,
Having issues with opening the PgAdmin4 application. Please see the error message attached. Would appreciate any help with this issue.
Thank you,
Alex Escott
Senior Auditor – Lead Data Analytics, Corporate Audit, IAS
3000 N Sam Houston Pkwy E
Houston, TX 77032
[email protected]<mailto:[email protected]>
[Halliburton]<https://www.halliburton.com/;
LinkedIn<http://www.linkedin.com/company/halliburton; | Instagram<https://www.instagram.com/halliburton; | YouTube<http://www.youtube.com/halliburton; | Twitter<http://www.twitter.com/halliburton; | Facebook<https://www.facebook.com/halliburton;
This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message.
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\h236962\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\h236962\AppData\Roaming
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: NTBK0020605
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- EFC_13212: 0
- ELECTRON_ENABLE_SECURITY_WARNINGS: false
- HOMEDRIVE: C:
- HOMEPATH: \Users\h236962
- LOCALAPPDATA: C:\Users\h236962\AppData\Local
- LOGONSERVER: \\NP2DCGC20
- NUMBER_OF_PROCESSORS: 12
- OneDrive: C:\Users\h236962\OneDrive - Halliburton
- OneDriveCommercial: C:\Users\h236962\OneDrive - Halliburton
- ORIGINAL_XDG_CURRENT_DESKTOP: undefined
- OS: Windows_NT
- Path: C:\Program Files\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X64\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X86\;C:\Program Files (x86)\Common Files\Pulse Secure\TNC Client Plugin\;C:\Users\h236962\AppData\Local\Microsoft\WindowsApps;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 740f75c0-671e-4ae1-b252-696fefc451b5
- PGADMIN_INT_PORT: 60509
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: AMD64 Family 25 Model 80 Stepping 0, AuthenticAMD
- PROCESSOR_LEVEL: 25
- PROCESSOR_REVISION: 5000
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SNC_LIB: C:\Program Files (x86)\Quest Software\VAS SSO for SAP\qgsskrb5.dll
- SNC_LIB_2: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SSF_LIBRARY_PATH: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SSF_LIBRARY_PATH_64: C:\Program Files\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\h236962\AppData\Local\Temp
- TMP: C:\Users\h236962\AppData\Local\Temp
- UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
- USERDNSDOMAIN: CORP.HALLIBURTON.COM
- USERDOMAIN: HALAMERICA
- USERDOMAIN_ROAMINGPROFILE: HALAMERICA
- USERNAME: H236962
- USERPROFILE: C:\Users\h236962
- windir: C:\WINDOWS
- __PSLockDownPolicy: 0
--------------------------------------------------------
Total spawn time to start the pgAdmin4 server: 0.013 Sec
2024-10-14 15:40:11,465: ERROR pgadmin: Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database
Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
app = create_app()
^^^^^^^^^^^^
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app
run_migration_for_sqlite()
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 440, in run_migration_for_sqlite
backup_db_file()
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20241014154011'
Attachments:
[image/png] Outlook-Halliburto.png (2.3K, 3-Outlook-Halliburto.png)
download | view image
[text/plain] pgAdmin Runtime Environment (2).txt (4.0K, 4-pgAdmin%20Runtime%20Environment%20%282%29.txt)
download | inline:
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\h236962\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\h236962\AppData\Roaming
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: NTBK0020605
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- EFC_13212: 0
- ELECTRON_ENABLE_SECURITY_WARNINGS: false
- HOMEDRIVE: C:
- HOMEPATH: \Users\h236962
- LOCALAPPDATA: C:\Users\h236962\AppData\Local
- LOGONSERVER: \\NP2DCGC20
- NUMBER_OF_PROCESSORS: 12
- OneDrive: C:\Users\h236962\OneDrive - Halliburton
- OneDriveCommercial: C:\Users\h236962\OneDrive - Halliburton
- ORIGINAL_XDG_CURRENT_DESKTOP: undefined
- OS: Windows_NT
- Path: C:\Program Files\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X64\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X86\;C:\Program Files (x86)\Common Files\Pulse Secure\TNC Client Plugin\;C:\Users\h236962\AppData\Local\Microsoft\WindowsApps;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 740f75c0-671e-4ae1-b252-696fefc451b5
- PGADMIN_INT_PORT: 60509
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: AMD64 Family 25 Model 80 Stepping 0, AuthenticAMD
- PROCESSOR_LEVEL: 25
- PROCESSOR_REVISION: 5000
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SNC_LIB: C:\Program Files (x86)\Quest Software\VAS SSO for SAP\qgsskrb5.dll
- SNC_LIB_2: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SSF_LIBRARY_PATH: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SSF_LIBRARY_PATH_64: C:\Program Files\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\h236962\AppData\Local\Temp
- TMP: C:\Users\h236962\AppData\Local\Temp
- UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
- USERDNSDOMAIN: CORP.HALLIBURTON.COM
- USERDOMAIN: HALAMERICA
- USERDOMAIN_ROAMINGPROFILE: HALAMERICA
- USERNAME: H236962
- USERPROFILE: C:\Users\h236962
- windir: C:\WINDOWS
- __PSLockDownPolicy: 0
--------------------------------------------------------
Total spawn time to start the pgAdmin4 server: 0.013 Sec
2024-10-14 15:40:11,465: ERROR pgadmin: Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database
Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
app = create_app()
^^^^^^^^^^^^
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app
run_migration_for_sqlite()
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 440, in run_migration_for_sqlite
backup_db_file()
File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20241014154011'
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: PgAdmin4 Runtime Environment Error
In-Reply-To: <BL1PR12MB507973F4B69C9760ECE499DAE14F2@BL1PR12MB5079.namprd12.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox