BUG #2019: tsearch2-related coredump - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2019
Logged by:          Bernhard Weisshuhn
Email address:      bkw@weisshuhn.de
PostgreSQL version: 8.1rc1
Operating system:   Linux Fedora Core 4 x86_64
Description:        tsearch2-related coredump
Details:

We could not yet reproduce the following coredump, but we keep trying. If
you need more info I'll be happy to supply more details. Unfortunately we
could not yet get hold of the full insert that caused it.
Most likely it was an insert into a table that has triggers to update
another table that holds tsearch2 vectors, which are indexed with a
tsearch2-gist index.


[root@berzerker]~# gdb /usr/bin/postmaster /var/lib/pgsql/data/core.18131
GNU gdb Red Hat Linux (6.3.0.0-1.84rh)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu"...Using host
libthread_db library "/lib64/libthread_db.so.1".

Core was generated by `postgres: smg_cms smg 62.8.240.222(52138) INSERT  '.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib64/libpam.so.0...done.
Loaded symbols for /lib64/libpam.so.0
Reading symbols from /lib64/libssl.so.5...done.
Loaded symbols for /lib64/libssl.so.5
Reading symbols from /lib64/libcrypto.so.5...done.
Loaded symbols for /lib64/libcrypto.so.5
Reading symbols from /usr/lib64/libkrb5.so.3...done.
Loaded symbols for /usr/lib64/libkrb5.so.3
Reading symbols from /usr/lib64/libz.so.1...done.
Loaded symbols for /usr/lib64/libz.so.1
Reading symbols from /usr/lib64/libreadline.so.5...done.
Loaded symbols for /usr/lib64/libreadline.so.5
Reading symbols from /lib64/libtermcap.so.2...done.
Loaded symbols for /lib64/libtermcap.so.2
Reading symbols from /lib64/libcrypt.so.1...done.
Loaded symbols for /lib64/libcrypt.so.1
Reading symbols from /lib64/libresolv.so.2...done.
Loaded symbols for /lib64/libresolv.so.2
Reading symbols from /lib64/libnsl.so.1...done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libdl.so.2...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libc.so.6...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/libcom_err.so.2...done.
Loaded symbols for /lib64/libcom_err.so.2
Reading symbols from /lib64/libaudit.so.0...done.
Loaded symbols for /lib64/libaudit.so.0
Reading symbols from /usr/lib64/libgssapi_krb5.so.2...done.
Loaded symbols for /usr/lib64/libgssapi_krb5.so.2
Reading symbols from /usr/lib64/libk5crypto.so.3...done.
Loaded symbols for /usr/lib64/libk5crypto.so.3
Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /usr/lib64/libkrb5support.so.0...done.
Loaded symbols for /usr/lib64/libkrb5support.so.0
Reading symbols from /lib64/libnss_files.so.2...done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /usr/lib64/pgsql/plpgsql.so...done.
Loaded symbols for /usr/lib64/pgsql/plpgsql.so
Reading symbols from /usr/lib64/pgsql/tsearch2.so...done.
Loaded symbols for /usr/lib64/pgsql/tsearch2.so
#0  RS_compile (r=0x12d5e78, issuffix=101, str=0x12adb70 "e") at
regis.c:116
116                     ptr = ptr->next;
(gdb) bt
#0  RS_compile (r=0x12d5e78, issuffix=101, str=0x12adb70 "e") at
regis.c:116
#1  0x00002aaabe56cf82 in CheckAffix (
    word=0xa1dd88 "wto-subventionsübereinkommens", len=29,
Affix=0x12d5e58,
    flagflags=Variable "flagflags" is not available.
) at spell.c:782
#2  0x00002aaabe56d1c6 in NormalizeSubWord (Conf=0x92d9e8,
    word=0xa1dd88 "wto-subventionsübereinkommens", flag=Variable "flag" is
not available.
) at spell.c:905
#3  0x00002aaabe56d9f6 in NINormalizeWord (Conf=0x92d9e8,
    word=0xa1dd88 "wto-subventionsübereinkommens") at spell.c:1130
#4  0x00002aaabe55ac80 in spell_lexize (fcinfo=Variable "fcinfo" is not
available.
) at dict_ispell.c:168
#5  0x0000000000606d69 in FunctionCall3 (flinfo=Variable "flinfo" is not
available.
) at fmgr.c:1179
#6  0x00002aaabe55dd0d in parsetext_v2 (cfg=0x93c860, prs=0x7fffffffa260,
buf=Variable "buf" is not available.
)
    at ts_cfg.c:328
#7  0x00002aaabe55fa7b in to_tsvector (fcinfo=0x7fffffffa2b0) at
tsvector.c:737
#8  0x000000000060666e in DirectFunctionCall3 (
    func=0x2aaabe55f9e0 <to_tsvector>, arg1=Variable "arg1" is not
available.
) at fmgr.c:905
#9  0x0000000000505643 in ExecMakeFunctionResult (fcache=0x99ef68,
    econtext=0x99de48, isNull=0x7fffffffae80 "\200", isDone=0x7fffffffaae4)
    at execQual.c:1096
#10 0x0000000000505346 in ExecEvalFuncArgs (fcinfo=0x7fffffffab40,
argList=Variable "argList" is not available.
)
    at execQual.c:856
#11 0x0000000000505471 in ExecMakeFunctionResult (fcache=0x99eb50,
    econtext=0x99de48, isNull=0x7fffffffb320 "\200", isDone=0x7fffffffaf84)
    at execQual.c:914
#12 0x0000000000505346 in ExecEvalFuncArgs (fcinfo=0x7fffffffafe0,
argList=Variable "argList" is not available.
)
    at execQual.c:856
#13 0x0000000000505471 in ExecMakeFunctionResult (fcache=0x99e738,
    econtext=0x99de48, isNull=0x7fffffffb7c0 "\200", isDone=0x7fffffffb424)
    at execQual.c:914
#14 0x0000000000505346 in ExecEvalFuncArgs (fcinfo=0x7fffffffb480,
argList=Variable "argList" is not available.
)
    at execQual.c:856
#15 0x0000000000505471 in ExecMakeFunctionResult (fcache=0x99e320,
    econtext=0x99de48, isNull=0x7fffffffbc60 "\200", isDone=0x7fffffffb8c4)
    at execQual.c:914
#16 0x0000000000505346 in ExecEvalFuncArgs (fcinfo=0x7fffffffb920,
argList=Variable "argList" is not available.
)
    at execQual.c:856
#17 0x0000000000505471 in ExecMakeFunctionResult (fcache=0x99df08,
    econtext=0x99de48, isNull=0x7fffffffc0a8 "\001", isDone=0x0)
    at execQual.c:914
#18 0x00002aaabe43f490 in exec_eval_simple_expr (estate=0x7fffffffc0a0,
    expr=0x992d90, isNull=0x7fffffffc0a8 "\001", rettype=Variable "rettype"
is not available.
) at pl_exec.c:3835
#19 0x00002aaabe441dcd in exec_stmt (estate=0x7fffffffc0a0, stmt=0x9928a0)
    at pl_exec.c:1806
---Type <return> to continue, or q <return> to quit---
#20 0x00002aaabe441e32 in exec_stmts (estate=0x7fffffffc0a0, stmts=Variable
"stmts" is not available.
)
    at pl_exec.c:991
#21 0x00002aaabe44236f in exec_stmt_block (estate=0x7fffffffc0a0,
    block=0x992798) at pl_exec.c:936
#22 0x00002aaabe442bd1 in plpgsql_exec_function (func=0x991b38,
    fcinfo=0x7fffffffc1f0) at pl_exec.c:286
#23 0x00002aaabe43a755 in plpgsql_call_handler (fcinfo=0x7fffffffc1f0)
    at pl_handler.c:123
#24 0x0000000000505643 in ExecMakeFunctionResult (fcache=0x9ee9a8,
    econtext=0x9ee830, isNull=0x9f14f9 "\177~\177\177\177\177\177pÎ\234",
    isDone=0x9f15b4) at execQual.c:1096
#25 0x00000000005061a0 in ExecProject (projInfo=Variable "projInfo" is not
available.
) at execQual.c:3670
#26 0x0000000000513429 in ExecResult (node=0x9ee718) at nodeResult.c:157
#27 0x0000000000503345 in ExecProcNode (node=0x9ee718) at
execProcnode.c:306
#28 0x0000000000501eb0 in ExecutorRun (queryDesc=Variable "queryDesc" is not
available.
) at execMain.c:1102
#29 0x000000000051914f in _SPI_execute_plan (plan=0x923f18,
Values=0x957340,
    Nulls=0x957398 "   n   ~", '\177' <repeats 192 times>..., snapshot=0x0,
    crosscheck_snapshot=0x0, read_only=0 '\0', tcount=0) at spi.c:1558
#30 0x000000000051949d in SPI_execute_plan (plan=0x923f18, Values=0x957340,
    Nulls=0x957398 "   n   ~", '\177' <repeats 192 times>...,
    read_only=0 '\0', tcount=0) at spi.c:336
#31 0x00002aaabe4410fa in exec_stmt (estate=0x7fffffffcbb0, stmt=0x96c61c)
    at pl_exec.c:2280
#32 0x00002aaabe441e32 in exec_stmts (estate=0x7fffffffcbb0, stmts=Variable
"stmts" is not available.
)
    at pl_exec.c:991
#33 0x00002aaabe44236f in exec_stmt_block (estate=0x7fffffffcbb0,
    block=0x96c920) at pl_exec.c:936
#34 0x00002aaabe442636 in plpgsql_exec_trigger (func=0x96abe8,
    trigdata=0x7fffffffd0e0) at pl_exec.c:562
#35 0x00002aaabe43a7ab in plpgsql_call_handler (fcinfo=0x7fffffffccb0)
    at pl_handler.c:120
#36 0x00000000004ed8ad in ExecCallTriggerFunc (trigdata=0x7fffffffd0e0,
tgindx=Variable "tgindx" is not available.

) at trigger.c:1288
#37 0x00000000004edbf4 in afterTriggerInvokeEvents (events=0x911720,
    firing_id=0, estate=0x98baf8, delete_ok=1 '\001') at trigger.c:2134
#38 0x00000000004ee1d6 in AfterTriggerEndQuery (estate=0x98baf8)
    at trigger.c:2551
#39 0x000000000058ef49 in ProcessQuery (parsetree=Variable "parsetree" is
not available.
) at pquery.c:211
#40 0x0000000000590744 in PortalRun (portal=0x9135a8,
    count=9223372036854775807, dest=0x95acd0, altdest=0x95acd0,
    completionTag=0x7fffffffd3b0 "INSERT 86602810 1") at pquery.c:1069
#41 0x000000000058c266 in exec_simple_query (
---Type <return> to continue, or q <return> to quit---
    query_string=0x905168 ' ' <repeats 200 times>...) at postgres.c:1014
#42 0x000000000058d824 in PostgresMain (argc=4, argv=0x890420,
    username=0x8903e0 "smg_cms") at postgres.c:3168
#43 0x0000000000562075 in ServerLoop () at postmaster.c:2855
#44 0x0000000000563034 in PostmasterMain (argc=5, argv=0x88c540)
    at postmaster.c:943
#45 0x00000000005237ce in main (argc=5, argv=0x88c540) at main.c:256