Re: pgAdmin 4 not starting after upgrade to 6.4

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: Dave Caughey <caugheyd(at)gmail(dot)com>
Cc: Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>, Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin 4 not starting after upgrade to 6.4
Date: 2022-01-21 05:58:17
Message-ID: CANxoLDd32SLB7L1Obv8ccnWqxv-FwqZrNPTNTsAhJW5y=SL7vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Dave

On Fri, Jan 21, 2022 at 12:38 AM Dave Caughey <caugheyd(at)gmail(dot)com> wrote:

> But recent versions of pgAdmin *have* been running on Windows 7. Over the
> years I've religiously updated throughout v4, v5 and v6 (up until v6.2) and
> it's been running perfectly fine up until I upgraded from v6.2 -> 6.4
> yesterday.
>
> And I've tried reinstalling v6.2, but I'm now getting the same error. So
> clearly it's just a configuration issue or compatibility issue with some
> other component (e.g., python 3.8) because it was able to run yesterday.
>
> But looking back through my email history, I see I did have a problem
> updating to v5.0, that Dave Page kindly resolved. I don't know if what I'm
> now experiencing is the same issue, but is there a similar work
> around, given that v6.2 was working perfectly fine yesterday? I'd be
> happy to freeze at v6.2, if that's really the last version, but please
> don't make me go back to v4.30!
>

As per the log and initial investigation, it seems NWjs is crashing, to
confirm the issue I have posted this behavior on NWjs gitter "
https://gitter.im/nwjs/nw.js" Refer to the below screenshot:

[image: Screenshot 2022-01-21 at 11.12.57 AM.png]

It seems that some of the third-party libraries cause the NWjs(pgAdmin4
) application to crash. The difference between 6.2 and 6.4 is, we have
released 6.2 with Python 3.8 while 6.4 with Python 3.10 that could be the
issue here. I checked https://www.python.org/downloads/windows/ and it is
clearly mentioned that "Note that Python 3.10.0 *cannot* be used on Windows
7 or earlier."

Give us some time I am not sure what could be the solution at the
moment.

