Re: Fatal error starting PgAdmin 4 - Mailing list pgadmin-support

From Balapure, Sumedh
Subject Re: Fatal error starting PgAdmin 4
Date
Msg-id SA0P154MB0105147AF4474BF0CC1C12A4C82C9@SA0P154MB0105.NAMP154.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Fatal error starting PgAdmin 4  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Responses Re: Fatal error starting PgAdmin 4
List pgadmin-support
Hi Akshay,
Thanks for the quick response. 

I tried Postgres SQL 13 too. It's giving me the same problem. 
The versions are postgresql-12.7-1-windows-x64.exe, postgresql-13.3-1-windows-x64.exe

I deleted pgadmin.db file too, but still it's giving the same error.

Regards,

Sumedh R. Balapure,

Cell: +91-7770063134



From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: Tuesday, May 18, 2021 12:22 PM
To: Balapure, Sumedh <Sumedh.Balapure@contractor.tranetechnologies.com>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: Fatal error starting PgAdmin 4
 

Alert: This is an external email.

Hi Sumedh

Can you please specify the exact version of PostgreSQL 12 that you have installed? For example 12.x.x
The "pgadmin4.db" file can be found in the "%AppData%\Roaming\pgadmin" folder.

On Tue, May 18, 2021 at 12:01 PM Balapure, Sumedh <Sumedh.Balapure@contractor.tranetechnologies.com> wrote:
Hi Akshay,
It's a fresh installation. I am using it for the first time.

I cannot find file pgadmin4.db


Regards,

Sumedh R. Balapure,

Cell: +91-7770063134



From: Akshay Joshi <akshay.joshi@enterprisedb.com>
Sent: Tuesday, May 18, 2021 9:26 AM
To: Balapure, Sumedh <Sumedh.Balapure@contractor.tranetechnologies.com>
Cc: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Re: Fatal error starting PgAdmin 4
 

Alert: This is an external email.

Hi Sumedh

You can do the following to get rid of the error:
  • Take the backup of the 'pgadmin4.db' file and then delete it.
  • Restart the pgAdmin4
Have you upgraded your existing pgAdmin setup or it's a fresh installation?

On Mon, May 17, 2021 at 9:31 PM Balapure, Sumedh <Sumedh.Balapure@contractor.tranetechnologies.com> wrote:
Hi Team,
I have installed PostgreSQL 12 and while starting PgAdmin 4 I am getting Fatal error. Below is screenshot of error and details. Please help asap.



pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Sumedh\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\12\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\Sumedh\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5952_XBAUMQEIPHMCHBHF
  - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: SUMEDH-PC
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - C_EM64T_REDIST11: C:\Program Files (x86)\Common Files\Intel\Shared Files\cpp\
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - FP_NO_HOST_CHECK: NO
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\Sumedh
  - LOCALAPPDATA: C:\Users\Sumedh\AppData\Local
  - LOGONSERVER: \\SUMEDH-PC
  - NUMBER_OF_PROCESSORS: 4
  - OneDrive: C:\Users\Sumedh\OneDrive
  - OneDriveConsumer: C:\Users\Sumedh\OneDrive
  - OS: Windows_NT
  - Path: C:\Program Files (x86)\Common Files\Intel\Shared Files\cpp\bin\Intel64;C:\ProgramData\Oracle\Java\javapath;C:\orant\bin;C:\oracle\product\10.2.0\client_1\bin;c:\Program Files (x86)\Intel\iCLS Client\;c:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\orant\jdk\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\PostgreSQL\12\bin;C:\Users\Sumedh\AppData\Local\Microsoft\WindowsApps
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: 9dfe100a-97fe-41d8-b556-865e213bed55
  - PGADMIN_INT_PORT: 50584
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 4501
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
  - PUBLIC: C:\Users\Public
  - SynaProgDir: Synaptics\SynTP
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\Sumedh\AppData\Local\Temp
  - TMP: C:\Users\Sumedh\AppData\Local\Temp
  - USERDOMAIN: Sumedh-PC
  - USERDOMAIN_ROAMINGPROFILE: Sumedh-PC
  - USERNAME: Sumedh
  - USERPROFILE: C:\Users\Sumedh
  - windir: C:\WINDOWS
  - windows_tracing_flags: 3
  - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log
--------------------------------------------------------

Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line 98, in <module>
    app = create_app()
  File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app
    if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version
    return version.value
AttributeError: 'NoneType' object has no attribute 'value'




Regards,

Sumedh R. Balapure,

Cell: +91-7770063134



--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246



--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Principal Software Architect
EDB Postgres
Mobile: +91 976-788-8246

Attachment

pgadmin-support by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: Fatal error starting PgAdmin 4
Next
From: Rahul Shirsat
Date:
Subject: Re: The pgAdmin 4 server could not be contacted: