public inbox for [email protected]  
help / color / mirror / Atom feed
From: Sandeep Thakkar <[email protected]>
To: Rajesh Jatav <[email protected]>
Cc: [email protected]
Cc: [email protected]
Cc: Manika Singhal <[email protected]>
Subject: Re: Showing error while starting PgAdmin4
Date: Wed, 18 Sep 2024 16:03:28 +0530
Message-ID: <CANFyU97h92Fz_Y+-Kpc4Nih-ZEjsMZX=QdnJucxeP0WC18iROQ@mail.gmail.com> (raw)
In-Reply-To: <CABy0y6izm_9wYBiiS6oiPAiyKOpSW7kCNzEC2E1ATpsT=C_a4w@mail.gmail.com>
References: <CABy0y6izm_9wYBiiS6oiPAiyKOpSW7kCNzEC2E1ATpsT=C_a4w@mail.gmail.com>

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 <[email protected]>
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


Attachments:

  [image/png] Screenshot (1).png (386.0K, 3-Screenshot%20%281%29.png)
  download | view image

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], [email protected], [email protected], [email protected]
  Subject: Re: Showing error while starting PgAdmin4
  In-Reply-To: <CANFyU97h92Fz_Y+-Kpc4Nih-ZEjsMZX=QdnJucxeP0WC18iROQ@mail.gmail.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