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 &lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt; 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>
&gt; Hi=C2=A0Sibylle<br>
&gt;<br>
&gt; Can you please provide the pgAdmin4 backend logs<br>
&gt; <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>
&gt; any exact reproduction steps?<br>
<br>
Here is a pgAdmin4 log, I hope it&#39;s ok to send it as attachment. I can&=
#39;t<br>
find information about getting a Firefox log, sorry - I&#39;m not even sure=
<br>
Firefox lets me do that. I don&#39;t really think that&#39;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&#39;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&#39;t seem to be exact reproduction steps. Steps this time, after=
<br>
opening pgAdmin4 and entering the master password:<br>
<br>
- connect to database &quot;sib&quot;<br>
<br>
- right click on table &quot;rubrik&quot;, choose &quot;View / Edit data&qu=
ot;, &quot;Filtered<br>
data&quot;, enter filter expression &quot;rubid like &#39;B__&#39;&quot;, c=
lick &quot;Ok&quot;. This<br>
works as expected. I could expand the &quot;Columns&quot; 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 &quot;ding&quot;, try again to expand it=
s<br>
&quot;Columns&quot; node. This time the rotating circle appears and the nod=
e<br>
doesn&#39;t open.<br></blockquote><div><br></div><div>=C2=A0 =C2=A0How many=
 columns are there in table &quot;ding&quot;?=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 &amp; 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--