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

From Tom Lane
Subject Re: Autovacuum daemon terminated by signal 11
Date
Msg-id 13734.1232060126@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum daemon terminated by signal 11  (Justin Pasher <justinp@newmediagateway.com>)
Responses Re: Autovacuum daemon terminated by signal 11  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Justin Pasher <justinp@newmediagateway.com> writes:
> 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 ()

Hmm.  This isn't very trustworthy for lack of debug symbols (what we're
probably looking at are the nearest global function names before the
actual locations).  However, it strongly suggests that something is
broken in the active memory context, and the most likely explanations
for that are either a memory clobber (eg overrunning the requested size
of a chunk) or CurrentMemoryContext pointing at a context that was
already freed.  The latter theory ties into the fact that it seems to be
happening during transaction end.  But any such bug of either type
should have been found years ago given that development is invariably
done with CLOBBER_FREED_MEMORY enabled.

Alvaro, any thoughts?  Remember this is 8.1.15.

Justin, if you do feel like recompiling, please do so with original
configure options (run pg_config to verify) and add --enable-cassert
as well as --enable-debug.  That might give us more to work with.

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum and Reindex hangs
Next
From: Bjørn T Johansen
Date:
Subject: How good is the default values for autovacuum?