"Dave Page" <dpage(at)pgadmin(dot)org> wrote:
> On Fri, May 16, 2008 at 4:16 PM, Sebastian Reitenbach
> <sebastia(at)l00-bugdead-prods(dot)de> wrote:
> > "Dave Page" <dpage(at)pgadmin(dot)org> wrote:
> >> On Fri, May 16, 2008 at 12:05 PM, Sebastian Reitenbach
> >> <sebastia(at)l00-bugdead-prods(dot)de> wrote:
> >> > I also tried to run pgadmin3 --sync, as on another time when it
> > it
> >> > suggested to use this parameter. But then, the problem was not
> > reproducible,
> >> > because the query seems to take forever, the counter of miliseconds
> > the
> >> > lower right corner was at about 50000 when I stopped it. The query
> > 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?
> > Afaik the error message came from the X server, so yes, not a pgadmin3
> > parameter.
> > It said sth. like:
> > When an X application crashes, the error message is asynchron, and
> > usually not shows the real cause of the problem. When you want to run
> > application from within gdb, then use --sync, to get the right
> > The --sync is I think automatically added to each X application, from
> > server, or window manager, whoever there is responsible.
> Hmm, OK - I did wonder if it were something like that.
> > When I get the error again, then I cut 'n past the output in here, I got
> > this only once.
> Please do. FWIW, there are no known bugs in pgAdmin that would cause
> connections to drop as you describe (in fact, the connections are
> handled by libpq, so it would be largely out of our control anyway) -
> and it should be handled gracefully by pgAdmin when it does happen for
> other reasons. I have heard a report in the past that for one person
> that wasn't the case, but I was unable to reproduce any problems when
> deliberately causing connection problems.
sorry, it took me a while to get back to the machines again, however, here
is the error output cut 'n pasted:
So, after submitting the same query, for about 10 times, then instead of the
result set, the following was shown in the sql output window of pgadmin3:
********** Error **********
Then, when I try to submit the query again, an error popup window shows up,
stating the following:
An error has occurred:
no connection to the server
and at the same time, on the console the following appears:
Xlib: sequence lost (0xd5bf8 > 0xc5bfa) in reply type 0xf!
Xlib: unexpected async reply (sequence 0xc5c81)!
When I then try to close the error window, it is not closing, I klick
the "close" or "ok" or however the button is called, the button several
times, and then pgadmin3 disappears at all, leaving the following message on
The program 'pgadmin3' received an X Window System error.
This probably reflects a bug in the program.
The error was 'BadAtom (invalid Atom parameter)'.
(Details: serial 967950 error_code 5 request_code 18 minor_code 0)
(Note to programmers: normally, X errors are reported asynchronously;
that is, you will receive the error a while after causing it.
To debug your program, run it with the --sync command line
option to change this behavior. You can then get a meaningful
backtrace from your debugger if you break on the gdk_x_error() function.)
I also retested, with psql from commandline, using the same query,
and I was able to issue it about 50 times in a fast row, before I stopped
I also tried pgadmin 1.8.1, and I did ran into the same problem, but it
seems that the problem does not occur so fast, but maybe that was just
pgadmin-support by date
|Next:||From: Stuart Gundry||Date: 2008-05-21 09:30:42|
|Subject: Support Request: Database connection from the command line|
|Previous:||From: Raymond O'Donnell||Date: 2008-05-17 13:47:36|
|Subject: Re: Adding users and groups/roles without SQL?|