From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: check failure with -DRELCACHE_FORCE_RELEASE -DCLOBBER_FREED_MEMORY
Message-ID: <7b52f900-0579-cda9-ae2e-de5da17090e6@2ndQuadrant.com>
Date: Fri, 3 Mar 2017 14:24:19 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


I have been setting up a buildfarm member with -DRELCACHE_FORCE_RELEASE
-DCLOBBER_FREED_MEMORY, settings which Alvaro suggested to me.I got core
dumps with these stack traces. The platform is Amazon Linux.


================== stack trace:
pgsql.build/src/test/regress/tmp_check/data/core.4149 ==================
[New LWP 4149]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `postgres: ec2-user regression [local]
VACUUM                                  '.
Program terminated with signal 11, Segmentation fault.
#0  0x00000000005916bf in rebuild_relation (verbose=0 '\000',
indexOid=0, OldHeap=0x1dd7ae0) at cluster.c:576
576             OIDNewHeap = make_new_heap(tableOid, tableSpace,
#0  0x00000000005916bf in rebuild_relation (verbose=0 '\000',
indexOid=0, OldHeap=0x1dd7ae0) at cluster.c:576
#1  cluster_rel (tableOid=tableOid@entry=28441,
indexOid=indexOid@entry=0, recheck=recheck@entry=0 '\000',
verbose=verbose@entry=0 '\000') at cluster.c:404
#2  0x00000000005ef228 in vacuum_rel (relid=relid@entry=28441,
relation=relation@entry=0x1dab408, options=options@entry=17,
params=params@entry=0x7ffdd87d72a0) at vacuum.c:1441
#3  0x00000000005f0542 in vacuum (options=17, relation=0x1dab408,
relid=relid@entry=0, params=params@entry=0x7ffdd87d72a0, va_cols=0x0,
bstrategy=<optimized out>, bstrategy@entry=0x0, isTopLevel=1 '\001') at
vacuum.c:304
#4  0x00000000005f093e in ExecVacuum (vacstmt=vacstmt@entry=0x1dab460,
isTopLevel=isTopLevel@entry=1 '\001') at vacuum.c:122
#5  0x0000000000728925 in standard_ProcessUtility (pstmt=0x1dab7c0,
queryString=0x1daa9a8 "VACUUM FULL concur_heap;",
context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x1dab8b8,
completionTag=0x7ffdd87d76a0 "") at utility.c:670
#6  0x0000000000725d82 in PortalRunUtility (portal=0x1d48a68,
pstmt=0x1dab7c0, isTopLevel=<optimized out>, setHoldSnapshot=<optimized
out>, dest=<optimized out>, completionTag=0x7ffdd87d76a0 "") at
pquery.c:1165
#7  0x0000000000726819 in PortalRunMulti (portal=portal@entry=0x1d48a68,
isTopLevel=isTopLevel@entry=1 '\001',
setHoldSnapshot=setHoldSnapshot@entry=0 '\000',
dest=dest@entry=0x1dab8b8, altdest=altdest@entry=0x1dab8b8,
completionTag=completionTag@entry=0x7ffdd87d76a0 "") at pquery.c:1315
#8  0x0000000000727488 in PortalRun (portal=portal@entry=0x1d48a68,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1
'\001', dest=dest@entry=0x1dab8b8, altdest=altdest@entry=0x1dab8b8,
completionTag=completionTag@entry=0x7ffdd87d76a0 "") at pquery.c:788
#9  0x000000000072500a in exec_simple_query (query_string=0x1daa9a8
"VACUUM FULL concur_heap;") at postgres.c:1101
#10 PostgresMain (argc=<optimized out>, argv=argv@entry=0x1d561e0,
dbname=0x1d55f30 "regression", username=<optimized out>) at postgres.c:4066
#11 0x00000000004765b4 in BackendRun (port=0x1d51420) at postmaster.c:4317
#12 BackendStartup (port=0x1d51420) at postmaster.c:3989
#13 ServerLoop () at postmaster.c:1729
#14 0x00000000006b9a0a in PostmasterMain (argc=argc@entry=8,
argv=argv@entry=0x1d2a260) at postmaster.c:1337
#15 0x00000000004775c2 in main (argc=8, argv=0x1d2a260) at main.c:228


================== stack trace:
pgsql.build/src/test/regress/tmp_check/data/core.4180 ==================
[New LWP 4180]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `postgres: ec2-user regression [local]
VACUUM                                  '.
Program terminated with signal 11, Segmentation fault.
#0  0x00000000005916bf in rebuild_relation (verbose=0 '\000',
indexOid=0, OldHeap=0x7f460d159930) at cluster.c:576
576             OIDNewHeap = make_new_heap(tableOid, tableSpace,
#0  0x00000000005916bf in rebuild_relation (verbose=0 '\000',
indexOid=0, OldHeap=0x7f460d159930) at cluster.c:576
#1  cluster_rel (tableOid=tableOid@entry=28479,
indexOid=indexOid@entry=0, recheck=recheck@entry=0 '\000',
verbose=verbose@entry=0 '\000') at cluster.c:404
#2  0x00000000005ef228 in vacuum_rel (relid=relid@entry=28479,
relation=relation@entry=0x1dab400, options=options@entry=17,
params=params@entry=0x7ffdd87d72a0) at vacuum.c:1441
#3  0x00000000005f0542 in vacuum (options=17, relation=0x1dab400,
relid=relid@entry=0, params=params@entry=0x7ffdd87d72a0, va_cols=0x0,
bstrategy=<optimized out>, bstrategy@entry=0x0, isTopLevel=1 '\001') at
vacuum.c:304
#4  0x00000000005f093e in ExecVacuum (vacstmt=vacstmt@entry=0x1dab458,
isTopLevel=isTopLevel@entry=1 '\001') at vacuum.c:122
#5  0x0000000000728925 in standard_ProcessUtility (pstmt=0x1dab7b8,
queryString=0x1daa9a8 "VACUUM FULL vactst;",
context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x1dab8b0,
completionTag=0x7ffdd87d76a0 "") at utility.c:670
#6  0x0000000000725d82 in PortalRunUtility (portal=0x1d48a68,
pstmt=0x1dab7b8, isTopLevel=<optimized out>, setHoldSnapshot=<optimized
out>, dest=<optimized out>, completionTag=0x7ffdd87d76a0 "") at
pquery.c:1165
#7  0x0000000000726819 in PortalRunMulti (portal=portal@entry=0x1d48a68,
isTopLevel=isTopLevel@entry=1 '\001',
setHoldSnapshot=setHoldSnapshot@entry=0 '\000',
dest=dest@entry=0x1dab8b0, altdest=altdest@entry=0x1dab8b0,
completionTag=completionTag@entry=0x7ffdd87d76a0 "") at pquery.c:1315
#8  0x0000000000727488 in PortalRun (portal=portal@entry=0x1d48a68,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1
'\001', dest=dest@entry=0x1dab8b0, altdest=altdest@entry=0x1dab8b0,
completionTag=completionTag@entry=0x7ffdd87d76a0 "") at pquery.c:788
#9  0x000000000072500a in exec_simple_query (query_string=0x1daa9a8
"VACUUM FULL vactst;") at postgres.c:1101
#10 PostgresMain (argc=<optimized out>, argv=argv@entry=0x1d561e0,
dbname=0x1d55f30 "regression", username=<optimized out>) at postgres.c:4066
#11 0x00000000004765b4 in BackendRun (port=0x1d51420) at postmaster.c:4317
#12 BackendStartup (port=0x1d51420) at postmaster.c:3989
#13 ServerLoop () at postmaster.c:1729
#14 0x00000000006b9a0a in PostmasterMain (argc=argc@entry=8,
argv=argv@entry=0x1d2a260) at postmaster.c:1337
#15 0x00000000004775c2 in main (argc=8, argv=0x1d2a260) at main.c:228


cheers


andrew


-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers