[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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. >