backend crashes with mnogosearch

From: Nick Wellnhofer <nick(at)paradigmashift(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: backend crashes with mnogosearch
Date: 2001-04-05 13:50:36
Message-ID: 3ACC782C.F3BAD0C4@paradigmashift.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi postgres-team,

i have set up a the mnogosearch engine on our webserver using postgresql
version 7.0.2. in the last time i experienced server errors when searching
for certain keywords. it turned out that the problem was the database
crashing on certain select statements on the mnogosearch url table.

further investigatoin showed that a simple "SELECT * FROM url" query
resulted in

Backend message type 0x44 arrived while idle
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

then i tried several "SELECT * FROM url LIMIT <some number>" queries.
up to a certain number the queries were successful, but from that
number on i got the error message.

i thought about upgrading to postgresql 7.0.3, but since i expect
version 7.1 to be released soon, i decided to wait until then.

i know this is probably not enough information for you to tell me
what is the problem exactly, but maybe you have a quick work-around.

thanks,

nick wellnhofer

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyle F. Downey 2001-04-05 14:16:33 error creating table that worked under 7.0.3
Previous Message pgsql-bugs 2001-04-05 09:51:01 compilation error