Unix Technical Forum

problem with pgadmin 1.8.2 to keep connection to postgresql 8.2.6

This is a discussion on problem with pgadmin 1.8.2 to keep connection to postgresql 8.2.6 within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Hi, i installed the pgadmin3 rpm for opensuse 10.2 i586, from the pgadmin download page. I can connect to ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-16-2008, 01:43 PM
Sebastian Reitenbach
 
Posts: n/a
Default problem with pgadmin 1.8.2 to keep connection to postgresql 8.2.6

Hi,

i installed the pgadmin3 rpm for opensuse 10.2 i586, from the pgadmin
download page. I can connect to the database, and also run some few queries,
but then, sometimes after the second, sometimes a bit later, maybe after the
fifth, or tenth time, the query does not succeed anymore and in the result
field in pgadmin3 it says ********error*********
When I then try again to submit the query, a small empty window pops up, and
then pgadmin3 hangs. I either have to kill it, or it dies by itself.
When pgadmin it dies, I see the following on the console:

(pgadmin3:5689): Gdk-CRITICAL **: gdk_window_set_geometry_hints: assertion
`GDK_IS_WINDOW (window)' failed

(pgadmin3:5689): Gdk-CRITICAL **: gdk_window_resize: assertion
`GDK_IS_WINDOW (window)' failed
Xlib: unexpected async reply (sequence 0xa3a60)!
Xlib: sequence lost (0xb0000 > 0xa3a61) in reply type 0x0!

I also tried to run pgadmin3 --sync, as on another time when it crashed, it
suggested to use this parameter. But then, the problem was not reproducible,
because the query seems to take forever, the counter of miliseconds in the
lower right corner was at about 50000 when I stopped it. The query run from
pgadmin without --sync parameter took only about 40ms.

The query that I submit is very easy: select * from segment; in that table,
there are only twenty rows in it, and I can do the same statement from
commandline via psql without any problems.

The database is running on a SLES10SP1 x86_64, the client is a opensuse
10.2, i586.

Has anybody seen this, and an idea, how to fix it?

kind regards
Sebastian


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-16-2008, 01:43 PM
Dave Page
 
Posts: n/a
Default Re: problem with pgadmin 1.8.2 to keep connection to postgresql 8.2.6

On Fri, May 16, 2008 at 12:05 PM, Sebastian Reitenbach
<sebastia@l00-bugdead-prods.de> wrote:
> I also tried to run pgadmin3 --sync, as on another time when it crashed, it
> suggested to use this parameter. But then, the problem was not reproducible,
> because the query seems to take forever, the counter of miliseconds in the
> lower right corner was at about 50000 when I stopped it. The query run from
> pgadmin without --sync parameter took only about 40ms.


Well that's, umm surprising. There is no --sync option in pgAdmin - in
fact I get an error if I try to use it on Windows or Mac (I don't have
a GTK system here atm). Can you get an exact copy of the text which
recommended you use it?


--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:33 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com