BUG #6621: Constant Segmentation Faults in the Postmaster - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      6621
Logged by:          Kris Bushover
Email address:      kris@spiceworks.com
PostgreSQL version: 9.1.3
Operating system:   Red Hat Enterprise Linux Server release 6.2 (Santi
Description:=20=20=20=20=20=20=20=20

We have been getting constant segmentation faults (signal 11) when running
PostgreSQL 9.1.  We have replaced the hardware (RAM), updated PG to the
latest version, and made changes to our configuration file as recommended by
EnterpriseDB.

I was able to get a core dump after the last fault, pasted below.

Core was generated by `postgres: dbuser db_production 10.10.11.66(46200)
EXPLAIN'.
Program terminated with signal 11, Segmentation fault.
#0  AllocSetAlloc (context=3D0x296f060, size=3D16) at aset.c:639
639     set->freelist[fidx] =3D (AllocChunk) chunk->aset;

(gdb) bt
#0  AllocSetAlloc (context=3D0x296f060, size=3D16) at aset.c:639
#1  0x000000000070b725 in MemoryContextAllocZeroAligned (context=3D0x296f06=
0,
size=3D16) at mcxt.c:571
#2  0x00000000005b6ab5 in makeString (str=3D0x7f096602eb90 "@@") at
value.c:55
#3  0x000000000068c720 in generate_operator_name (operid=3D3636, arg1=3D361=
4,
arg2=3D3615) at ruleutils.c:7148
#4  0x000000000068f9f3 in get_oper_expr (node=3D0x2b55bc0,
context=3D0x7fffba0fbc10, showimplicit=3D<value optimized out>) at
ruleutils.c:5762
#5  get_rule_expr (node=3D0x2b55bc0, context=3D0x7fffba0fbc10,
showimplicit=3D<value optimized out>) at ruleutils.c:4920
#6  0x000000000068f948 in get_rule_expr (node=3D0x2b558d0,
context=3D0x7fffba0fbc10, showimplicit=3D<value optimized out>) at
ruleutils.c:5004
#7  0x000000000069385d in deparse_expression_pretty (expr=3D0x2b558d0,
dpcontext=3D0x2bae6f8, forceprefix=3D<value optimized out>, showimplicit=3D0
'\000', prettyFlags=3D0,
    startIndent=3D0) at ruleutils.c:2118
#8  0x000000000051f434 in show_expression (node=3D0x2b558d0, qlabel=3D0x80a=
e9c
"Filter", planstate=3D<value optimized out>, ancestors=3D<value optimized o=
ut>,
    useprefix=3D0 '\000', es=3D0x7fffba0fc4f0) at explain.c:1322
#9  0x00000000005201d1 in ExplainNode (planstate=3D0x2b8a400,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1045
#10 0x0000000000520109 in ExplainNode (planstate=3D0x2b8a190,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1197
#11 0x0000000000520109 in ExplainNode (planstate=3D0x2b89ef0,
ancestors=3D0x2b5f3e0, relationship=3D0x80afc1 "Subquery", plan_name=3D<val=
ue
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1197
#12 0x00000000005204b9 in ExplainNode (planstate=3D0x2b89620,
ancestors=3D0x2b5f3e0, relationship=3D0x80b02c "Member", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1234
#13 0x00000000005218a5 in ExplainMemberNodes (plans=3D<value optimized out>,
planstates=3D<value optimized out>, ancestors=3D0x2b5f3e0, es=3D0x7fffba0fc=
4f0) at
explain.c:1697
#14 0x00000000005201f3 in ExplainNode (planstate=3D0x2b78e70,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1229
#15 0x0000000000520109 in ExplainNode (planstate=3D0x2b78340,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1197
#16 0x0000000000520109 in ExplainNode (planstate=3D0x2b77a50,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1197
#17 0x0000000000520109 in ExplainNode (planstate=3D0x2b71460,
ancestors=3D0x2b5f3e0, relationship=3D0x80afb5 "Outer", plan_name=3D<value
optimized out>, es=3D0x7fffba0fc4f0)
    at explain.c:1197
#18 0x0000000000520109 in ExplainNode (planstate=3D0x2b711f0,
ancestors=3D0x2b5f3e0, relationship=3D0x0, plan_name=3D<value optimized out=
>,
es=3D0x7fffba0fc4f0)
    at explain.c:1197
#19 0x0000000000521259 in ExplainOnePlan (plannedstmt=3D0x2b5b310,
es=3D0x7fffba0fc4f0, queryString=3D<value optimized out>, params=3D0x0) at
explain.c:404
#20 0x000000000052170b in ExplainOneQuery (stmt=3D0x2981830,
queryString=3D<value optimized out>, params=3D0x0, dest=3D0x29709e8) at
explain.c:296
#21 ExplainQuery (stmt=3D0x2981830, queryString=3D<value optimized out>,
params=3D0x0, dest=3D0x29709e8) at explain.c:202
#22 0x0000000000634137 in PortalRunUtility (portal=3D0x296c8a0,
utilityStmt=3D0x2981830, isTopLevel=3D1 '\001', dest=3D0x29709e8,
completionTag=3D0x7fffba0fc5a0 "")
    at pquery.c:1184
#23 0x00000000006353bd in FillPortalStore (portal=3D0x296c8a0, isTopLevel=
=3D1
'\001') at pquery.c:1058
#24 0x00000000006358ff in PortalRun (portal=3D0x296c8a0,
count=3D9223372036854775807, isTopLevel=3D1 '\001', dest=3D0x2928ab0,
altdest=3D0x2928ab0,
    completionTag=3D0x7fffba0fc920 "") at pquery.c:782
#25 0x00000000006331ee in exec_execute_message (argc=3D<value optimized out=
>,
argv=3D<value optimized out>, username=3D<value optimized out>) at
postgres.c:1963
#26 PostgresMain (argc=3D<value optimized out>, argv=3D<value optimized out=
>,
username=3D<value optimized out>) at postgres.c:3983
#27 0x00000000005f46c9 in BackendRun () at postmaster.c:3606
#28 BackendStartup () at postmaster.c:3291
#29 ServerLoop () at postmaster.c:1455
#30 0x00000000005f6e5c in PostmasterMain (argc=3D<value optimized out>,
argv=3D<value optimized out>) at postmaster.c:1116
#31 0x0000000000598a40 in main (argc=3D5, argv=3D0x28524d0) at main.c:199