BUG #1473: Backend bus error, possibly due to ANALYZE - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1473
Logged by:          Brian B.
Email address:      brian-pgsql@bbdab.org
PostgreSQL version: 8.0.1
Operating system:   FreeBSD 4.11-STABLE
Description:        Backend bus error, possibly due to ANALYZE
Details:

Hello,

I am loading some spam/ham data/tokens, to be used for the dspam anti-spam
software, into PostgreSQL. After a few hours of inserting and updating the
existing data, the backend crashes with a signal 10 (bus error). I am also
running an ANALYZE command to help keep the indexes up to date every 10
minutes. I have rebuilt PostgreSQL with debugging enabled and have a
resulting core dump. I am not sure who to send this to, however. The
backtrace using the core file is as follows:

#0  0x80c4b52 in transformExpr (pstate=0x86fa630, expr=0x85ec148)
    at parse_expr.c:81
#1  0x80c5126 in transformExpr (pstate=0x86fa630, expr=0x85ec1d0)
    at parse_expr.c:270
#2  0x80c5126 in transformExpr (pstate=0x86fa630, expr=0x85ec258)
    at parse_expr.c:270
#3  0x80c5126 in transformExpr (pstate=0x86fa630, expr=0x85ec2e0)
    at parse_expr.c:270

[... repeat above several thousand times ...]

#8139 0x80c5126 in transformExpr (pstate=0x86fa630, expr=0x86fa530)
    at parse_expr.c:270
#8140 0x80c50c2 in transformExpr (pstate=0x86fa630, expr=0x86fa558)
    at parse_expr.c:257
#8141 0x80c40e3 in transformWhereClause (pstate=0x86fa630, clause=0x86fa558,

    constructName=0x81f8e75 "WHERE") at parse_clause.c:1013
#8142 0x80b178d in transformSelectStmt (pstate=0x86fa630, stmt=0x86fa580)
    at analyze.c:1826
#8143 0x80af817 in transformStmt (pstate=0x86fa630, parseTree=0x86fa580,
    extras_before=0xbfbfe6f0, extras_after=0xbfbfe6f4) at analyze.c:371
#8144 0x80af5ba in do_parse_analyze (parseTree=0x86fa580, pstate=0x86fa630)
    at analyze.c:245
#8145 0x80af4ba in parse_analyze (parseTree=0x86fa580, paramTypes=0x0,
    numParams=0) at analyze.c:169
#8146 0x816fc9e in pg_analyze_and_rewrite (parsetree=0x86fa580,
    paramTypes=0x0, numParams=0) at postgres.c:555
#8147 0x8170061 in exec_simple_query (
    query_string=0x83cd018 "SELECT uid, token, spam_hits, innocent_hits FROM
dspam_token_data WHERE uid = '1000' AND token IN
('913609592713134710','6655100721407275609','-7433241509246025544','61795992
61633421689','588386968494"...)
    at postgres.c:872
#8148 0x8172713 in PostgresMain (argc=4, argv=0x82e4258,
    username=0x82e4238 "dspam") at postgres.c:3007
#8149 0x814dc49 in BackendRun (port=0x82e2000) at postmaster.c:2816
#8150 0x814d47e in BackendStartup (port=0x82e2000) at postmaster.c:2452
#8151 0x814b9ba in ServerLoop () at postmaster.c:1199
#8152 0x814b31a in PostmasterMain (argc=3, argv=0xbfbff3d0) at
postmaster.c:918
#8153 0x811f2b9 in main (argc=3, argv=0xbfbff3d0) at main.c:268
(gdb)

I have compiled PostgreSQL with pthread for pl/python capability.


Thanks,

Brian