Обсуждение: Fatal Error

Поиск
Список
Период
Сортировка

Fatal Error

От
Durai Raj
Дата:
Hi Support Team,

Am facing an error below, when I am trying to open a pgAdmin application upon installation. Please find a Traceback and help me to resolve the issue asap.

Fatal Error
---------------

The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\v5\python\python.exe"
Runtime Config File: "C:\Users\user\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\pgAdmin 4\v5\web\config.py"
Webapp Path: "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\v5\python\python.exe -s C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\user\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7784_RLPSVXJGZLPKGNHB
  - 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: OMLT0009
  - ComSpec: C:\Windows\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\user
  - LOCALAPPDATA: C:\Users\user\AppData\Local
  - LOGONSERVER: \\OMLT0009
  - NUMBER_OF_PROCESSORS: 8
  - OneDrive: C:\Users\user\OneDrive
  - OneDriveConsumer: C:\Users\user\OneDrive
  - OS: Windows_NT
  - Path: C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Users\user\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python39\;C:\Users\user\AppData\Local\Microsoft\WindowsApps;C:\Users\user\.dotnet\tools;C:\Program Files\Azure Data Studio\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: f2718e3f-e66a-47e0-ba1c-4e4020105e4d
  - PGADMIN_INT_PORT: 56458
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 10, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 8e0a
  - 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;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\Windows
  - TEMP: C:\Users\user\AppData\Local\Temp
  - TMP: C:\Users\user\AppData\Local\Temp
  - USERDOMAIN: OMLT0009
  - USERDOMAIN_ROAMINGPROFILE: OMLT0009
  - USERNAME: user
  - USERPROFILE: C:\Users\user
  - windir: C:\Windows
--------------------------------------------------------

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


Regards,
Durai Raj G
Cell: +91 99 44 225432

Re: Fatal Error

От
pgadminsucks
Дата:
same issue here. I also see many forums reporting the issue with pgadmin 4.
Hope these guys resolve it at the earliest.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html



Re: Fatal Error

От
Akshay Joshi
Дата:
Hi Durai

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 Durai Raj <ganesdurai@gmail.com> wrote:
Hi Support Team,

Am facing an error below, when I am trying to open a pgAdmin application upon installation. Please find a Traceback and help me to resolve the issue asap.

Fatal Error
---------------

The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\pgAdmin 4\v5\python\python.exe"
Runtime Config File: "C:\Users\user\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\pgAdmin 4\v5\web\config.py"
Webapp Path: "C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\pgAdmin 4\v5\python\python.exe -s C:\Program Files\pgAdmin 4\v5\web\pgAdmin4.py"
Environment:
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\user\AppData\Roaming
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7784_RLPSVXJGZLPKGNHB
  - 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: OMLT0009
  - ComSpec: C:\Windows\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\user
  - LOCALAPPDATA: C:\Users\user\AppData\Local
  - LOGONSERVER: \\OMLT0009
  - NUMBER_OF_PROCESSORS: 8
  - OneDrive: C:\Users\user\OneDrive
  - OneDriveConsumer: C:\Users\user\OneDrive
  - OS: Windows_NT
  - Path: C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Users\user\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python39\;C:\Users\user\AppData\Local\Microsoft\WindowsApps;C:\Users\user\.dotnet\tools;C:\Program Files\Azure Data Studio\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: f2718e3f-e66a-47e0-ba1c-4e4020105e4d
  - PGADMIN_INT_PORT: 56458
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 10, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 8e0a
  - 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;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\Windows
  - TEMP: C:\Users\user\AppData\Local\Temp
  - TMP: C:\Users\user\AppData\Local\Temp
  - USERDOMAIN: OMLT0009
  - USERDOMAIN_ROAMINGPROFILE: OMLT0009
  - USERNAME: user
  - USERPROFILE: C:\Users\user
  - windir: C:\Windows
--------------------------------------------------------

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


Regards,
Durai Raj G
Cell: +91 99 44 225432



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

Re: Fatal Error

От
Akshay Joshi
Дата:
Hi 

We have figured out the issue, it is because of the latest version of the 'itsdangerous' python package which was released on 12th May. We are working on fixing the issue with EDB Installers. 

Meanwhile, you can perform the following steps:
  1. Take a backup of your 'pgadmin4.db' file which is present at the "%APPDATA%\Roaming\pgadmin" folder.
  2. Delete 'pgadmin4.db' file.
  3. Download pgAdmin4 v5.2 from https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/
  4. Install and Launch 'pgAdmin4 v5'.

On Tue, May 18, 2021 at 3:47 PM pgadminsucks <ecmpractitioner@gmail.com> wrote:
same issue here. I also see many forums reporting the issue with pgadmin 4.
Hope these guys resolve it at the earliest.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html




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