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

Tom Lane wrote:
>
>> #1  0xb7c37811 in raise () from /lib/tls/i686/cmov/libc.so.6
>> #2  0xb7c38fb9 in abort () from /lib/tls/i686/cmov/libc.so.6
>> #3  0x0828cdf3 in ExceptionalCondition ()
>> #4  0x082a8cd2 in MemoryContextAlloc ()
>> #5  0x082a8d67 in MemoryContextStrdup ()
>> #6  0x0829749c in database_getflatfilename ()
>> #7  0x082974ce in database_getflatfilename ()
>> #8  0x08298341 in AtEOXact_UpdateFlatFiles ()
>> #9  0x080bcc81 in RecordTransactionCommit ()
>> #10 0x080bcf8f in CommitTransactionCommand ()
>> #11 0x081cd1eb in autovac_stopped ()
>> #12 0x081cdbcd in autovac_start ()
>> #13 0x081d4c0c in ClosePostmasterPorts ()
>> #14 0x081d5968 in PostmasterMain ()
>> #15 0x0818bd22 in main ()
>
> ... and you've seemingly not managed to install the debug symbols where
> gdb can find them.
>
>             regards, tom lane

OK. I recompiled from source (I didn't expect it to go so quickly and
smoothly) and it looks like I might have the correct info now. Here's
the new backtrace. Let me know if I still don't have it right. The
configure is below to (for reference).

./configure --disable-maintainer-mode --disable-dependency-tracking
--enable-nls --enable-integer-datetimes --enable-thread-safety
--enable-debug --enable-cassert --disable-rpath --with-tcl --with-perl
--with-python --with-pam --with-krb5 --with-openssl --with-gnu-ld
--with-tclconfig=/usr/lib/tcl8.4 --with-tkconfig=/usr/lib/tk8.4
--with-includes=/usr/include/tcl8.4

------------------------------
postgres@hostname:/usr/local/pgsql/bin$ gdb
/usr/local/pgsql/bin/postmaster /var/lib/postgresql/8.1/mc-db2/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"...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...done.
Loaded symbols for /lib/libpam.so.0
Reading symbols from /usr/lib/i686/cmov/libssl.so.0.9.8...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...done.
Loaded symbols for /usr/lib/i686/cmov/libcrypto.so.0.9.8
Reading symbols from /usr/lib/libkrb5.so.3...done.
Loaded symbols for /usr/lib/libkrb5.so.3
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /lib/libreadline.so.5...done.
Loaded symbols for /lib/libreadline.so.5
Reading symbols from /lib/tls/i686/cmov/libcrypt.so.1...done.
Loaded symbols for /lib/tls/i686/cmov/libcrypt.so.1
Reading symbols from /lib/tls/i686/cmov/libresolv.so.2...done.
Loaded symbols for /lib/tls/i686/cmov/libresolv.so.2
Reading symbols from /lib/tls/i686/cmov/libnsl.so.1...done.
Loaded symbols for /lib/tls/i686/cmov/libnsl.so.1
Reading symbols from /lib/tls/i686/cmov/libdl.so.2...done.
Loaded symbols for /lib/tls/i686/cmov/libdl.so.2
Reading symbols from /lib/tls/i686/cmov/libm.so.6...done.
Loaded symbols for /lib/tls/i686/cmov/libm.so.6
Reading symbols from /lib/tls/i686/cmov/libc.so.6...done.
Loaded symbols for /lib/tls/i686/cmov/libc.so.6
Reading symbols from /lib/libcom_err.so.2...done.
Loaded symbols for /lib/libcom_err.so.2
Reading symbols from /usr/lib/libk5crypto.so.3...done.
Loaded symbols for /usr/lib/libk5crypto.so.3
Reading symbols from /lib/libncurses.so.5...done.
Loaded symbols for /lib/libncurses.so.5
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /usr/lib/libkrb5support.so.0...done.
Loaded symbols for /usr/lib/libkrb5support.so.0
Core was generated by `postgres: autovacuum process
mc_itec                            '.
Program terminated with signal 6, Aborted.
#0  0xffffe410 in __kernel_vsyscall ()
(gdb) bt
#0  0xffffe410 in __kernel_vsyscall ()
#1  0xb7b1d811 in raise () from /lib/tls/i686/cmov/libc.so.6
#2  0xb7b1efb9 in abort () from /lib/tls/i686/cmov/libc.so.6
#3  0x0825f4a1 in ExceptionalCondition (conditionName=0x8324b6c
"!(((context) != ((void *)0) && (((((Node*)((context)))->type) ==
T_AllocSetContext))))",
    errorType=0x82885e0 "BadArgument", fileName=0x8319d04 "mcxt.c",
lineNumber=502) at assert.c:51
#4  0x0827869e in MemoryContextAlloc (context=0x838e42c, size=19) at
mcxt.c:502
#5  0x0827872c in MemoryContextStrdup (context=0x838e42c,
string=0x8318833 "global/pg_database") at mcxt.c:655
#6  0x08268a4c in database_getflatfilename () at flatfiles.c:112
#7  0x08268a63 in write_database_file (drel=0x0, startup=6 '\006') at
flatfiles.c:194
#8  0x082697f2 in AtEOXact_UpdateFlatFiles (isCommit=1 '\001') at
flatfiles.c:815
#9  0x080b6741 in CommitTransaction () at xact.c:1470
#10 0x080b6a29 in CommitTransactionCommand () at xact.c:2184
#11 0x081b0f42 in AutoVacMain (argc=<value optimized out>, argv=<value
optimized out>) at autovacuum.c:559
#12 0x081b1879 in autovac_start () at autovacuum.c:174
#13 0x081b7f78 in ServerLoop () at postmaster.c:1269
#14 0x081b8bad in PostmasterMain (argc=3, argv=0x836b508) at
postmaster.c:943
#15 0x08175609 in main (argc=3, argv=0x836b508) at main.c:265


Justin Pasher