Re: PgAdmin 4.15 stops responding
Akshay Joshi <[email protected]> Mon, 2 Dec 2019 09:11:46 +0530
| Newsgroups | gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <CANxoLDes58Rm4Vq20wFMjaL2vWATZoYvjt+WdQsrZtwGKny16w@mail.gmail.com> |
--000000000000886a070598b05cb7 Content-Type: text/plain; charset="UTF-8" Hi Sibylle On Sat, Nov 30, 2019 at 12:07 AM Sibylle Koczian <[email protected]> wrote: > Am 28.11.2019 um 09:33 schrieb Akshay Joshi: > > Hi Sibylle > > > > Can you please provide the pgAdmin4 backend logs > > https://www.pgadmin.org/faq/#8 and browser logs if possible. Is there > > any exact reproduction steps? > > Here is a pgAdmin4 log, I hope it's ok to send it as attachment. I can't > find information about getting a Firefox log, sorry - I'm not even sure > Firefox lets me do that. I don't really think that's important, as > pgAdmin behaves the same with Edge as with Firefox. > I have verified the log file, but it's not clear from the logs. Have you set the log level to DEBUG CONSOLE_LOG_LEVEL = logging.DEBUG FILE_LOG_LEVEL = logging.DEBUG > > There don't seem to be exact reproduction steps. Steps this time, after > opening pgAdmin4 and entering the master password: > > - connect to database "sib" > > - right click on table "rubrik", choose "View / Edit data", "Filtered > data", enter filter expression "rubid like 'B__'", click "Ok". This > works as expected. I could expand the "Columns" node for the table, > while the filter dialog was open, no problem. The table is very small, > two columns, three records fullfill the filter criterion. > > - open the filter dialog for table "ding", try again to expand its > "Columns" node. This time the rotating circle appears and the node > doesn't open. > How many columns are there in table "ding"? Is your database server and pgAdmin4 running on same machine? > > - After about 10 minutes I try to open the Query Tool for the database, > but that panel tab only shows another rotating circle. I can close this > panel tab. Now I close the browser and stop the pgAdmin server. > > As a matter of fact I could reproduce these steps a second time with the > same result, but that may be coincidence. > > Thank you for looking into this! > > Sibylle > -- *Thanks & Regards* *Akshay Joshi* *Sr. Software Architect* *EnterpriseDB Software India Private Limited* *Mobile: +91 976-788-8246* --000000000000886a070598b05cb7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr">Hi=C2=A0Sibylle</div><br><div class=3D"gm= ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Nov 30, 2019 at 12= :07 AM Sibylle Koczian <<a href=3D"mailto:[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 rg= b(204,204,204);padding-left:1ex">Am 28.11.2019 um 09:33 schrieb Akshay Josh= i:<br> > Hi=C2=A0Sibylle<br> ><br> > Can you please provide the pgAdmin4 backend logs<br> > <a href=3D"https://www.pgadmin.org/faq/#8" rel=3D"noreferrer" target= =3D"_blank">https://www.pgadmin.org/faq/#8</a>=C2=A0and browser logs if pos= sible. Is there<br> > any exact reproduction steps?<br> <br> Here is a pgAdmin4 log, I hope it's ok to send it as attachment. I can&= #39;t<br> find information about getting a Firefox log, sorry - I'm not even sure= <br> Firefox lets me do that. I don't really think that's important, as<= br> pgAdmin behaves the same with Edge as with Firefox.<br></blockquote><div><b= r></div><div>=C2=A0 =C2=A0I have verified the log file, but it's not cl= ear from the logs. Have you set the log level to DEBUG</div><div>=C2=A0 =C2= =A0CONSOLE_LOG_LEVEL =3D logging.DEBUG</div><div>=C2=A0 =C2=A0FILE_LOG_LEVE= L =3D logging.DEBUG=C2=A0</div><div>=C2=A0 =C2=A0=C2=A0</div><blockquote cl= ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid= rgb(204,204,204);padding-left:1ex"> <br> There don't seem to be exact reproduction steps. Steps this time, after= <br> opening pgAdmin4 and entering the master password:<br> <br> - connect to database "sib"<br> <br> - right click on table "rubrik", choose "View / Edit data&qu= ot;, "Filtered<br> data", enter filter expression "rubid like 'B__'", c= lick "Ok". This<br> works as expected. I could expand the "Columns" node for the tabl= e,<br> while the filter dialog was open, no problem. The table is very small,<br> two columns, three records fullfill the filter criterion.<br> <br> - open the filter dialog for table "ding", try again to expand it= s<br> "Columns" node. This time the rotating circle appears and the nod= e<br> doesn't open.<br></blockquote><div><br></div><div>=C2=A0 =C2=A0How many= columns are there in table "ding"?=C2=A0</div><div>=C2=A0 =C2=A0= Is your database server and pgAdmin4 running on same machine?</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"> <br> - After about 10 minutes I try to open the Query Tool for the database,<br> but that panel tab only shows another rotating circle. I can close this<br> panel tab. Now I close the browser and stop the pgAdmin server.<br> <br> As a matter of fact I could reproduce these steps a second time with the<br= > same result, but that may be coincidence.<br> <br> Thank you for looking into this!<br> <br> Sibylle<br> </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 dir=3D"l= tr"><div dir=3D"ltr"><div><font color=3D"#3333FF"><b><span style=3D"color:r= gb(0,0,0);font-family:arial,sans-serif;font-size:13px;border-collapse:colla= pse">Thanks & Regards</span></b></font></div><div><font color=3D"#3333F= F"><b><span style=3D"color:rgb(0,0,0);font-family:arial,sans-serif;font-siz= e:13px;border-collapse:collapse">Akshay Joshi</span></b></font></div><div><= font color=3D"#3333FF"><b><span style=3D"color:rgb(0,0,0);font-family:arial= ,sans-serif;font-size:13px;border-collapse:collapse">Sr. Software Architect= <br></span></b></font></div><div><span style=3D"border-collapse:collapse"><= font color=3D"#000000" face=3D"arial, sans-serif"><b>EnterpriseDB Software = India Private Limited</b></font><br></span></div><div><b style=3D"color:rgb= (51,51,255)"><span style=3D"color:rgb(0,0,0);font-family:arial,sans-serif;f= ont-size:13px;border-collapse:collapse">Mobile: +91 976-788-8246</span></b>= <br></div></div></div></div></div></div></div></div></div></div> --000000000000886a070598b05cb7--