No subject


Mon Nov 14 14:56:52 JST 2011


[root at postgresdb ~]# ps gaxuwww | grep 22890
root      7527  0.0  0.0  61196   792 pts/2    S+   23:00   0:00 grep 22890
postgres 22890  0.0  0.3 2256480 28408 ?       Ss   21:21   0:00 postgres:
companyname companyname 10.11.22.23(52847) BIND


 [root at postgresdb ~]# strace -fvp 22890
Process 22890 attached - interrupt to quit
recvfrom(9,  <unfinished ...>
Process 22890 detached


[root at postgresdb ~]# gdb /usr/pgsql-9.1/bin/postgres GNU gdb (GDB) CentOS
(7.0.1-42.el5.centos)
Copyright (C) 2009 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/pgsql-9.1/bin/postgres...Reading symbols from
/usr/lib/debug/usr/pgsql-9.1/bin/postgres.debug...done.
done.


(gdb) attach 22890
Attaching to program: /usr/pgsql-9.1/bin/postgres, process 22890
warning: .dynamic section for "/lib64/libcom_err.so.2" is not at the expected
address (wrong library or version mismatch?)
Reading symbols from /usr/lib64/libxslt.so.1...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libxslt.so.1
Reading symbols from /usr/lib64/libxml2.so.2...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libxml2.so.2
Reading symbols from /lib64/libpam.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib64/libpam.so.0
Reading symbols from /lib64/libssl.so.6...Reading symbols from
/usr/lib/debug/lib64/libssl.so.0.9.8e.debug...done.
done.
Loaded symbols for /lib64/libssl.so.6
Reading symbols from /lib64/libcrypto.so.6...Reading symbols from
/usr/lib/debug/lib64/libcrypto.so.0.9.8e.debug...done.
done.
Loaded symbols for /lib64/libcrypto.so.6
Reading symbols from /usr/lib64/libgssapi_krb5.so.2...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libgssapi_krb5.so.2
Reading symbols from /lib64/libcrypt.so.1...Reading symbols from
/usr/lib/debug/lib64/libcrypt-2.5.so.debug...done.
done.
Loaded symbols for /lib64/libcrypt.so.1
Reading symbols from /lib64/libdl.so.2...Reading symbols from
/usr/lib/debug/lib64/libdl-2.5.so.debug...done.
done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...Reading symbols from
/usr/lib/debug/lib64/libm-2.5.so.debug...done.
done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /usr/lib64/libldap-2.3.so.0...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libldap-2.3.so.0
Reading symbols from /lib64/libc.so.6...Reading symbols from
/usr/lib/debug/lib64/libc-2.5.so.debug...(no debugging symbols found)...done.
(no debugging symbols found)...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /usr/lib64/libkrb5.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libkrb5.so.3
Reading symbols from /lib64/libcom_err.so.2...(no debugging symbols found)...done.
Loaded symbols for /lib64/libcom_err.so.2
Reading symbols from /usr/lib64/libz.so.1...(no debugging symbols found)...done.
Loaded symbols for /usr/lib64/libz.so.1
Reading symbols from /lib64/libaudit.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib64/libaudit.so.0
Reading symbols from /usr/lib64/libk5crypto.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libk5crypto.so.3
Reading symbols from /usr/lib64/libkrb5support.so.0...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libkrb5support.so.0
Reading symbols from /lib64/libkeyutils.so.1...(no debugging symbols
found)...done.
Loaded symbols for /lib64/libkeyutils.so.1
Reading symbols from /lib64/libresolv.so.2...Reading symbols from
/usr/lib/debug/lib64/libresolv-2.5.so.debug...done.
done.
Loaded symbols for /lib64/libresolv.so.2
Reading symbols from /lib64/ld-linux-x86-64.so.2...Reading symbols from
/usr/lib/debug/lib64/ld-2.5.so.debug...done.
done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /usr/lib64/liblber-2.3.so.0...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/liblber-2.3.so.0
Reading symbols from /usr/lib64/libsasl2.so.2...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib64/libsasl2.so.2
Reading symbols from /lib64/libselinux.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libselinux.so.1
Reading symbols from /lib64/libsepol.so.1...(no debugging symbols found)...done.
Loaded symbols for /lib64/libsepol.so.1
Reading symbols from /lib64/libnss_files.so.2...Reading symbols from
/usr/lib/debug/lib64/libnss_files-2.5.so.debug...done.
done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /usr/pgsql-9.1/lib/pgpool-regclass.so...done.
Loaded symbols for /usr/pgsql-9.1/lib/pgpool-regclass.so
warning: no loadable sections found in added symbol-file system-supplied DSO
at 0x7fffb09fd000
0x00002b89b7b05c95 in __libc_recv (fd=9, buf=0xa389af0, n=5, flags=0) at
../sysdeps/unix/sysv/linux/x86_64/recv.c:30
30	    return INLINE_SYSCALL (recvfrom, 6, fd, buf, n, flags, NULL, NULL);


(gdb) bt
#0  0x00002b89b7b05c95 in __libc_recv (fd=9, buf=0xa389af0, n=5, flags=0) at
../sysdeps/unix/sysv/linux/x86_64/recv.c:30
#1  0x000000000058017d in recv (h=0xa37aee0,     buf=0xa389af0
"\027\003\001\003\020\324]\335o\233\060\020\337\237\261G\304^\332-MiJB\232\267i\232\246\252Z7\355\363\241\215\"c`\261\232\002\262\241[4\345\177\237\017;\201h&\020[Q\303K\022.\234u\376\331\230\373\360\235[\256\266\a\265\206\275\201\241VW\202
\317\030S\342p\373\376\333\317O_n\256o?Ì®?\377\030\035\065 J\355\256Ñ
,\362\316\353\346T\253\320s\206|\363\071)\355\352\365\276\r\365Ӝ?\"Vg\224:\203vA烎\201\253T\001\232b\037h\t\373O\352\060l\nA\350\263.\b\325\016\024\021\032
M\326_\351\243&\347<eLW\340yJ\022]^\234\247\354LÌ…3\261\227Ë !]"..., size=5)
at /usr/include/bits/socket2.h:35
#2  my_sock_read (h=0xa37aee0,     buf=0xa389af0
"\027\003\001\003\020\324]\335o\233\060\020\337\237\261G\304^\332-MiJB\232\267i\232\246\252Z7\355\363\241\215\"c`\261\232\002\262\241[4\345\177\237\017;\201h&\020[Q\303K\022.\234u\376\331\230\373\360\235[\256\266\a\265\206\275\201\241VW\202
\317\030S\342p\373\376\333\317O_n\256o?Ì®?\377\030\035\065 J\355\256Ñ
,\362\316\353\346T\253\320s\206|\363\071)\355\352\365\276\r\365Ӝ?\"Vg\224:\203vA烎\201\253T\001\232b\037h\t\373O\352\060l\nA\350\263.\b\325\016\024\021\032
M\326_\351\243&\347<eLW\340yJ\022]^\234\247\354LÌ…3\261\227Ë !]"..., size=5)
at be-secure.c:429
#3  0x00002b89b6c2e81f in BIO_read (b=0xa37aee0, out=0xa389af0, outl=5) at
bio_lib.c:212
#4  0x00002b89b698d10d in ssl3_read_n (s=0xa362060, n=5, max=<value optimized
out>, extend=<value optimized out>) at s3_pkt.c:198
#5  0x00002b89b698d5dd in ssl3_get_record (s=0xa362060, type=23,
buf=0xad0b80
"no\\\\\\\",\\\\\\\"key_value_delimiter\\\\\\\":\\\\\\\"=\\\\\\\",\\\\\\\"comment_character\\\\\\\":\\\\\\\"#\\\\\\\",\\\\\\\"config_section\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"check_id\\\\\\\":78726},{\\\\\\\"type\\\\\\\":\\\\\\\"configuration\\\\\\\",\\\\\\\"target\\\\\\\":\\\\\\\"/etc/sys"...,
len=8192, peek=0) at s3_pkt.c:266
#6  ssl3_read_bytes (s=0xa362060, type=23,     buf=0xad0b80
"no\\\\\\\",\\\\\\\"key_value_delimiter\\\\\\\":\\\\\\\"=\\\\\\\",\\\\\\\"comment_character\\\\\\\":\\\\\\\"#\\\\\\\",\\\\\\\"config_section\\\\\\\":\\\\\\\"\\\\\\\",\\\\\\\"check_id\\\\\\\":78726},{\\\\\\\"type\\\\\\\":\\\\\\\"configuration\\\\\\\",\\\\\\\"target\\\\\\\":\\\\\\\"/etc/sys"...,
len=8192, peek=0) at s3_pkt.c:854
#7  0x00002b89b698a751 in ssl3_read_internal (s=0xa362060, buf=0xad0b80,
len=8192, peek=0) at s3_lib.c:2428
#8  0x00000000005812af in secure_read (port=0xa361a90, ptr=0xad0b80, len=8192)
at be-secure.c:251
#9  0x000000000058a771 in pq_recvbuf () at pqcomm.c:816
#10 0x000000000058ab77 in pq_getbyte () at pqcomm.c:857
#11 0x0000000000623530 in ReadCommand (argc=<value optimized out>, argv=0x1,
username=0x48 <Address 0x48 out of bounds>) at postgres.c:345
#12 PostgresMain (argc=<value optimized out>, argv=0x1, username=0x48 <Address
0x48 out of bounds>) at postgres.c:3932
#13 0x00000000005e7ae4 in ServerLoop () at postmaster.c:3611
#14 0x00000000005e8861 in PostmasterMain (argc=5, argv=0xa344970) at
postmaster.c:1121
#15 0x000000000058c5be in main (argc=5, argv=<value optimized out>) at main.c:199
(gdb) quit
A debugging session is active.

	Inferior 1 [process 22890] will be detached.

Quit anyway? (y or n) y
Detaching from program: /usr/pgsql-9.1/bin/postgres, process 22890
[root at postgresdb ~]#


More information about the pgpool-general mailing list