Ok, I nailed the bug, but i'm not sure what the correct fix is.
Attached tsearch_morph.diff that remedies this problem by avoiding it.
Also there's a debug aid patch if someone would like to know how i
finally found it out :)
There problem in the lemmatize() function is that GETDICT(...) returned
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>
> So, the problem may be in rh 7.3 ?
>
Might be, i'm debugging it now, and i can see that the dicts[] array in
morph.c is beeing overwritten with junk.
I can trigger it with this query:
select txt2txtidx('Can - Live 1971-77');
Is there any good way of
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> >> 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?
> >> Now i do both...
> >
> > Can you give u
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>
> Works on FreeBSD/Alpha for me. Maybe you've got some weirdness with
> bad RAM chips or something?
>
> Chris
Could be, but it only shows when i do this, and the server has been up
for several months.
If everything else failes, i'll run memtest
> No i can't, it's not my data to give :(
OK
> But it doesn't matter since if you run "gmake installcheck" in
> contrib/tsearch it will explode.
>
> A funny thing is that i installed pg7.3 on an linux intel celeron system
> (rh8.0) w/128 mb memory, and THERE it works!
Works on FreeBSD/Alpha for
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>> 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?
>> Now i do both...
>
> Can you give us the compressed text? I can try it on my installation
> and
> 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?
> Now i do both...
Can you give us the compressed text? I can try it on my installation and
see if there's the same problem?
Chris
-
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
>
> Sorry, I have no any idea. Just only full reinstall (with initdb
> and rm -rf /usr/local/pgsql) postgresql...
> Can you give me login on you computer for a several hours?
>
The thing is that when i ran the thing breakpointing on parsetext() at
the
As you wish...
This is a bt taken from a core file this time (the other ones were from
attached processes).
The whole thing has been recompiled with no additional compiler flags
(i.e. removed -march=athlon -O3), but still with --enable-debug
and --enable-cassert.
Sorry, I have no any idea. J
Some more (useless) info.
objdump -x /lib/*.so /usr/lib/*.so /lib/i686/*.so /usr/kerberos/lib/*.so
/usr/local/pgsql/bin/* /usr/local/pgsql/lib/*.so | grep lemmatize
reviels only one lemmatize symbol.
The offending address 0x02d1 is not mapped anywhere in the address
space according to /proc/
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Magnus, we need backtrace from 'make installcheck'
>
As you wish...
This is a bt taken from a core file this time (the other ones were from
attached processes).
The whole thing has been recompiled with no additional compiler flags
(i.e. removed -march=ath
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> > Pls, send backtrace... :)
> >
>
> I already have, twice.
Magnus, we need backtrace from 'make installcheck'
>
> Magnus
>
> ---(end of broadcast)---
> TIP 4
Teodor Sigaev wrote:
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, &lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for
postgresql?
It seems to me that we see a name conflict. Function lemmatize is
de
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> Pls, send backtrace... :)
>
I already have, twice.
Magnus
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Pls, send backtrace... :)
Magnus Naeslund(f) wrote:
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
Magnus,
what is an output of 'make installcheck' ?
As i said, it segfaults:
[root@fet1b tsearch]# gmake installcheck
gmake -C ../../src/test/regress pg_regress
gmake[1]: Entering directory `/usr/s
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> Does it crashed?
> # select txt2txtidx('Can - Live 1971-77');
>
>
> Line txtidx.c:366 :
> lemm = lemmatize(token, &lenlemm, type);
>
> lemmatize() is defined in morph.c. Did you use another modules for
> postgresql?
>
> It seems to me that we see a name c
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Magnus,
>
> what is an output of 'make installcheck' ?
As i said, it segfaults:
[root@fet1b tsearch]# gmake installcheck
gmake -C ../../src/test/regress pg_regress
gmake[1]: Entering directory `/usr/src/postgresql-7.3/src/test/regress'
gmake[1]: `pg_re
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, &lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for postgresql?
It seems to me that we see a name conflict. Function lemmatize is defined in
somewhere also.
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> >
> > Please, tell us postgresql version. Did you reinstall tsearch after
> > upgrading ? Test-suite (data, sql) demonstrated the problem would be
> > nice.
> >
>
> pgsql 7.3, about 700mb text database with
More info, the gdb> sharedlibrary loaded some more symbols:
(gdb) bt
#0 0x02d1 in ?? ()
#1 0x401faf48 in parsetext (prs=0xbfffea60, buf=0x4277eb3c "Can - Live
1971-77", buflen=18) at txtidx.c:366
#2 0x401fb5e6 in txt2txtidx (fcinfo=0xbfffeaf0) at txtidx.c:487
#3 0x080ec45c in ExecMakeFunct
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>
> Please, tell us postgresql version. Did you reinstall tsearch after
> upgrading ? Test-suite (data, sql) demonstrated the problem would be
> nice.
>
pgsql 7.3, about 700mb text database with product descriptions.
I'm working on isolation the behavior, t
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.
>
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Be sure to eliminate the possibility that you're loading the wrong
> version of the .so (ie, loading a 7.2 tsearch.so into 7.3). People
> get bit by that quite frequently right after an upgrade ...
>
Well, this is a clean install, so that isn't a problem.
"Magnus Naeslund\(f\)" <[EMAIL PROTECTED]> writes:
> It's either that it can't load the lib (shouldn't it complain?) or it's
> a bad pointer.
Be sure to eliminate the possibility that you're loading the wrong
version of the .so (ie, loading a 7.2 tsearch.so into 7.3). People
get bit by that quite
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
>> The backend dies in a segfault.
>
>> Backtrace:
>
>> #0 0x02d1 in ?? ()
>> #1 0x401faf48 in ?? ()
>> #2 0x401fb5e6 in ?? ()
>> #3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
>> arguments=0x
"Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
> The backend dies in a segfault.
> Backtrace:
> #0 0x02d1 in ?? ()
> #1 0x401faf48 in ?? ()
> #2 0x401fb5e6 in ?? ()
> #3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
> arguments=0x82ce170, econtext=0x82d3580, isNull=0xbfffec8f
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
27 matches
Mail list logo
