Re: Issue with PgAdmin

[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"