Re: 8.3.0 Core with concurrent vacuum fulls

[gmr(at)db04 backup]$ cat /etc/redhat-release
CentOS release 4.4 (Final)

BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-ldap' '--with-perl' '--enable-integer-datetimes'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,'/usr/local/pgsql/lib'
LDFLAGS_SL =
LIBS = -lpgport -lz -lreadline -ltermcap -lcrypt -ldl -lm
VERSION = PostgreSQL 8.3.0

(gdb) where
#0 0x0000003fe362e21d in raise () from /lib64/tls/libc.so.6
#1 0x0000003fe362fa1e in abort () from /lib64/tls/libc.so.6
#2 0x000000000063a2e3 in errfinish ()
#3 0x00000000005974c4 in DeadLockReport ()
#4 0x000000000059381f in LockAcquire ()
#5 0x0000000000592357 in LockRelationOid ()
#6 0x0000000000457255 in relation_open ()
#7 0x00000000004574c3 in heap_open ()
#8 0x000000000062cf41 in CatalogCacheInitializeCache ()
#9 0x000000000062dfad in PrepareToInvalidateCacheTuple ()
#10 0x000000000062e8c5 in CacheInvalidateHeapTuple ()
#11 0x000000000045c803 in heap_page_prune ()
#12 0x00000000005086cd in vacuum_rel ()
#13 0x00000000005096bb in vacuum ()
#14 0x00000000005a163b in PortalRunUtility ()
#15 0x00000000005a1714 in PortalRunMulti ()
#16 0x00000000005a1d30 in PortalRun ()
#17 0x000000000059f4b6 in PostgresMain ()
#18 0x00000000005760c0 in ServerLoop ()
#19 0x0000000000577770 in PostmasterMain ()
#20 0x000000000052fd3e in main ()

On Tue, Mar 4, 2008 at 11:35 AM, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
wrote:

> Gavin M. Roy wrote:
> > This morning I had a postgres 8.3 install core this morning while
> multiple
> > vacuum fulls were taking place. I saved the core file, would anyone be
> > interested in dissecting it? I've otherwise had no issues with this
> machine
> > or pgsql install.
>
> Of course. Please post the backtrace.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>