Re: SIGABRT on 7.4.5 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SIGABRT on 7.4.5
Date
Msg-id 24446.1096571004@sss.pgh.pa.us
Whole thread Raw
In response to SIGABRT on 7.4.5  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> I have been trying to troubleshoot a PL/R related issue on-and-off for a 
> few weeks now, but this morning ran into what appears to be a more 
> general issue related to 7.4.5 on x86_64. A full backtrace is below, and 
> in it you can see that PL/R is never reached (but PL/pgSQL is). What is 
> really odd is that the abort appears to happen because 
> CacheMemoryContext is invalid.

It could hardly not have been set up yet, so I'm betting that this
indicates a memory-stomp problem somewhere that happens to be hitting
part of the CacheMemoryContext structure.

> I do *not* see this same failure on a 
> different machine with a 32 bit build

Not too surprising; could be related to struct sizes, padding, trying to
cram a 64-bit pointer into a 32-bit field, who knows what.

> Any ideas? I'll request permission to provide the full script to 
> reproduce this to someone offlist if it will help.

The odds are that it couldn't be reproduced except on the same
architecture.  I do have access to some x86_64 machines at Red Hat,
though, so I can take a look if you can send me a test case.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE INDEX speeds up query on 31 row table ...
Next
From: "Serguei A. Mokhov"
Date:
Subject: pg_upgrade project: high-level design proposal of in-place upgrade facility