Thread: 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 opsDave,
I had this "clicking OK multiple times" on 1.2 pgAdmin. But my impression was that that "ok" really started VACUUM again.
Yes, it does - it seems to just pause every now and again. Keep click and eventually it does finish and print the runtime (and disbale the cancel button etc.).
Regards, Dave.
In my case even "intense and active waiting" helped. VACUUM seemed to stop for some thinking, then it moved it moved it...
Harald
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
I had this "clicking OK multiple times" on 1.2 pgAdmin. But my impression was that that "ok" really started VACUUM again.Yes, it does - it seems to just pause every now and again. Keep click and eventually it does finish and print the runtime (and disbale the cancel button etc.).
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607