Thread: Progress window not closing
Hi,
I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it.
Can anyone suggest anything please?
Thanks
Steve
| ||||||||||||||||||||||
| ||||||||||||||||||||||
| ||||||||||||||||||||||
Attachment
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
Hi,
I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it.
Can anyone suggest anything please?
Thanks
Steve
| ||||||||||||||||||||||
| ||||||||||||||||||||||
| ||||||||||||||||||||||
Attachment
Apologies – should have given that information up front.
pgAdmin: V4.1
OS: MacOS Mojave 10.14.2
I have tried both restarting pgAdmin and restarting the entire iMac and each time the progress window reappears as soon as I reconnect to the affected server. The screenshot below shows the sessions currently running on the server and there definitely no vacuum process running.:
Thanks
Steve
| ||||||||||||||||||||||
| ||||||||||||||||||||||
| ||||||||||||||||||||||
From: Melvin Davidson <melvin6925@yahoo.com>
Reply-To: Melvin Davidson <melvin6925@yahoo.com>
Date: Tuesday, 29 January 2019 at 01:52
To: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.org>, Steve Hawes <steve.hawes@tmlep.com>
Subject: Re: Progress window not closing
>When I got pgAdmin connected again the progress window popped straight back up (even though the >vacuum is not running on the server) and I cannot find any way to get rid of it.
What version of pgadmin are you running?
What O/S is it running on?
Have you tried stopping and restarting pgadmin?
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you. 
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Monday, January 28, 2019, 8:41:27 PM EST, Steve Hawes <steve.hawes@tmlep.com> wrote:
Hi,
I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it.
Can anyone suggest anything please?
Thanks
Steve
| ||||||||||||||||||||||
| ||||||||||||||||||||||
| ||||||||||||||||||||||
Attachment
Hi,
I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it.
Can anyone suggest anything please?
Thanks
Steve
Steve Hawes CIO
T: 020 3355 9796 M: +34 681 259 532 E: steve.hawes@tmlep.com W: www.tmlep.com A:
The Chestnuts, Takeley, Essex, CM22 6QJ
Consider the environment. Do you really need to print this email?
TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom.
This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
Attachment
I have done that and nothing at all happens. If I click the X to close the window it goes away for a few seconds and then immediately comes back again. I am going to try restarting the server and pgAdmin once more.
Thanks
Steve
| ||||||||||||||||||||||
| ||||||||||||||||||||||
| ||||||||||||||||||||||
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Tuesday, 29 January 2019 at 03:57
To: Steve Hawes <steve.hawes@tmlep.com>
Cc: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: Re: Progress window not closing
On Tue, Jan 29, 2019 at 7:11 AM Steve Hawes <steve.hawes@tmlep.com> wrote:
Hi,
I started a VACUUM on a table from pgAdmin and a progress window opened as expected. Unfortunately the remote database was shutdown and restarted whilst the job was running and the process was killed on the DB server. When I got pgAdmin connected again the progress window popped straight back up (even though the vacuum is not running on the server) and I cannot find any way to get rid of it.
Try to stop the process by clicking on the 'Stop Process' button (red button).
Can anyone suggest anything please?
Thanks
Steve
Steve Hawes
CIO
T:
M:
E:
W:
A:
Consider the environment. Do you really need to print this email?
TMLE Limited is a company registered in England and Wales under number 08092743. The company's registered office is The Chestnuts, Brewers End, Takeley, Essex CM22 6QJ United Kingdom.
This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
TMLEP may monitor email traffic data and also the content of emails for compliance purposes and to protect its business.
