PG Admin Won't Load

[psMoveMyDocs]

PG Admin Won't Load

[psMoveMyDocs]

Here is the log that shows when it fails to load.

pgAdmin Runtime Environment

Python Path: "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\tech\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\tech\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment:

• ALLUSERSPROFILE: C:\ProgramData
• APPDATA: C:\Users\tech\AppData\Roaming
• CommonProgramFiles: C:\Program Files\Common Files
• CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
• CommonProgramW6432: C:\Program Files\Common Files
• COMPUTERNAME: PC8
• ComSpec: C:\Windows\system32\cmd.exe
• DriverData: C:\Windows\System32\Drivers\DriverData
• EFC_8836: 1
• ELECTRON_ENABLE_SECURITY_WARNINGS: false
• HOMEDRIVE: C:
• HOMEPATH: \Users\tech
• IGCCSVC_DB: AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAADdEAdJ+lQ0CdbwIW/Qga3QQAAAACAAAAAAAQZgAAAAEAACAAAABEyyH7cq6uAmgxcxjMfkNPko1hZCLZ+16iY+1piWGdtQAAAAAOgAAAAAIAACAAAAC/0j4pQltndTWeFTwC23576K6aRLYV7q3x2zPKncf1x2AAAAAo+4Sh2uI1DJkoD725EgQAyV6+Azvi7uAuXQB0P4H1WMPAnhf1HQO0zFSSaHTBBIt6eaSImmkDIGVJIwB/FXjeDUveO9J3Mw/V1jskdMMCXjpbKqw+GakKPgYZTZH8/rJAAAAA6YjLDOPXdrNECXMOEpgL7WNgTcG1jYYoP2bDteRu7GZMc2A4jY2xxKj1ZTRNq6zEZ/xlEqyxQ5W4D3ewHkC6nA==
• LOCALAPPDATA: C:\Users\tech\AppData\Local
• LOGONSERVER: \PC8
• NUMBER_OF_PROCESSORS: 28
• OneDrive: C:\Users\tech\OneDrive
• ORIGINAL_XDG_CURRENT_DESKTOP: undefined
• OS: Windows_NT
• Path: C:\Users\tech\AppData\Local\Programs\pgAdmin 4\runtime;C:\Program Files (x86)\Common Files\Oracle\Java\java8path;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Windows\System32\OpenSSH;C:\Program Files\dotnet;C:\Users\tech\AppData\Local\Microsoft\WindowsApps;
• PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
• PGADMIN_INT_KEY: a02dad74-d260-474c-859d-fecd9befbee0
• PGADMIN_INT_PORT: 50599
• PGADMIN_SERVER_MODE: OFF
• PROCESSOR_ARCHITECTURE: AMD64
• PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 183 Stepping 1, GenuineIntel
• PROCESSOR_LEVEL: 6
• PROCESSOR_REVISION: b701
• 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
• SystemDrive: C:
• SystemRoot: C:\Windows
• TEMP: C:\Users\tech\AppData\Local\Temp
• TMP: C:\Users\tech\AppData\Local\Temp
• USERDOMAIN: pc8
• USERDOMAIN_ROAMINGPROFILE: pc8
• USERNAME: tech
• USERPROFILE: C:\Users\tech
• windir: C:\Windows
• ZES_ENABLE_SYSMAN: 1

---

Total spawn time to start the pgAdmin4 server: 0.004 Sec
2024-09-05 19:19:55,608: ERROR pgadmin: Table(s) ['user_mfa'] are missing in the database
Traceback (most recent call last):
File "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in

app = create_app()
      ^^^^^^^^^^^^

File "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\web\pgadmin_init_.py", line 473, in create_app
run_migration_for_sqlite()
File "C:\Users\tech\AppData\Local\Programs\pgAdmin 4\web\pgadmin_init_.py", line 440, in run_migration_for_sqlite
backup_db_file()
File "C:\Users\tech\AppData\Local\Programs\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\tech\AppData\Roaming\pgAdmin\pgadmin4.db' -> 'C:\Users\tech\AppData\Roaming\pgAdmin\pgadmin4.db.20240905191955'

[psMoveMyDocs]

in Pgadmin4 db log... ("C:\Users\tech\AppData\Roaming\pgAdmin\pgadmin4.log")
Error recorded...
2024-09-05 20:46:35,132: ERROR pgadmin: Table(s) ['user_mfa'] are missing in the database

[yogeshmahajan-1903]

@psMoveMyDocs
Do you have any other pgadmin installation? (Check in the uninstall program list). Can you please try take backup of %APPDATA%/pgAdmin/pgadmin4.db and then delete it(this will erase any saved data with pgadmin) and try reopening pgadmin.

[psMoveMyDocs]

I was able to resolve the issue. I deleted this file "C:\Users\tech\AppData\Roaming\pgAdmin\pgadmin4.db" and then relaunched PG Admin. The software recreated the file when it launched and then PGAdmin loaded fine.

It looks like the installer created that file incorrectly, but the software was able to recreate it correctly after I deleted it.