public inbox for [email protected]
help / color / mirror / Atom feedShowing error while starting PgAdmin4
4+ messages / 3 participants
[nested] [flat]
* Showing error while starting PgAdmin4
@ 2024-09-13 21:54 Rajesh Jatav <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Jatav @ 2024-09-13 21:54 UTC (permalink / raw)
To: pgadmin-support; +Cc: [email protected]; [email protected]; [email protected]
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Showing error while starting PgAdmin4
@ 2024-09-18 10:33 Sandeep Thakkar <[email protected]>
parent: Rajesh Jatav <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Sandeep Thakkar @ 2024-09-18 10:33 UTC (permalink / raw)
To: Rajesh Jatav <[email protected]>; +Cc: pgadmin-support; [email protected]; Manika Singhal <[email protected]>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Showing error while starting PgAdmin4
@ 2024-09-18 16:36 Anthony DeBarros <[email protected]>
parent: Sandeep Thakkar <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Anthony DeBarros @ 2024-09-18 16:36 UTC (permalink / raw)
To: Sandeep Thakkar <[email protected]>; +Cc: Rajesh Jatav <[email protected]>; pgadmin-support; [email protected]; Manika Singhal <[email protected]>
On Wed, Sep 18, 2024 at 6:35 AM Sandeep Thakkar <
[email protected]> wrote:
> Hi,
>
> Is this PostgreSQL 17 RC1 installer? on what windows version did you try
> installing?
>
>
A reader of my book just contacted me about the same issue. They initially
installed 17 RC1 then downgraded to 16.4 and it's still occurring.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Showing error while starting PgAdmin4
@ 2024-09-18 17:40 Rajesh Jatav <[email protected]>
parent: Anthony DeBarros <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Rajesh Jatav @ 2024-09-18 17:40 UTC (permalink / raw)
To: Anthony DeBarros <[email protected]>; +Cc: Sandeep Thakkar <[email protected]>; pgadmin-support; [email protected]; Manika Singhal <[email protected]>
I am also facing same problem.
On Wed, 18 Sept, 2024, 10:07 pm Anthony DeBarros, <
[email protected]> wrote:
>
> On Wed, Sep 18, 2024 at 6:35 AM Sandeep Thakkar <
> [email protected]> wrote:
>
>> Hi,
>>
>> Is this PostgreSQL 17 RC1 installer? on what windows version did you try
>> installing?
>>
>>
> A reader of my book just contacted me about the same issue. They initially
> installed 17 RC1 then downgraded to 16.4 and it's still occurring.
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-09-18 17:40 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-13 21:54 Showing error while starting PgAdmin4 Rajesh Jatav <[email protected]>
2024-09-18 10:33 ` Sandeep Thakkar <[email protected]>
2024-09-18 16:36 ` Anthony DeBarros <[email protected]>
2024-09-18 17:40 ` Rajesh Jatav <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox