Re: 8.3.0 Core with concurrent vacuum fulls - Mailing list pgsql-hackers

From Gavin M. Roy
Subject Re: 8.3.0 Core with concurrent vacuum fulls
Date
Msg-id af1bce590803041801s25b61a10mc6b724a528026a61@mail.gmail.com
Whole thread Raw
In response to Re: 8.3.0 Core with concurrent vacuum fulls  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: 8.3.0 Core with concurrent vacuum fulls
List pgsql-hackers
[gmr@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@commandprompt.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.

pgsql-hackers by date:

Previous
From: craigp
Date:
Subject: Re: newbie: renaming sequences task
Next
From: Tom Lane
Date:
Subject: Re: 8.3.0 Core with concurrent vacuum fulls