Comments (4)
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'
from pgadmin4.
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
from pgadmin4.
@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.
from pgadmin4.
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.
from pgadmin4.
Related Issues (20)
- cursor moves to end of line when editing input fields
- GUI anomaly v8.11.0 for pgAdmin4 (Grid view turned into full width columns / just rows / non-scrollable data) HOT 9
- Filter on database listing HOT 1
- pgAdmin4 Debugger Window UI Controls
- Single responsibility principle for the SchemaView and DataGridView HOT 2
- Enable PgAdmin to cope with Citus-sharding query plans HOT 1
- Fully documented list of json values for preferences.json HOT 1
- Suggestion: Allow disabling the confirmation on application exit HOT 1
- Grant Wizard needs an option to revoke / edit privileges
- Auto refresh of Object Explorer on when updating objects HOT 2
- Use a common class in place of SchemaDiffRegistry class for getting the Object node view
- pgadmin v8.11 the different client backend But all SQL are same
- unexpected cursor jump when editing text HOT 2
- [Docker] Email validation does not use custom configuration HOT 3
- pgAdmin v8.11 freezes when State panel is opened HOT 1
- When running an aws command with "Password exec command," get error "/bin/sh: aws: command not found" HOT 1
- Automatically update foreign key creation statement according to the new fk column name. HOT 1
- Support system option for sslrootcert
- Cursor position goes to end when editing Table Field/Constrait HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgadmin4.