Re: server won't shutdown - Mailing list pgsql-admin

Ok, it reproduced today on my development server.

Here's the info:

/usr/local/pgsql/bin/pg_ctl -D /u1/pgsql73_data  -m fast   -l /u1/pgsql73_data/pgsql.log stop
waiting for postmaster to shut
down................................................................ failed
pg_ctl: postmaster does not shut down


ps -efw | grep post
postgres  5466     1  0 Feb12 ?        00:00:02 /usr/local/pgsql/bin/postmaster
postgres  5467  5466  0 Feb12 ?        00:00:45 postgres: stats buffer
process
postgres  5468  5467  0 Feb12 ?        00:15:49 postgres: stats collector
process

postgres  8077  5466  0 Feb12 ?        00:00:00 postgres: nbadmin db1 192.168.1.111 idle
postgres 23146  5466  0 09:36 ?        00:00:00 postgres: nbadmin db2 64.114.28.112 idle
postgres 28874  5466  0 12:15 ?        00:00:00 postgres: nbadmin db3 208.184.214.113 idle
postgres 29424  5466  0 12:30 ?        00:00:06 postgres: nbadmin db4 64.114.28.114 idle
postgres  3792  5466  0 15:32 ?        00:00:00 postgres: junior jr_db 192.168.1.114 idle


Here are the stack traces from each of the postmaster and postgres
processes that remain:

gdb /usr/local/pgsql/bin/postmaster 5466
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/5466: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postmaster, process 5466
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x402ab90e in __select () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402ab90e in __select () from /lib/i686/libc.so.6
#1  0xbffff1b8 in ?? ()
#2  0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#3  0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#4  0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

----------
gdb /usr/local/pgsql/bin/postgres 5467
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/5467: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 5467
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x402ab90e in __select () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402ab90e in __select () from /lib/i686/libc.so.6
#1  0x00000006 in __strtol_internal (nptr=0x3 <Address 0x3 out of bounds>,
    endptr=0x0, base=32, group=135287149) at eval.c:36
#2  0x08105189 in pgstat_main () at pgstat.c:1177
#3  0x081045f1 in pgstat_start () at pgstat.c:325
#4  0x081023c2 in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:772
#5  0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#6  0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

-------------
gdb /usr/local/pgsql/bin/postgres 5468
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/5468: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 5468
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x402ab90e in __select () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402ab90e in __select () from /lib/i686/libc.so.6
#1  0xbfffef60 in ?? ()
#2  0x081045f1 in pgstat_start () at pgstat.c:325
#3  0x081023c2 in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:772
#4  0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#5  0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

------------
 gdb /usr/local/pgsql/bin/postgres 8077
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/8077: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 8077
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /usr/local/pgsql-7.3.2/lib/plpgsql.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/plpgsql.so
0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
#1  0x080dc8bd in secure_read (port=0x8247110, ptr=0x81f7c40, len=8192)
    at be-secure.c:301
#2  0x080dff4d in pq_recvbuf () at pqcomm.c:463
#3  0x080dff9d in pq_getbyte () at pqcomm.c:500
#4  0x0811a675 in SocketBackend (inBuf=0x82b7b50) at postgres.c:247
#5  0x0811a6eb in ReadCommand (inBuf=0x82b7b50) at postgres.c:304
#6  0x0811bbb9 in PostgresMain (argc=4, argv=0xbfffef40,
    username=0x8247241 "nbadmin") at postgres.c:1930
#7  0x08103d60 in DoBackend (port=0x8247110) at postmaster.c:2302
#8  0x081036a6 in BackendStartup (port=0x8247110) at postmaster.c:1924
#9  0x081028a5 in ServerLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

--------

gdb /usr/local/pgsql/bin/postgres 23146
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/23146: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 23146
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /usr/local/pgsql-7.3.2/lib/plpgsql.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/plpgsql.so
0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
#1  0x080dc8bd in secure_read (port=0x8247110, ptr=0x81f7c40, len=8192)
    at be-secure.c:301
#2  0x080dff4d in pq_recvbuf () at pqcomm.c:463
#3  0x080dff9d in pq_getbyte () at pqcomm.c:500
#4  0x0811a675 in SocketBackend (inBuf=0x82b7b78) at postgres.c:247
#5  0x0811a6eb in ReadCommand (inBuf=0x82b7b78) at postgres.c:304
#6  0x0811bbb9 in PostgresMain (argc=4, argv=0xbfffef40,
    username=0x8247241 "nbadmin") at postgres.c:1930
#7  0x08103d60 in DoBackend (port=0x8247110) at postmaster.c:2302
#8  0x081036a6 in BackendStartup (port=0x8247110) at postmaster.c:1924
#9  0x081028a5 in ServerLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

