Query tool bombing out

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Query tool bombing out
Date: 2022-04-26 22:49:14
Message-ID: CAPB4dVhb8L+FiVCDcaLuLyEJwSb7GCjbreoXF4o__yXiWUrLQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

For at least the last 6 months, I have observed an increased tendency for
query tools tabs to bomb out without providing any data output and/or
Message output. What I see has the following characteristics:

1.
Whether I run a single script or multiple scripts (each terminated by
semicolon) does not matter, and I have not been able to figure out any kind
of pattern to these failures;
2.
The majority of my update scripts relate to JSONB field updates, but not
all;
3.
The script run will bomb out after anywhere from 2 to 20 seconds;
4.
There is no message output, the execute icon turns grey, and the connection
status indicates "The session is idle and there is no current transaction";
5.
The query tool tab is permanently disabled, and I have to close it and open
a new tab to run the script again; Usually the script will then run
normally, but sometimes I have to do it 2 or 3 times before success (for
each round I have to close the disabled tab and open a new one);
6.
Sometimes I find that the original script actually DID work (when running
it again I get 0 updates even when I know there must be some), sometimes it
has not actually updated anything. This indicates that the script execution
sometimes bombs before it has even run or at least finished, sometimes it
bombs out after finishing but before the result message is displayed;
7.
Finally, note that these are standardised scripts, around 50 of them, that
I run every 2-3 days to correct errors or missing values for client data
(covid-19 vaccinations) captured on a daily basis. So there is nothing
wrong with the scripts themselves - the problem is that pgadmin is somehow
unable to finish many of them in some cases.
8.
I see no similar problems when running the same scripts from the command
line.

Does anybody have a clue what the issue might be here?

Best regards
Calle

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2022-04-27 04:12:40 Re: Query tool bombing out
Previous Message Jan Birk - gmail 2022-04-26 18:51:19 Service file (pg_service.conf)