>
> Cheers,
> Dave
> ----------------- previous thread ------------------
>
> On Thu, Feb 25, 2021 at 3:30 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>>
>>
>> On Thu, Feb 25, 2021 at 3:13 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>>
>>>
>>> On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey <caugheyd(at)gmail(dot)com> wrote:
>>>
>>>> Here's what happens when I run the command on the terminal.
>>>>
>>>> [image: image.png]
>>>>
>>>> But... pgAdmin v4.30 runs fine.
>>>>
>>>
>>> So I believe the issue is that Python 3.9 has dropped support for
>>> Windows 7 and earlier, something which I for one didn't realise until I
>>> started looking into this (see https://www.python.org/downloads/windows/
>>> ).
>>>
>>> I've kicked off a build using Python 3.8 for testing. That claims to
>>> support back to Vista. I'll send a link once it's done.
>>>
>>
>> Here's the Python 3.8 based test build. Note that I haven't tested it at
>> all - I just kicked off the normal build process but told it to use 3.8
>> instead of 3.9.
>>
>>
>> https://developer.pgadmin.org/builds/2021-02-25python38-1/pgadmin4-5.0-x64.exe
>>
>> Please let us know if it works on Windows 7.
>>
>
> Dave told me offlist that it's working for him.
>
> So, we need to think about how long we'll support Windows 7. Sooner or
> later we will have to update Python... :-(
>
> Cheers,
> Dave
>
>
> On Thu, Jan 20, 2022 at 1:32 PM Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>
> wrote:
>
>> Hi Dave Caughey!
>>
>> We have dropped the Windows 7 and Windows 2008R2 64 bit support. Can you
>> please upgrade your system? We have dropped the Windows 7 and Windows
>> 2008R2 64 bit support as per link below:
>>
>> https://www.pgadmin.org/download/pgadmin-4-windows/
>>
>> pgAdmin is available for 64 bit Windows™ 7 SP1 (desktop) or 2008R2
>> (server) and above, up to v4.30.
>>
>> v5.0 and later are supported on Windows 8 (desktop) or 2012 (server) and
>> above.
>>
>> 32 bit Windows support is available for versions up to v4.29.
>> Thanks,
>>
>> Kind Regards,
>>
>> On Thu, Jan 20, 2022 at 6:43 PM Dave Caughey <caugheyd(at)gmail(dot)com> wrote:
>>
>>> I still get the same message after a complete uninstall/reinstall.
>>>
>>> I am on Windows 7 SP1
>>>
>>> Cheers,
>>> Dave
>>>
>>>
>>> On Thu, Jan 20, 2022 at 12:04 AM Fahar Abbas <
>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Dave Caughey,
>>>>
>>>> I am not able to reproduce the issue.
>>>>
>>>> How I tested:
>>>>
>>>> 1. Installed pgadmin4 6.2
>>>> 2. Launch pgAdmin4
>>>> 3. close pgAdmin4
>>>> 4. Installed pgadmin4 6.4
>>>> 5. Launch pgadmin4
>>>> 6. No issue found
>>>>
>>>> Can you please uninstall pgadmin4 from the control panel and try to
>>>> install pgadmin4 6.4 again?
>>>>
>>>>
>>>> On Thu, Jan 20, 2022 at 12:59 AM Dave Caughey <caugheyd(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> After upgrading from 6.2 to 6.4, when I start pgAdmin I get an
>>>>>
>>>>> "The pgAdmin 4 server could not be contacted"
>>>>>
>>>>> message, with the environment details shown below.
>>>>>
>>>>> I have tried re-installing pgadmin4-6.4-x64.exe, and tried rebooting
>>>>> windows.
>>>>>
>>>>> Should I uninstall some component and reinstall? Or? And if you need
>>>>> any logs, please let me know where to grab them.
>>>>>
>>>>> Thanks,
>>>>> Dave
>>>>>
>>>>> pgAdmin Runtime Environment
>>>>> --------------------------------------------------------
>>>>> Python Path: "C:\Users\User\AppData\Local\Programs\pgAdmin
>>>>> 4\v6\python\python.exe"
>>>>> Runtime Config File:
>>>>> "C:\Users\User\AppData\Roaming\pgadmin\runtime_config.json"
>>>>> pgAdmin Config File: "C:\Users\User\AppData\Local\Programs\pgAdmin
>>>>> 4\v6\web\config.py"
>>>>> Webapp Path: "C:\Users\User\AppData\Local\Programs\pgAdmin
>>>>> 4\v6\web\pgAdmin4.py"
>>>>> pgAdmin Command: "C:\Users\User\AppData\Local\Programs\pgAdmin
>>>>> 4\v6\python\python.exe -s C:\Users\User\AppData\Local\Programs\pgAdmin
>>>>> 4\v6\web\pgAdmin4.py"
>>>>> Environment:
>>>>> - ALLUSERSPROFILE: C:\ProgramData
>>>>> - APPDATA: C:\Users\User\AppData\Roaming
>>>>> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_1836_DIKKTZARVGRVNIBP
>>>>> - 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: USER-PC
>>>>> - ComSpec: C:\Windows\system32\cmd.exe
>>>>> - FP_NO_HOST_CHECK: NO
>>>>> - HOMEDRIVE: C:
>>>>> - HOMEPATH: \Users\User
>>>>> - JAVA_HOME: C:\Program Files\Java\jdk1.8.0_271
>>>>> - LOCALAPPDATA: C:\Users\User\AppData\Local
>>>>> - LOGONSERVER: \\USER-PC
>>>>> - NUMBER_OF_PROCESSORS: 4
>>>>> - OS: Windows_NT
>>>>> - Path: C:\Program Files (x86)\Common
>>>>> Files\Oracle\Java\javapath;"C:\Program Files
>>>>> (x86)\Java\jre7\bin";C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program
>>>>> Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program
>>>>> Files\PuTTY\;C:\Program Files\Git\cmd
>>>>> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>>>>> - PGADMIN_INT_KEY: d02a954c-b93a-445b-b57b-ff2764541239
>>>>> - PGADMIN_INT_PORT: 61303
>>>>> - PGADMIN_SERVER_MODE: OFF
>>>>> - PROCESSOR_ARCHITECTURE: AMD64
>>>>> - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 58 Stepping 9,
>>>>> GenuineIntel
>>>>> - PROCESSOR_LEVEL: 6
>>>>> - PROCESSOR_REVISION: 3a09
>>>>> - 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
>>>>> - SESSIONNAME: Console
>>>>> - SystemDrive: C:
>>>>> - SystemRoot: C:\Windows
>>>>> - TEMP: C:\Users\User\AppData\Local\Temp
>>>>> - TMP: C:\Users\User\AppData\Local\Temp
>>>>> - USERDOMAIN: User-PC
>>>>> - USERNAME: User
>>>>> - USERPROFILE: C:\Users\User
>>>>> - windir: C:\Windows
>>>>> - windows_tracing_flags: 3
>>>>> - windows_tracing_logfile:
>>>>> C:\BVTBin\Tests\installpackage\csilogfile.log
>>>>> --------------------------------------------------------
>>>>>
>>>>>
>>>>> Cheers,
>>>>> Dave
>>>>>
>>>>
>>>>
>>>> --
>>>> Fahar Abbas
>>>> pgAdmin4 team
>>>> EnterpriseDB Corporation
>>>> Mobile: +92-333-5409707
>>>> Skype ID: *live:fahar.abbas*
>>>> Website: www.enterprisedb.com
>>>>
>>>
>>
>> --
>> Fahar Abbas
>> pgAdmin4 team
>> EnterpriseDB Corporation
>> Mobile: +92-333-5409707
>> Skype ID: *live:fahar.abbas*
>> Website: www.enterprisedb.com
>>
>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Fahar Abbas 2022-01-21 07:11:28 Re: Require assistance to install pgadmin software
Previous Message Khushboo Vashi 2022-01-21 04:31:32 Re: PGAdmin - psql tool issue