| Lists: | pgsql-generalpgsql-hackers |
|---|
| From: | Argo Priivits <listdb(at)hot(dot)ee> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | 7.3 txt2txtidx -> crash |
| Date: | 2002-12-08 15:05:19 |
| Message-ID: | 20021208150519.96898A9AD6@hot.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
Hi,
I have a problem with contrib/tsearch module.
Simple select txt2txtidx('2-3') causes psql to crash with error:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
As I found out, this happens allways when in txt2txtidx input parameter occurs string with pattern: "number hyphen" or "hyphen number" !!!
pg 7.3
redhat 7.3
Thanks, any idea ?
-----------------------------------------
Hot Mobiil - helinad, logod ja piltsnumid!
http://www.hot.ee
| From: | "Magnus Naeslund(f)" <mag(at)fbab(dot)net> |
|---|---|
| To: | "Argo Priivits" <listdb(at)hot(dot)ee> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] 7.3 txt2txtidx -> crash |
| Date: | 2002-12-08 15:44:02 |
| Message-ID: | 106601c29ed0$a2079fb0$f80c0a0a@mnd |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
Yes i found this bug earlier.
There is a patch for it in the mail archives.
Magnus
Argo Priivits <listdb(at)hot(dot)ee> wrote:
> Hi,
>
> I have a problem with contrib/tsearch module.
>
> Simple select txt2txtidx('2-3') causes psql to crash with error:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
>
> As I found out, this happens allways when in txt2txtidx input
> parameter occurs string with pattern: "number hyphen" or "hyphen
> number" !!!
>
> pg 7.3
> redhat 7.3
>
> Thanks, any idea ?
>
| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Argo Priivits <listdb(at)hot(dot)ee> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 7.3 txt2txtidx -> crash |
| Date: | 2002-12-08 21:09:39 |
| Message-ID: | Pine.GSO.4.44.0212090008500.28113-100000@ra.sai.msu.su |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general pgsql-hackers |
Argo,
this is known bug, please find patch from
http://www.sai.msu.su/~megera/postgres/gist/
Regards,
Oleg
On Sun, 8 Dec 2002, Argo Priivits wrote:
> Hi,
>
> I have a problem with contrib/tsearch module.
>
> Simple select txt2txtidx('2-3') causes psql to crash with error:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
>
> As I found out, this happens allways when in txt2txtidx input parameter occurs string with pattern: "number hyphen" or "hyphen number" !!!
>
> pg 7.3
> redhat 7.3
>
> Thanks, any idea ?
>
>
>
> -----------------------------------------
> Hot Mobiil - helinad, logod ja piltsУnumid!
> http://www.hot.ee
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83