----------
gdb /usr/local/pgsql/bin/postgres 28874
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/28874: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 28874
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /usr/local/pgsql-7.3.2/lib/plpgsql.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/plpgsql.so
Reading symbols from /usr/local/pgsql-7.3.2/lib/nextbus.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/nextbus.so
0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
#1  0x080dc8bd in secure_read (port=0x8247110, ptr=0x81f7c40, len=8192)
    at be-secure.c:301
#2  0x080dff4d in pq_recvbuf () at pqcomm.c:463
#3  0x080dff9d in pq_getbyte () at pqcomm.c:500
#4  0x0811a675 in SocketBackend (inBuf=0x82b7c40) at postgres.c:247
#5  0x0811a6eb in ReadCommand (inBuf=0x82b7c40) at postgres.c:304
#6  0x0811bbb9 in PostgresMain (argc=4, argv=0xbfffef40,
    username=0x8247241 "nbadmin") at postgres.c:1930
#7  0x08103d60 in DoBackend (port=0x8247110) at postmaster.c:2302
#8  0x081036a6 in BackendStartup (port=0x8247110) at postmaster.c:1924
#9  0x081028a5 in ServerLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

---------
gdb /usr/local/pgsql/bin/postgres 29424
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/29424: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 29424
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /usr/local/pgsql-7.3.2/lib/plpgsql.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/plpgsql.so
Reading symbols from /usr/local/pgsql-7.3.2/lib/nextbus.so...done.
Loaded symbols for /usr/local/pgsql-7.3.2/lib/nextbus.so
0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
#1  0x080dc8bd in secure_read (port=0x8247110, ptr=0x81f7c40, len=8192)
    at be-secure.c:301
#2  0x080dff4d in pq_recvbuf () at pqcomm.c:463
#3  0x080dff9d in pq_getbyte () at pqcomm.c:500
#4  0x0811a675 in SocketBackend (inBuf=0x82b7cb8) at postgres.c:247
#5  0x0811a6eb in ReadCommand (inBuf=0x82b7cb8) at postgres.c:304
#6  0x0811bbb9 in PostgresMain (argc=4, argv=0xbfffef40,
    username=0x8247241 "nbadmin") at postgres.c:1930
#7  0x08103d60 in DoBackend (port=0x8247110) at postmaster.c:2302
#8  0x081036a6 in BackendStartup (port=0x8247110) at postmaster.c:1924
#9  0x081028a5 in ServerLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

---------
gdb /usr/local/pgsql/bin/postgres 3792
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 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"...
/u1/pgsql73_data/3792: No such file or directory.
Attaching to program: /usr/local/pgsql/bin/postgres, process 3792
Reading symbols from /usr/lib/libssl.so.1...done.
Loaded symbols for /usr/lib/libssl.so.1
Reading symbols from /usr/lib/libcrypto.so.1...done.
Loaded symbols for /usr/lib/libcrypto.so.1
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libreadline.so.4.1...done.
Loaded symbols for /usr/lib/libreadline.so.4.1
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
(gdb) bt
#0  0x402b2262 in __libc_recv () from /lib/i686/libc.so.6
#1  0x080dc8bd in secure_read (port=0x8247110, ptr=0x81f7c40, len=8192)
    at be-secure.c:301
#2  0x080dff4d in pq_recvbuf () at pqcomm.c:463
#3  0x080dff9d in pq_getbyte () at pqcomm.c:500
#4  0x0811a675 in SocketBackend (inBuf=0x82b7958) at postgres.c:247
#5  0x0811a6eb in ReadCommand (inBuf=0x82b7958) at postgres.c:304
#6  0x0811bbb9 in PostgresMain (argc=4, argv=0xbfffef40,
    username=0x8247241 "jshields") at postgres.c:1930
#7  0x08103d60 in DoBackend (port=0x8247110) at postmaster.c:2302
#8  0x081036a6 in BackendStartup (port=0x8247110) at postmaster.c:1924
#9  0x081028a5 in ServerLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xbffff8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 <main>, argc=1,
    ubp_av=0xbffff8d4, init=0x806aeec <_init>, fini=0x8172770 <_fini>,
    rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffff8cc)
    at ../sysdeps/generic/libc-start.c:129

Thanks!

L.
On Wed, 12 Feb 2003, Tom Lane wrote:

> Laurette Cisneros <laurette@nextbus.com> writes:
> > When I do a shutdown:
> > $pgpath/bin/pg_ctl -D $datadir -m fast stop
> > the server will not completely shutdown.
>
> Hm.  -m fast tells the postmaster to send SIGTERM to all the existing
> backends, and then quit when all the backends have quit.  So your
> problem is that one or more backend processes isn't exiting in a timely
> fashion after receiving SIGTERM.  It would be useful to see what these
> backends are doing.  Can you attach to each one with gdb and get a stack
> trace?
>
>             regards, tom lane
>

--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"No man is wise enough by himself"
-- Titus Maccius Plautus
   (254 Bc - 184 BC), Miles Gloriosus