On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> I'm evaluating tsearch contrib module, and i get a backend crash when
> i'm about to use a tsearch function.
>
> When i issue
> update things set nidx=txt2txtidx(productname),
> didx=txt2txtidx(longdescription);
>
> The backend dies in a segfault.
> The system is redhat 7.3 dual athlon w/ 1GB memory.
> Postgresql is compiled with -march=athlon -O3.
> initdb -E LATIN1
Please, tell us postgresql version. Did you reinstall tsearch after
upgrading ? Test-suite (data, sql) demonstrated the problem would be
nice.
>
> I have a huge shared buffer count (65536).
>
> I'll reinstall tsearch and try again soon.
> Is it necesary to install OpenFTS contrib aswell, or do i get away with
> only installing tsearch?
For contrib/tsearch you need only tsearch :)
> Now i do both...
>
> Backtrace:
>
> #0 0x02d10000 in ?? ()
> #1 0x401faf48 in ?? ()
> #2 0x401fb5e6 in ?? ()
> #3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
> arguments=0x82ce170, econtext=0x82d3580, isNull=0xbfffec8f "",
> isDone=0xbfffecd8) at execQual.c:839
> #4 0x080d99a3 in ExecEvalExpr (expression=0x82ce188,
> econtext=0x82d3580, isNull=0xbfffec8f "", isDone=0xbfffecd8)
> at execQual.c:1168
> #5 0x080d9d44 in ExecTargetList (targetlist=0x82ce3d8, nodomains=21,
> targettype=0x82cf230, values=0x82d4488,
> econtext=0x82d3580, isDone=0xbfffee78) at execQual.c:2058
> #6 0x080da13f in ExecProject (projInfo=0x82d3b08, isDone=0xbfffee78) at
> execQual.c:2282
> #7 0x080da229 in ExecScan (node=0x82cfeb8, accessMtd=0x80e1270
> <SeqNext>) at execScan.c:133
> #8 0x080e1093 in ExecSeqScan (node=0x82cfeb8) at nodeSeqscan.c:133
> #9 0x080d7d9c in ExecProcNode (node=0x82cfeb8, parent=0x0) at
> execProcnode.c:291
> #10 0x080d6a47 in ExecutePlan (estate=0x82d0000, plan=0x82cfeb8,
> operation=CMD_UPDATE, numberTuples=0,
> direction=ForwardScanDirection, destfunc=0x82d3b30) at
> execMain.c:954
> #11 0x080d7682 in ExecutorRun (queryDesc=0x82d35f0, estate=0x82d0000,
> direction=ForwardScanDirection, count=0) at execMain.c:195
> #12 0x0812a8cb in ProcessQuery (parsetree=0x82cb1c8, plan=0x82cfeb8,
> dest=Remote, completionTag=0xbffff060 "") at pquery.c:242
> #13 0x08128b81 in pg_exec_query_string (query_string=0x82cb0a8,
> dest=Remote, parse_context=0x8291cd0) at postgres.c:838
> #14 0x08129b50 in PostgresMain (argc=4, argv=0xbffff2e0,
> username=0x827ccd1 "mag") at postgres.c:2016
> #15 0x0810f0c4 in DoBackend (port=0x827cba0) at postmaster.c:2293
> #16 0x0810e9dc in BackendStartup (port=0x827cba0) at postmaster.c:1915
> #17 0x0810de8d in ServerLoop () at postmaster.c:1000
> #18 0x0810da24 in PostmasterMain (argc=1, argv=0x8245640) at
> postmaster.c:779
> #19 0x080ea5c2 in main (argc=1, argv=0xbffffc74) at main.c:210
> #20 0x42017589 in __libc_start_main () from /lib/i686/libc.so.6
>
> Magnus
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Programmer/Networker [|] Magnus Naeslund
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
