pgAdmin 'Browser' window disappears frequently (RM #7670)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7670
Originally created by Hiren Shah at 2022-09-02 15:07:29 UTC.

Hello,

I am seeing issue with 'Browser' window disappearing frequently, and have to do 'Reset Layout' to bring it back.

Version
6.13
Application Mode
Desktop
Current User
pgadmin4@pgadmin.org
NW.js Version
0.62.2
Browser
Chromium 99.0.4844.84
Operating System
Windows-10-10.0.19042-SP0

Downloaded from pgAdmin website.

Thanks,
Hiren Shah

[dpage]

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6949
Originally created by Hiren Shah at 2022-09-02 15:07:23 UTC.

Filename: pgAdmin_Browser_Disappers.PNG

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7670#note-2
Originally created by Yogesh Mahajan at 2022-09-09 11:47:35 UTC.

Hi,

Can you please shares steps to reproduce the issue? Also can you please video recording for the same?

Thanks

Redmine ticket header update:

Name	Old Value	New Value
Priority changed	High	Normal
Assigned To changed		Hiren Shah

[cklein05]

Hi there,

I'm experiencing the same issues (likely) for a longer time now. Either the content of the tree on the left side or the content of a certain tab panel on the right side (e. g. SQL console) suddenly disappears. In my cases, clicking Restore Layout does not bring back the disappeared content.

Also, it's quite hard or impossible to reproduce this behavior, as there is no systematic visible on when that happens. Currently, I was working in a SQL window and clicked menu Edit -> Replace which triggered the SQL panel to disappear. More often the tree on the left side disappears. That may be triggered by just clicking on a tree item or choosing one the the context menu items.

In all cases, I had to close and restart the Windows Desktop version of pgAdmin 4, loosing most of my not yet committed changes (e. g. DDL or changes in complex PL/pgSQL or Python functions).

Currently I'm using version 6.13, however this type of bug occurs for several months already so, older versions seem to be affected as well.

As already said, that is not reproducible and does not happen very often. However, when working on a professional project with a tight schedule, even two or three such events a day is far too much and doesn't help creating happy users (actually, this draws this tool quite non-professional and produces quite angry users...).

Unfortunately, I have no idea how to support you in finding out more about that issue. I guess, that someone just set the visibility of the panel to 'hidden'. However, as we don't have some Chrome Dev Tools around in pgAdmin 4, I have no real insights.

Cheers
Carsten

[cklein05]

Opps. just happened again. I was typing in the Search field of the Query-Tool (using regular expressions). This worked fine while typing some characters and the whole panel disappeared after typing another character. As far as I remember, the last typed character was an opening bracket, making the regular expression invalid (it gets valid only after entering the closing bracket). Maybe the (internal) RegExp error 'invalid pattern' may be a trigger for that issue. However, sometimes entering regular expressions (valid or invalid) works without any problems.

The attached image shows the situation afterwards (it's in German language).

[cklein05]

Additional note: I cannot close the tab whose content has disappeared. I can open new tabs and close them. Seems like I can use the application as usual, except I just can't access the vanished tab anymore (of course) nor can I close it.

[nikhil-mohite]

Hi @cklein05,

The query tool crash is fixed with the latest release v6.14 (a2a18d4).

[RP-natanaraujo]

I dont know how to reproduce that, but happens to me for the past months.
My browser tree turn into a white pane when I click some resource of tree (sometimes).
I think that happens since react migration of tree, but I'm not so sure.

To solve my problem I just refresh the page and to not lose my query tool, already config to open in separate browser tab so I can refresh without losing my code.

[RP-natanaraujo]

If help, happened to me again, but this time was a little different.
My browser tree shrink, but don't turn all blank.

Maybe is something related to responsive design breaking div height.

[ghost]

This is indeed very difficult to produce a description for how to reproduce the issue. It is not clear to us was action triggers this behaviour. All of our users report this behaviour with people using both Windows 10 and Windows 11. PG Admin version 6.14
Like RP-natanaraujo reports, in some cases the entire browser disappears and in some cases the browser element height is not correct, and reseizing the window has no effect.

[adityatoshniwal]

@RP-natanaraujo @svinsightdata We've released 6.15 yesterday. Can you please try on the latest version ?

[RP-natanaraujo]

@adityatoshniwal I'm with 6.15 now and still happens.

[adityatoshniwal]

@RP-natanaraujo The height issue was fixed. The team is looking into this one.

[ghost]

@adityatoshniwal Sorry for the late response. We are currently on version 6.16, and we are experiencing the issue. With some actions the browser disappears. Horizontally resizing the browser then triggers it to redraw and the brower then appears again.
The height issue is fixed. We are not experiencing that anymore.

[jcampbellGoPuff]

I keep hitting this issue in 6.19 and it's frustrating. I wonder if it is related to VPN use. Please review when possible. In the meantime, I'll try the horizontal resize and see if it helps.

[ghost]

In my experience the browser tree flickering + disappearing on horizontal resize is still present.
Windows 11 H2, pgadmin v6.21
also see #5559

[adityatoshniwal]

Steps to reproduce - #6266 (comment)

[EFrankel-ITEP]

Issue appears to be fixed.
#6266 (comment)

[nikhil-mohite]

Resolved, Verified on latest snapshot build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2023-06-23/
OS: macOS (Ventura 13.3)
Mode: Desktop
(Tested using steps provided #6266 (comment))