Re: BUG #1158: tsearch2 trigger crashes machine - Mailing list pgsql-bugs

From Werner Bohl
Subject Re: BUG #1158: tsearch2 trigger crashes machine
Date
Msg-id 1085983587.19968.3.camel@sirio.sii
Whole thread Raw
In response to Re: BUG #1158: tsearch2 trigger crashes machine  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sun, 2004-05-30 at 22:45, Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> > Linux is severly affected and the machine needs a RESET to be able to boot.
> > (shutdown nor init 6 work!!)
>
> Sure you're not looking at hardware problems?  PG should certainly not
> be able to crash a properly functioning kernel (since PG isn't a
> privileged process) and I haven't heard many complaints against later
> 2.4 series kernels either.  My money is on flaky hardware...
>

Running the bulk insert process without the trigger does work well. We
did an update to the tsvector afterwards and it also worked without a
hitch. Therefore I suspect of the trigger.

TIA,

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1158: tsearch2 trigger crashes machine
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1159: server closed the connection unexpectedly