Re: pgAdmin hangs

Hi,
works after renaming. File in different email.

Regards,
Bartek

2012/2/28 Guillaume Lelarge <guillaume(at)lelarge(dot)info>

> On Tue, 2012-02-28 at 10:10 +0100, Bartosz Dmytrak wrote:
> > hi,
> > I've tried to open SQL query tool using SQL button to see table
> definition
> > (Copy SQL from main window to query tool = TRUE) , but pgAdmin does not
> > reply.
> > Using other instance of pgAdmin on server side, I can see new process is
> > started for Query Tool (status <IDLE>) in server status window.
> >
> > agAdmin logs:
> > 2012-02-28 09:30:40 INFO : Opening connection with connection string:
> > host='myHost' dbname='myDB' user='postgres' password='XXXXXX' port=5432
> > sslmode=require application_name='pgAdmin III - Narzędzie Zapytania'
> > 2012-02-28 09:30:41 QUERY : Scalar query (myHost:5432): SELECT
> version();
> > 2012-02-28 09:30:41 QUERY : Query result: PostgreSQL 9.1.3, compiled by
> > Visual C++ build 1500, 64-bit
> > 2012-02-28 09:30:41 QUERY : Set query (myHost:5432): SET DateStyle=ISO;
> > SET bytea_output=escape;
> > SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
> > FROM pg_database WHERE oid = 16651
> > 2012-02-28 09:30:41 INFO : Setting client_encoding to 'UNICODE'
> > 2012-02-28 09:30:41 SCRIPT : Application created
> >
> > server logs (server is localized to polish):
> > 2012-02-28 09:30:40.986 CET|[nieznany]||[nieznany]|[nieznany]|2844
> > DZIENNIK: odebrano połączenie: host=myHost.mydomain.pl port=54269
> > 2012-02-28 09:30:41.016 CET|[nieznany]|myHost.mydomain.pl
> |postgres|myDB|2844
> > DZIENNIK: zautoryzowano połączenie: użytkownik=postgres baza danych=myDB
> > 2012-02-28 09:30:41.021 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
> > mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: SELECT version();
> > 2012-02-28 09:30:41.025 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
> > mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: SET DateStyle=ISO;
> > SET bytea_output=escape;
> > SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
> > FROM pg_database WHERE oid = 16651
> > 2012-02-28 09:30:41.030 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
> > mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: set
> client_encoding
> > to 'UNICODE'
> >
> > I can't see nothing special in logs.
> > I tried to restart pgAdmin - same scenario every time, pgAdmin hangs when
> > SQL button is clicked.
> > SQL pane works fine - shows table definition, problem occurs for other
> > objects too (e.g. function, schema, operator). Strange thing for me is
> that
> > this works fine on server (pgAdmin 1.14.2 on Windows Server - installed
> > with new version of PostgreSQL)
> >
> > pgAdmin 1.14.2 Windows 7 32 bit - installed outside server bundle
> > Server: 9.1.3 on Windows Server 2008 R2 64 bit.
> >
>
> It's probably because of the .pgadmin_histoqueries file. Try renaming it
> (don't delete it). If it works after renaming, can you send me
> your .pgadmin_histoqueries file? privately, if necessary (because of
> private queries or because it's too big). It would help me find the bug.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>