Re: Showing error while starting PgAdmin4

Hi,

Is this PostgreSQL 17 RC1 installer? on what windows version did you try
installing?

On Fri, Sep 13, 2024 at 8:29 PM Rajesh Jatav <rajesh1799bba(at)gmail(dot)com>
wrote:

> Please resolve the error.
>
>
>
>
>
>
> pgAdmin Runtime Environment
> --------------------------------------------------------
> Python Path: "C:\Program Files\PostgreSQL\17\pgAdmin 4\python\python.exe"
> Runtime Config File: "C:\Users\admin\AppData\Roaming\pgadmin4\config.json"
> Webapp Path: "C:\Program Files\PostgreSQL\17\pgAdmin 4\web\pgAdmin4.py"
> pgAdmin Command: "C:\Program Files\PostgreSQL\17\pgAdmin
> 4\python\python.exe -s C:\Program Files\PostgreSQL\17\pgAdmin
> 4\web\pgAdmin4.py"
> Environment:
> - ALLUSERSPROFILE: C:\ProgramData
> - APPDATA: C:\Users\admin\AppData\Roaming
> - CommonProgramFiles: C:\Program Files\Common Files
> - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
> - CommonProgramW6432: C:\Program Files\Common Files
> - COMPUTERNAME: DESKTOP-08ISC2C
> - ComSpec: C:\Windows\system32\cmd.exe
> - DriverData: C:\Windows\System32\Drivers\DriverData
> - ELECTRON_ENABLE_SECURITY_WARNINGS: false
> - HOMEDRIVE: C:
> - HOMEPATH: \Users\admin
> - LOCALAPPDATA: C:\Users\admin\AppData\Local
> - LOGONSERVER: \\DESKTOP-08ISC2C
> - NUMBER_OF_PROCESSORS: 4
> - OneDrive: C:\Users\admin\OneDrive
> - ORIGINAL_XDG_CURRENT_DESKTOP: undefined
> - OS: Windows_NT
> - Path: C:\Program Files\PostgreSQL\17\pgAdmin
> 4\runtime;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Users\admin\AppData\Local\Microsoft\WindowsApps
> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
> - PGADMIN_INT_KEY: de80d09e-709c-42ca-b2ea-2890b8350676
> - PGADMIN_INT_PORT: 5032
> - PGADMIN_SERVER_MODE: OFF
> - PROCESSOR_ARCHITECTURE: AMD64
> - PROCESSOR_IDENTIFIER: AMD64 Family 22 Model 48 Stepping 1, AuthenticAMD
> - PROCESSOR_LEVEL: 22
> - PROCESSOR_REVISION: 3001
> - 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
> - SystemDrive: C:
> - SystemRoot: C:\Windows
> - TEMP: C:\Users\admin\AppData\Local\Temp
> - TMP: C:\Users\admin\AppData\Local\Temp
> - USERDOMAIN: DESKTOP-08ISC2C
> - USERDOMAIN_ROAMINGPROFILE: DESKTOP-08ISC2C
> - USERNAME: admin
> - USERPROFILE: C:\Users\admin
> - windir: C:\Windows
> --------------------------------------------------------
>
> Total spawn time to start the pgAdmin4 server: 0.026 Sec
> 2024-09-13 14:47:47,761: ERROR pgadmin: Table(s) ['user_mfa'] are missing
> in the database
>
> Traceback (most recent call last):
> File "C:\Program Files\PostgreSQL\17\pgAdmin 4\web\pgAdmin4.py", line
> 103, in <module>
> app = create_app()
> ^^^^^^^^^^^^
> File "C:\Program Files\PostgreSQL\17\pgAdmin 4\web\pgadmin\__init__.py",
> line 473, in create_app
> run_migration_for_sqlite()
> File "C:\Program Files\PostgreSQL\17\pgAdmin 4\web\pgadmin\__init__.py",
> line 440, in run_migration_for_sqlite
> backup_db_file()
> File "C:\Program Files\PostgreSQL\17\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\\admin\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' ->
> 'C:\\Users\\admin\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240913144747'
>
>

--
Sandeep Thakkar