Thread: PgAdmin 4.15 stops responding

Hello,

I try to use pgAdmin 4 on Windows 10 with PostgreSQL 12.1, but it is
quite unusable.The application starts, I enter the master password, I
can connect to the server and open the entry for one of my databases in
the tree on the left side of the pgAdmin window. So far everything looks
normal. Then I try to do something with that database - look at a table
definition, look at data, start a backup. Now the cursor usually changes
to a rotating circle, or I click a button and nothing happens. And this
state lasts, sometimes for hours, till I close the pgAdmin window.
Sometimes I can do one or two actions with the database before
everything hangs - but most of the time even that is impossible. This
state of affairs is new, possibly since the update to Version 12 of
PostgreSQL. Before, I usually could do more and pgAdmin stopped
responding later.

My browser is Firefox, but I just tried with Edge - same thing.

I'm using the EDB installer and the pgAdmin version contained in that
package (4.15 at the moment, I think). The PostgreSQL server and pgAdmin
run on the same machine.

What can I do?

Thank you for help!

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.

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.

- 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

Hello,

Am 02.12.2019 um 04:41 schrieb Akshay Joshi:
>
>     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
>
Yes, I did.
>
>     How many columns are there in table "ding"?

Seven. Two indexes (primary key and one unique column), two foreign
keys. 19 records in the table.

>     Is your database server and pgAdmin4 running on same machine?
>
Yes, they are.

Regards,
Sibylle