Re: Autovacuum daemon terminated by signal 11 - Mailing list pgsql-general

Tom Lane wrote:
> Having debug symbols would be more useful, but unless the binary is
> totally stripped, a backtrace might provide enough info without that.
> Try it and see if you get any function names in the trace, or only
> numbers.
>
> (BTW, does Debian have anything comparable to Red Hat's debuginfo
> packages?  You might be able to get the debug symbols without having
> to recompile for yourself.  Recompile is a bit of a pain since you have
> to take care to match the original compilation options exactly.)
>
>             regards, tom lane


Alrighty. Here's what I got (assuming I did this right). My untrained
eyes see some stuff regarding memory allocation. I wonder if overly
aggressive memory related tweaks in the config file are causing the
problem? I don't recall making any changes to the config file within a
short time period of the problem starting, but let me know if I need to
post any config settings.


hostname:/var/lib/postgresql/8.1/mc-db2# gdb
/usr/lib/postgresql/8.1/bin/postmaster core
GNU gdb 6.4.90-debian
Copyright (C) 2006 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 "i486-linux-gnu"...(no debugging symbols found)
Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1".


warning: Can't read pathname for load map: Input/output error.
Reading symbols from /lib/libpam.so.0...(no debugging symbols found)...done.
Loaded symbols for /lib/libpam.so.0
Reading symbols from /usr/lib/i686/cmov/libssl.so.0.9.8...(no debugging
symbols found)...done.
Loaded symbols for /usr/lib/i686/cmov/libssl.so.0.9.8
Reading symbols from /usr/lib/i686/cmov/libcrypto.so.0.9.8...(no
debugging symbols found)...done.
Loaded symbols for /usr/lib/i686/cmov/libcrypto.so.0.9.8
Reading symbols from /usr/lib/libkrb5.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libkrb5.so.3
Reading symbols from /lib/libcom_err.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib/libcom_err.so.2
Reading symbols from /lib/tls/i686/cmov/libcrypt.so.1...
(no debugging symbols found)...done.
Loaded symbols for /lib/tls/i686/cmov/libcrypt.so.1
Reading symbols from /lib/tls/i686/cmov/libdl.so.2...(no debugging
symbols found)...done.
Loaded symbols for /lib/tls/i686/cmov/libdl.so.2
Reading symbols from /lib/tls/i686/cmov/libm.so.6...(no debugging
symbols found)...done.
Loaded symbols for /lib/tls/i686/cmov/libm.so.6
Reading symbols from /lib/tls/i686/cmov/libc.so.6...(no debugging
symbols found)...done.
Loaded symbols for /lib/tls/i686/cmov/libc.so.6
Reading symbols from /usr/lib/libz.so.1...(no debugging symbols
found)...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /usr/lib/libk5crypto.so.3...
(no debugging symbols found)...done.
Loaded symbols for /usr/lib/libk5crypto.so.3
Reading symbols from /lib/tls/i686/cmov/libresolv.so.2...(no debugging
symbols found)...done.
Loaded symbols for /lib/tls/i686/cmov/libresolv.so.2
Reading symbols from /lib/ld-linux.so.2...(no debugging symbols
found)...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /usr/lib/libkrb5support.so.0...(no debugging
symbols found)...done.
Loaded symbols for /usr/lib/libkrb5support.so.0
(no debugging symbols found)
Core was generated by `postgres: autovacuum process
mc_dairyqueen                                  '.
Program terminated with signal 11, Segmentation fault.
#0  0x0827441d in MemoryContextAlloc ()
(gdb) bt
#0  0x0827441d in MemoryContextAlloc ()
#1  0x08274467 in MemoryContextStrdup ()
#2  0x0826501c in database_getflatfilename ()
#3  0x0826504e in database_getflatfilename ()
#4  0x08265ec1 in AtEOXact_UpdateFlatFiles ()
#5  0x080a9111 in RecordTransactionCommit ()
#6  0x080a93a7 in CommitTransactionCommand ()
#7  0x081a6c3b in autovac_stopped ()
#8  0x081a75cd in autovac_start ()
#9  0x081ae33c in ClosePostmasterPorts ()
#10 0x081af058 in PostmasterMain ()
#11 0x0816b3e2 in main ()