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'
