Обсуждение: interface freezes on long running ops

Version: 1.4.0 Beta 2 (Oct 12 2005)<br /> running on Windows XP SP2<br /><br /> installed from PGInstaller 8.1 beta 3,
12.Oct. 2005<br /><br /> when doing "longer running operations" like "VACUUM ANALYZE", the interface freezes totally. I
cannotpress "CANCEL" or resize windows or do anything else.<br /><br /> With older PG_Admin this WAS possible (And very
helpfull,esp. the "cancel" button on Vacuum )<br /><br /><br /> Additionally: pgAdmin 1.4 really looks GREAT,
WONDERFULLm,PHANTASTIC<br /><br /> who ever updated the interface: VERY VERY GOOD WORK!<br clear="all" /><br />-- <br
/>GHUMHarald Massa<br />persuasion python postgresql<br />Harald Armin Massa<br />Reinsburgstraße 202b<br />70197
Stuttgart<br/>0173/9409607  

Harald Armin Massa wrote:
> Version: 1.4.0 Beta 2 (Oct 12 2005)
> running on Windows XP SP2
> 
> installed from PGInstaller 8.1 beta 3, 12. Oct. 2005
> 
> when doing "longer running operations" like "VACUUM ANALYZE", the 
> interface freezes totally. I cannot press "CANCEL" or resize windows or 
> do anything else.

I checked this with several queries (select * from pg_class,pg_attribute 
and VACUUM ANALYZE) and cancel worked ok. Which libpq are you using? My 
test was with 8.0.1.5031 from a former installer run.

Regards,
Andreas

I use libpq from 8.1-beta3 from the actual beta installer.<br /><br /> I get the freeze on connecting to 8.1-beta3
serverand 8.0.3 servers.<br /><br /> And: it freezes when I use "right mouse, maintainance" ... not from the sql query
menu<br/><br /> (rechte Maus + Wartung)<br /><br /> Harald<br /><br />-- <br />GHUM Harald Massa<br />persuasion python
postgresql<br/>Harald Armin Massa<br />Reinsburgstraße 202b<br />70197 Stuttgart<br />0173/9409607  

Harald Armin Massa wrote:
> I use libpq from 8.1-beta3 from the actual beta installer.
> 
> I get the freeze on connecting to 8.1-beta3 server and 8.0.3 servers.
> 
> And: it freezes when I use "right mouse, maintainance" ... not from the 
> sql query menu

Cancel never worked here. The query tool executes SQL in a thread, 
context menu tasks not.

Regards,
Andreas

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Andreas Pflug
> Sent: 13 October 2005 17:26
> To: Harald Armin Massa
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] interface freezes on long running ops
>
> Harald Armin Massa wrote:
> > Version: 1.4.0 Beta 2 (Oct 12 2005)
> > running on Windows XP SP2
> >
> > installed from PGInstaller 8.1 beta 3, 12. Oct. 2005
> >
> > when doing "longer running operations" like "VACUUM ANALYZE", the
> > interface freezes totally. I cannot press "CANCEL" or
> resize windows or
> > do anything else.
>
> I checked this with several queries (select * from
> pg_class,pg_attribute
> and VACUUM ANALYZE) and cancel worked ok. Which libpq are you
> using? My
> test was with 8.0.1.5031 from a former installer run.

I just committed a fix for this because I was able to reproduce it. You
can optionally pass a wxWindow to wxSafeYield to prevent it from
disabling input from that one window, which is what I have done to allow
the cancel button to be pressed.

I'm not entirely sure why we don't just use wxYield here and allow the
rest of the UI to be usable as well - is there a reason for that
Andreas, or is this just an oversight?

Regards, Dave.

Dave Page wrote:

> 
> I just committed a fix for this because I was able to reproduce it. You
> can optionally pass a wxWindow to wxSafeYield to prevent it from
> disabling input from that one window, which is what I have done to allow
> the cancel button to be pressed.
> 
> I'm not entirely sure why we don't just use wxYield here and allow the
> rest of the UI to be usable as well - is there a reason for that
> Andreas, or is this just an oversight?

Hm, might be a change of function over time; check it out.

Regards,
Andreas

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 20 October 2005 15:38
> To: Dave Page
> Cc: Harald Armin Massa; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] interface freezes on long running ops
>
> Dave Page wrote:
>
> >
> > I just committed a fix for this because I was able to
> reproduce it. You
> > can optionally pass a wxWindow to wxSafeYield to prevent it from
> > disabling input from that one window, which is what I have
> done to allow
> > the cancel button to be pressed.
> >
> > I'm not entirely sure why we don't just use wxYield here
> and allow the
> > rest of the UI to be usable as well - is there a reason for that
> > Andreas, or is this just an oversight?
>
> Hm, might be a change of function over time; check it out.

It's documented as the same in 2.4.2 <shrug>.

Regards, Dave.

Dave Page wrote:

>>
>>Hm, might be a change of function over time; check it out.
> 
> 
> It's documented as the same in 2.4.2 <shrug>.

Sounds feasible to test std wxYield with win32 and Unix, maybe it works.

Regards,
Andreas

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 20 October 2005 16:08
> To: Dave Page
> Cc: Harald Armin Massa; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] interface freezes on long running ops
>
> Dave Page wrote:
>
> >>
> >>Hm, might be a change of function over time; check it out.
> >
> >
> > It's documented as the same in 2.4.2 <shrug>.
>
> Sounds feasible to test std wxYield with win32 and Unix,
> maybe it works.

Certainly seems to - I've committed the change.

I did notice one odd thing thing - sometimes when vacuuming it stops
after a table and activates the OK button (as well as Cancel). Clicking
OK starts it off again. On a four table database I've had to hit OK as
many as 3 times to get to the end (and it always does - nothing nasty
ever seems to happen). Any ideas?

Regards, Dave

Dave,<br /><br /> I had this "clicking OK multiple times" on 1.2 pgAdmin. But my impression was that that "ok" really
startedVACUUM again.<br /><br /> Harald<br clear="all" /><br />-- <br />GHUM Harald Massa<br />persuasion python
postgresql<br/>Harald Armin Massa<br />Reinsburgstraße 202b<br />70197 Stuttgart<br />0173/9409607  

---

From: Harald Armin Massa [mailto:haraldarminmassa@gmail.com]
Sent: 20 October 2005 17:00
To: Dave Page
Cc: Andreas Pflug; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] interface freezes on long running ops

Dave,

I had this "clicking OK multiple times" on 1.2 pgAdmin. But my impression was that that "ok" really started VACUUM again.