Re: Backend crash with tsearch
От | Oleg Bartunov |
---|---|
Тема | Re: Backend crash with tsearch |
Дата | |
Msg-id | Pine.GSO.4.44.0212031814590.20291-100000@ra.sai.msu.su обсуждение исходный текст |
Ответ на | Backend crash with tsearch ("Magnus Naeslund(f)" <mag@fbab.net>) |
Список | pgsql-hackers |
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 majordomo@postgresql.org 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: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления: