public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rajesh Jatav <[email protected]>
To: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Showing error while starting PgAdmin4
Date: Fri, 13 Sep 2024 14:54:47 -0700
Message-ID: <CABy0y6izm_9wYBiiS6oiPAiyKOpSW7kCNzEC2E1ATpsT=C_a4w@mail.gmail.com> (raw)

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'


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: <CABy0y6izm_9wYBiiS6oiPAiyKOpSW7kCNzEC2E1ATpsT=C_a4w@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