Re: pgadmin error - sql window - Mailing list pgadmin-support

hi Guillaume/Rudolf

I'd like to add a comment or two to this that might help point the issue in a direction.


I've been using pgadmin 1.14 with postgres 9.1.1 for the past month or so and it has been working fine for me. (I use
OSX10.6.8) 

then one day I could connect to the server, but going to the SQL window would hang on me.   I had no clue what was
goingon.   Simply hang and chew up a huge amount of CPU.  Eventually, if I didn't kill PGadmin, it would cause my
machineto die a slow horrible death and I'd need to restart. 


I tried reinstalling - still had issues.
Finally, I went to  my home directory and deleted the .pgadmin_histoqueries file and PGadmin started to work.



The same thing happened again a couple of days later and I had to do the same thing, delete the  .pgadmin_histoqueries
toget it to work again. 



What was the difference that I got hurt only those two days.   Well, in those two days I was pasting in a lot of rather
longstored procedures to the SQL window.   these procedures were about 300 lines each. 

Once you've done 9 or 10 pastes of large functions (they are each saved in the histoquery file), then I'd see the
issue.


In other words, the histoquery file was full of stored procedure code and not the typical small queries.


Clearing fixed it.     I did that a second time that day, clearing fixed it.    I did it 2 days later, clearing fixed
it.


I've only pasted a few large stored procedures in recently, but I've simply made it a practice to do some normal
queriesbefore I quit. 



Not sure if those are the same symptoms, but its is how I made PGadmin fail opening the SQL browser.









Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
http://www.artsman.com
Phone (403) 536-1205    Fax (403) 536-1210

On Nov 17, 2011, at 7:34 AM, Guillaume Lelarge wrote:

> On Thu, 2011-11-17 at 06:04 -0800, Strasser, Rudolf wrote:
>> Hi Guillaume,
>>
>> well, I feared that this would happen. I clicked the reply button on
http://archives.postgresql.org/pgadmin-support/2011-04/msg00007.phpwhich fired up mail. I was (naively ) hoping that
yoursystem is super smart to reattach it to the thread. 
>>
>
> My system isn't supersmart, but I definitely understood you were talking
> about this.
>
>> So, the issue is that PGADMIN still hung once I try to open a SQL Window until I deleted the file mentioned in the
thread,even though I had installed Version 1.14. 
>>
>
> Well, the installer doesn't delete the old file, you need to do this
> yourself. Now that you did it, you shouldn't have any more issues of
> that sort with this file.
>
>
> --
> Guillaume
>  http://blog.guillaume.lelarge.info
>  http://www.dalibo.com
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support