Re: Crash in edit grid

Were you doing that over a vpn connection by chance?

Pgadmin frequently will get disconnect for me if it is idle for a while
when using it through a vpn connection.  I will still be logged into the
vpn and able to browse my network folders after it has happened so I
know the vpn connection was not completely lost.

Mike
On Thu, 2006-11-30 at 23:16 +0100, Erwin Brandstetter wrote:
> Hi developers! Hi Dave!
> 
> Testing 1.6.1 rev: 5709, client Win XP. Host Debian Sarge, PG 8.1.4
> 
> A new version is out. Congratulations on your good work! :)
> 
> I have run a few tests, found nothing bad, and used it for serious work.
> Found something bad though, when I was not looking. Here is what I did:
> 
>  From within the edit grid I applied a new filter.
> _Many_ rows were fetched, so it took a _long_ time before (new) data 
> would be displayed.
> Got distracted, came back, edited filter and reapplied before the result 
> of the previous filter had been displayed.
> pgAdmin crashed on me, and with it a dozen windows with unfinished work. :(
> Now, I know that a note is being displayed at the bottom left: 
> "Refreshing data, please wait" while data is being fetched. But it is 
> easily overlooked, and that's what I did.
> 
> Trying to reproduce this (no difference if I apply a new filter from 
> within or I open the edit grid with the filter option), it crashes 
> occasionally. Most of the time I just get an error of this kind:
> 
>     An error has occurred:
> 
>     server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request
> 
> 
> Possible cure:
> Lock the edit grid while waiting for data (hourglass?), or at least 
> prevent pgAdmin from crashing.
> But please don't leave this footgun loaded for the occasionally poor of 
> sight, like me.
> 
> 
> Regards
> Erwin
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq