Re: Issue with PgAdmin

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Vivek Parmar <vp393001(at)gmail(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Issue with PgAdmin
Date: 2020-01-07 07:41:23
Message-ID: CAM9w-_=khfC1=0fo9qbHZuVRaAzzUkG8nXn8XWfr2CwOiGvxOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi Vivek,

That's strange. It should not take that amount of time.
Can you try disabling firewall once ? I suspect the port used by pgAdmin is
blocked by firewall.

On Tue, Jan 7, 2020 at 12:51 PM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:

> Hi Aditya,
>
> It is still not working. I tried with 3000 value too. Here are the logs:
>
> 07.01.2020 12:41:46 Checking for system tray...
>> 07.01.2020 12:41:46 Starting pgAdmin4 server...
>> 07.01.2020 12:41:46 Creating server object, port:53102,
>> key:70fc2f32-3034-4b33-bf21-6c23cd3138b8,
>> logfile:C:/Users/vivek/.pgAdmin4.4018626542.log
>> 07.01.2020 12:41:46 Python Path: S:/Program Files/PostgreSQL/12/pgAdmin
>> 4/venv/Lib/site-packages;S:/Program Files/PostgreSQL/12/pgAdmin
>> 4/venv/DLLs;S:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib
>> 07.01.2020 12:41:46 Python Home: S:/Program Files/PostgreSQL/12/pgAdmin
>> 4/venv
>> 07.01.2020 12:41:46 Initializing Python...
>> 07.01.2020 12:41:46 Python initialized.
>> 07.01.2020 12:41:46 Adding new additional path elements
>> 07.01.2020 12:41:46 Redirecting stderr...
>> 07.01.2020 12:41:46 stderr redirected successfully.
>> 07.01.2020 12:41:46 Initializing server...
>> 07.01.2020 12:41:46 Webapp Path: S:/Program Files/PostgreSQL/12/pgAdmin
>> 4/web/pgAdmin4.py
>> 07.01.2020 12:41:46 Server initialized.
>> 07.01.2020 12:41:46 Starting Server Thread...
>> 07.01.2020 12:41:46 Open the application code and run it.
>> 07.01.2020 12:41:46 Set the port number, key and force SERVER_MODE off
>> 07.01.2020 12:41:46 PyRun_SimpleFile launching application server...
>> 07.01.2020 12:41:47 Application Server URL:
>> http://127.0.0.1:53102/?key=70fc2f32-3034-4b33-bf21-6c23cd3138b8
>> 07.01.2020 12:41:47 The server should be up, we'll attempt to connect and
>> get a response. Ping the server
>> 07.01.2020 12:47:19 Attempt to connect one more time in case of a long
>> network timeout while looping
>>
>
> On Tue, Jan 7, 2020 at 12:02 PM Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>
>> [please do not remove pgadmin-hackers from cc]
>>
>> Hi Vivek,
>>
>> Seems like pgAdmin is timing out on your system. It is taking longer than
>> 90 secs for server to start. It generally happens on windows systems where
>> sqlite3 (which is used by pgAdmin config) takes a lot of time to initialize.
>> Try the following:
>> 1) Open regedit.
>> 2) Go to HKEY_CURRENT_USER/Software/pgadmin/pgadmin4 and create a new
>> string value - ConnectionTimeout. Set the value to 300.
>> 3) Start pgAdmin.
>> Try increasing timeout if it still fails.
>>
>>
>> On Tue, Jan 7, 2020 at 10:49 AM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:
>>
>>> I already checked that file but it is empty.
>>>
>>> On Tue, Jan 7, 2020 at 10:26 AM Aditya Toshniwal <
>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Vivek,
>>>>
>>>> Kindly also share - C:/Users/vivek/.pgAdmin4.4018626542.log
>>>>
>>>> On Mon, Jan 6, 2020 at 9:01 PM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:
>>>>
>>>>> Hi Aditya,
>>>>>
>>>>> Here it is:
>>>>>
>>>>> 06.01.2020 16:47:22 Checking for system tray...
>>>>>> 06.01.2020 16:47:22 Starting pgAdmin4 server...
>>>>>> 06.01.2020 16:47:22 Creating server object, port:50920,
>>>>>> key:8f41a047-ebc0-4ab4-a684-d2d8c1e1e819,
>>>>>> logfile:C:/Users/vivek/.pgAdmin4.4018626542.log
>>>>>> 06.01.2020 16:47:22 Python Path: S:/Program
>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-packages;S:/Program
>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/DLLs;S:/Program
>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/Lib
>>>>>> 06.01.2020 16:47:22 Python Home: S:/Program
>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv
>>>>>> 06.01.2020 16:47:22 Initializing Python...
>>>>>> 06.01.2020 16:47:22 Python initialized.
>>>>>> 06.01.2020 16:47:22 Adding new additional path elements
>>>>>> 06.01.2020 16:47:22 Redirecting stderr...
>>>>>> 06.01.2020 16:47:22 stderr redirected successfully.
>>>>>> 06.01.2020 16:47:22 Initializing server...
>>>>>> 06.01.2020 16:47:22 Webapp Path: S:/Program
>>>>>> Files/PostgreSQL/12/pgAdmin 4/web/pgAdmin4.py
>>>>>> 06.01.2020 16:47:22 Server initialized.
>>>>>> 06.01.2020 16:47:22 Starting Server Thread...
>>>>>> 06.01.2020 16:47:22 Open the application code and run it.
>>>>>> 06.01.2020 16:47:22 Set the port number, key and force SERVER_MODE off
>>>>>> 06.01.2020 16:47:22 PyRun_SimpleFile launching application server...
>>>>>> 06.01.2020 16:47:23 Application Server URL:
>>>>>> http://127.0.0.1:50920/?key=8f41a047-ebc0-4ab4-a684-d2d8c1e1e819
>>>>>> 06.01.2020 16:47:23 The server should be up, we'll attempt to connect
>>>>>> and get a response. Ping the server
>>>>>> 06.01.2020 16:49:32 Attempt to connect one more time in case of a
>>>>>> long network timeout while looping
>>>>>>
>>>>>
>>>>> On Mon, Jan 6, 2020 at 4:58 PM Aditya Toshniwal <
>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Hi Vivek,
>>>>>>
>>>>>> As I mentioned - you'll find the logs in the users home directory eg
>>>>>> - "C:\Users\Aditya Toshniwal". Kindly send the logs.
>>>>>>
>>>>>> On Mon, Jan 6, 2020 at 4:54 PM Vivek Parmar <vp393001(at)gmail(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Aditya,
>>>>>>>
>>>>>>> I am unable to find out the pgadmin logs file in the windows system.
>>>>>>> I've attached the error screenshot.
>>>>>>>
>>>>>>> On Mon, Jan 6, 2020 at 3:57 PM Aditya Toshniwal <
>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> Hi Vivek,
>>>>>>>>
>>>>>>>> Since it is not able to start, kindly share .pgAdmin4* logs from
>>>>>>>> your user home directory.
>>>>>>>>
>>>>>>>> On Mon, Jan 6, 2020 at 3:55 PM Janus <janus(dot)e(at)gmail(dot)com> wrote:
>>>>>>>>
>>>>>>>>> Hi Vivek
>>>>>>>>>
>>>>>>>>> Do you get the same error message using another browser, such as
>>>>>>>>> Chrome?
>>>>>>>>>
>>>>>>>>> Best regards,
>>>>>>>>> Janus
>>>>>>>>>
>>>>>>>>> On Mon, 6 Jan 2020 at 11:20, Vivek Parmar <vp393001(at)gmail(dot)com>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Dear PgAdmin Development Team,
>>>>>>>>>>
>>>>>>>>>> I am unable to run pgadmin on my windows 10 laptop. I am getting
>>>>>>>>>> the below error.
>>>>>>>>>>
>>>>>>>>>> Fatal error:
>>>>>>>>>> The application server could not be contacted.
>>>>>>>>>>
>>>>>>>>>> I tried reinstalling software and also cleared the session from
>>>>>>>>>> the AppData folder.
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> *Regards,*
>>>>>>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Thanks and Regards,
>>>>>>>> Aditya Toshniwal
>>>>>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> *Regards,*
>>>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thanks and Regards,
>>>>>> Aditya Toshniwal
>>>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Regards,*
>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>
>>>>
>>>>
>>>> --
>>>> Thanks and Regards,
>>>> Aditya Toshniwal
>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>> "Don't Complain about Heat, Plant a TREE"
>>>>
>>>
>>>
>>> --
>>> *Regards,*
>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>
>>
>>
>> --
>> Thanks and Regards,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
> *Regards,*
> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Vivek Parmar 2020-01-07 09:20:20 Re: Issue with PgAdmin
Previous Message Vivek Parmar 2020-01-07 07:21:36 Re: Issue with PgAdmin

Browse pgadmin-support by date

  From Date Subject
Next Message Vivek Parmar 2020-01-07 09:20:20 Re: Issue with PgAdmin
Previous Message Vivek Parmar 2020-01-07 07:21:36 Re: Issue with PgAdmin