Re: Issue with PgAdmin
Aditya Toshniwal <[email protected]> Tue, 7 Jan 2020 12:01:44 +0530
| Newsgroups | gmane.comp.db.postgresql.pgadmin.devel |
|---|---|
| Message-ID | <CAM9w-_nCs4b392C403CRQCPP=74QLPdg2mspo14gN264iPvVLQ@mail.gmail.com> |
--0000000000001edc36059b86f0f4 Content-Type: text/plain; charset="UTF-8" [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 <[email protected]> wrote: > I already checked that file but it is empty. > > On Tue, Jan 7, 2020 at 10:26 AM Aditya Toshniwal < > [email protected]> wrote: > >> Hi Vivek, >> >> Kindly also share - C:/Users/vivek/.pgAdmin4.4018626542.log >> >> On Mon, Jan 6, 2020 at 9:01 PM Vivek Parmar <[email protected]> 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 < >>> [email protected]> 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 <[email protected]> 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 < >>>>> [email protected]> 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 <[email protected]> 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 <[email protected]> >>>>>>> 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" --0000000000001edc36059b86f0f4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,= sans-serif">[please do not remove pgadmin-hackers from cc]</div><div class= =3D"gmail_default" style=3D"font-family:verdana,sans-serif"><br></div><div = class=3D"gmail_default" style=3D"font-family:verdana,sans-serif">Hi Vivek,<= /div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif">= <br></div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-se= rif">Seems like pgAdmin is timing out on your system. It is taking longer t= han 90 secs for server to start. It generally happens on windows systems wh= ere sqlite3 (which is used by pgAdmin config) takes a lot of time to initia= lize.</div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-s= erif">Try the following:</div><div class=3D"gmail_default" style=3D"font-fa= mily:verdana,sans-serif">1) Open regedit.</div><div class=3D"gmail_default"= style=3D""><font face=3D"verdana, sans-serif">2) Go to HKEY_CURRENT_USER/S= oftware/pgadmin/pgadmin4 and create a new string value - ConnectionTimeout.= Set the value to 300.</font></div><div class=3D"gmail_default" style=3D"">= <font face=3D"verdana, sans-serif">3) Start pgAdmin.</font></div><div class= =3D"gmail_default" style=3D""><font face=3D"verdana, sans-serif">Try increa= sing timeout if it still fails.</font></div><div class=3D"gmail_default" st= yle=3D"font-family:verdana,sans-serif"><br></div></div><br><div class=3D"gm= ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jan 7, 2020 at 10:= 49 AM Vivek Parmar <<a href=3D"mailto:[email protected]">vp393001@gmail= .com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar= gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1= ex"><div dir=3D"ltr">I already checked that file but it is empty.</div><br>= <div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Ja= n 7, 2020 at 10:26 AM Aditya Toshniwal <<a href=3D"mailto:aditya.toshniw= [email protected]" target=3D"_blank">[email protected]</a= >> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px= 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di= v dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,san= s-serif">Hi Vivek,</div><div class=3D"gmail_default" style=3D"font-family:v= erdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-fam= ily:verdana,sans-serif">Kindly also share -=C2=A0<span style=3D"font-family= :Arial,Helvetica,sans-serif">C:/Users/vivek/.</span><span style=3D"font-fam= ily:Arial,Helvetica,sans-serif">pgAdmin4.4018626542.log</span></div></div><= br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon,= Jan 6, 2020 at 9:01 PM Vivek Parmar <<a href=3D"mailto:[email protected]= om" target=3D"_blank">[email protected]</a>> wrote:<br></div><blockquot= e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s= olid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi=C2=A0Aditya,<di= v><br></div><div>Here it is:</div><div><br></div><blockquote class=3D"gmail= _quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204= ,204);padding-left:1ex">06.01.2020 16:47:22 Checking for system tray...<br>= 06.01.2020 16:47:22 Starting pgAdmin4 server...<br>06.01.2020 16:47:22 Crea= ting server object, port:50920, key:8f41a047-ebc0-4ab4-a684-d2d8c1e1e819, l= ogfile:C:/Users/vivek/.pgAdmin4.4018626542.log<br>06.01.2020 16:47:22 Pytho= n 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<br>06.01.2020 16:47:22 Python Home: S:/Program Files= /PostgreSQL/12/pgAdmin 4/venv<br>06.01.2020 16:47:22 Initializing Python...= <br>06.01.2020 16:47:22 Python initialized.<br>06.01.2020 16:47:22 Adding n= ew additional path elements<br>06.01.2020 16:47:22 Redirecting stderr...<br= >06.01.2020 16:47:22 stderr redirected successfully.<br>06.01.2020 16:47:22= Initializing server...<br>06.01.2020 16:47:22 Webapp Path: S:/Program File= s/PostgreSQL/12/pgAdmin 4/web/pgAdmin4.py<br>06.01.2020 16:47:22 Server ini= tialized.<br>06.01.2020 16:47:22 Starting Server Thread...<br>06.01.2020 16= :47:22 Open the application code and run it.<br>06.01.2020 16:47:22 Set the= port number, key and force SERVER_MODE off<br>06.01.2020 16:47:22 PyRun_Si= mpleFile launching application server...<br>06.01.2020 16:47:23 Application= Server URL: <a href=3D"http://127.0.0.1:50920/?key=3D8f41a047-ebc0-4ab4-a6= 84-d2d8c1e1e819" target=3D"_blank">http://127.0.0.1:50920/?key=3D8f41a047-e= bc0-4ab4-a684-d2d8c1e1e819</a><br>06.01.2020 16:47:23 The server should be = up, we'll attempt to connect and get a response. Ping the server<br>06.= 01.2020 16:49:32 Attempt to connect one more time in case of a long network= timeout while looping<br></blockquote></div><br><div class=3D"gmail_quote"= ><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Jan 6, 2020 at 4:58 PM Adity= a Toshniwal <<a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a>> wrote:<br></div><bloc= kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:= 1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D= "gmail_default" style=3D"font-family:verdana,sans-serif">Hi Vivek,</div><di= v class=3D"gmail_default" style=3D"font-family:verdana,sans-serif"><br></di= v><div class=3D"gmail_default"><font face=3D"verdana, sans-serif">As I ment= ioned - you'll find the logs in the users home directory=C2=A0 eg - &qu= ot;C:\Users\Aditya Toshniwal". Kindly send the logs.</font></div></div= ><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mo= n, Jan 6, 2020 at 4:54 PM Vivek Parmar <<a href=3D"mailto:vp393001@gmail= .com" target=3D"_blank">[email protected]</a>> wrote:<br></div><blockqu= ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px= solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi Aditya,<div><= br></div><div>I am unable to find out the pgadmin=C2=A0logs file in the win= dows system. I've attached=C2=A0the error screenshot.=C2=A0</div></div>= <br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon= , Jan 6, 2020 at 3:57 PM Aditya Toshniwal <<a href=3D"mailto:aditya.tosh= [email protected]" target=3D"_blank">[email protected]= </a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:= 0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">= <div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,= sans-serif">Hi Vivek,</div><div class=3D"gmail_default" style=3D"font-famil= y:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-= family:verdana,sans-serif">Since it is not able to start, kindly share .pgA= dmin4* logs from your user home directory.</div></div><br><div class=3D"gma= il_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Jan 6, 2020 at 3:55= PM Janus <<a href=3D"mailto:[email protected]" target=3D"_blank">janus.= [email protected]</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style= =3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding= -left:1ex"><div dir=3D"ltr">Hi Vivek<div><br></div><div>Do you get the same= error=C2=A0message using another browser, such as Chrome?</div><div><br></= div><div>Best regards,</div><div>Janus</div></div><br><div class=3D"gmail_q= uote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 6 Jan 2020 at 11:20, Vi= vek Parmar <<a href=3D"mailto:[email protected]" target=3D"_blank">vp39= [email protected]</a>> wrote:<br></div><blockquote class=3D"gmail_quote" st= yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd= ing-left:1ex"><div dir=3D"ltr">Dear PgAdmin Development Team,<div><br></div= ><div>I am unable to run pgadmin on my windows 10 laptop. I am getting the = below error.</div><div><br></div><div>Fatal error:</div><div>The applicatio= n server could not be contacted.=C2=A0</div><div><br></div><div>I tried rei= nstalling software and also cleared the session from the AppData folder.=C2= =A0<br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"><div dir=3D"ltr= "><div><div dir=3D"ltr"><div><div dir=3D"ltr"><b>Regards,</b><div><b><a hre= f=3D"https://www.linkedin.com/in/vp393001/" target=3D"_blank">Vivek Parmar<= /a></b></div></div></div></div></div></div></div></div></div> </blockquote></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir= =3D"ltr"><div><div dir=3D"ltr"><font size=3D"2" color=3D"#000000" face=3D"v= erdana, sans-serif">Thanks and Regards,</font><div><span style=3D"backgroun= d-color:rgb(255,255,255)"><font size=3D"2" color=3D"#000000" face=3D"verdan= a, sans-serif">Aditya Toshniwal</font></span></div><div><font face=3D"verda= na, sans-serif"><span style=3D"background-color:rgb(255,255,255)"><font siz= e=3D"2" color=3D"#000000">pgAdmin Hacker | Sr. Software Engineer |=C2=A0Ent= erpriseDB India |=C2=A0</font></span><span style=3D"color:rgb(0,0,0)">Pune<= /span></font></div><div><font color=3D"#38761d" face=3D"verdana, sans-serif= " size=3D"1">"Don't Complain about Heat, Plant a TREE"</font>= </div></div></div></div></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><b>Regards,</= b><div><b><a href=3D"https://www.linkedin.com/in/vp393001/" target=3D"_blan= k">Vivek Parmar</a></b></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir= =3D"ltr"><div><div dir=3D"ltr"><font size=3D"2" color=3D"#000000" face=3D"v= erdana, sans-serif">Thanks and Regards,</font><div><span style=3D"backgroun= d-color:rgb(255,255,255)"><font size=3D"2" color=3D"#000000" face=3D"verdan= a, sans-serif">Aditya Toshniwal</font></span></div><div><font face=3D"verda= na, sans-serif"><span style=3D"background-color:rgb(255,255,255)"><font siz= e=3D"2" color=3D"#000000">pgAdmin Hacker | Sr. Software Engineer |=C2=A0Ent= erpriseDB India |=C2=A0</font></span><span style=3D"color:rgb(0,0,0)">Pune<= /span></font></div><div><font color=3D"#38761d" face=3D"verdana, sans-serif= " size=3D"1">"Don't Complain about Heat, Plant a TREE"</font>= </div></div></div></div></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><b>Regards,</= b><div><b><a href=3D"https://www.linkedin.com/in/vp393001/" target=3D"_blan= k">Vivek Parmar</a></b></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir= =3D"ltr"><div><div dir=3D"ltr"><font size=3D"2" color=3D"#000000" face=3D"v= erdana, sans-serif">Thanks and Regards,</font><div><span style=3D"backgroun= d-color:rgb(255,255,255)"><font size=3D"2" color=3D"#000000" face=3D"verdan= a, sans-serif">Aditya Toshniwal</font></span></div><div><font face=3D"verda= na, sans-serif"><span style=3D"background-color:rgb(255,255,255)"><font siz= e=3D"2" color=3D"#000000">pgAdmin Hacker | Sr. Software Engineer |=C2=A0Ent= erpriseDB India |=C2=A0</font></span><span style=3D"color:rgb(0,0,0)">Pune<= /span></font></div><div><font color=3D"#38761d" face=3D"verdana, sans-serif= " size=3D"1">"Don't Complain about Heat, Plant a TREE"</font>= </div></div></div></div></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><b>Regards,</= b><div><b><a href=3D"https://www.linkedin.com/in/vp393001/" target=3D"_blan= k">Vivek Parmar</a></b></div></div></div></div></div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div= dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><font size=3D"2" c= olor=3D"#000000" face=3D"verdana, sans-serif">Thanks and Regards,</font><di= v><span style=3D"background-color:rgb(255,255,255)"><font size=3D"2" color= =3D"#000000" face=3D"verdana, sans-serif">Aditya Toshniwal</font></span></d= iv><div><font face=3D"verdana, sans-serif"><span style=3D"background-color:= rgb(255,255,255)"><font size=3D"2" color=3D"#000000">pgAdmin Hacker | Sr. S= oftware Engineer |=C2=A0EnterpriseDB India |=C2=A0</font></span><span style= =3D"color:rgb(0,0,0)">Pune</span></font></div><div><font color=3D"#38761d" = face=3D"verdana, sans-serif" size=3D"1">"Don't Complain about Heat= , Plant a TREE"</font></div></div></div></div></div></div></div></div>= </div></div></div> --0000000000001edc36059b86f0f4--