Re: Query hangs when getting too complex...

>
> Not quite the right sequence: I think what you've captured is just the
> backend waiting to receive the query. Start the failing query, and
> *after* it hangs attach to the backend process with gdb.
>
> regards, tom lane

Here it is, but it looks the same to me:

[root(at)master /root]# gdb postgres 30592
GNU gdb 19991004
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for
details.
This GDB was configured as "i386-redhat-linux"...
(no debugging symbols found)...

/root/30592: No such file or directory.
Attaching to program: /usr/bin/postgres, Pid 30592
Reading symbols from /usr/lib/libssl.so.0...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libcrypto.so.0...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libz.so.1...(no debugging symbols
found)...done.
Reading symbols from /lib/libcrypt.so.1...done.
Reading symbols from /lib/libresolv.so.2...done.
Reading symbols from /lib/libnsl.so.1...done.
Reading symbols from /lib/libdl.so.2...done.
Reading symbols from /lib/libm.so.6...done.
Reading symbols from /usr/lib/libreadline.so.3...done.
Reading symbols from /lib/libc.so.6...done.
Reading symbols from /lib/ld-linux.so.2...done.
Reading symbols from /lib/libtermcap.so.2...done.
Reading symbols from /usr/lib/gconv/ISO8859-1.so...done.
---Type <return> to continue, or q <return> to quit---
Reading symbols from /lib/libnss_files.so.2...done.
0x80d58d7 in pprint ()
(gdb) bt
#0 0x80d58d7 in pprint ()
#1 0x80fc729 in pg_parse_and_rewrite ()
#2 0x80fc9a1 in pg_exec_query_string ()
#3 0x80fdab6 in PostgresMain ()
#4 0x80e8035 in PostmasterMain ()
#5 0x80e7c1c in PostmasterMain ()
#6 0x80e6e77 in PostmasterMain ()
#7 0x80e6826 in PostmasterMain ()
#8 0x80c89fe in main ()
#9 0x401dc9cb in __libc_start_main (main=0x80c8890 <main>, argc=3,
argv=0xbffffbc4, init=0x8065a78 <_init>, fini=0x8145f2c <_fini>,
rtld_fini=0x4000aea0 <_dl_fini>, stack_end=0xbffffbbc)
at ../sysdeps/generic/libc-start.c:92

Paulo Jan.
DDnet.