Re: BUG #1158: tsearch2 trigger crashes machine

Поиск
Список
Период
Сортировка
От Werner Bohl
Тема Re: BUG #1158: tsearch2 trigger crashes machine
Дата
Msg-id 1085983587.19968.3.camel@sirio.sii
обсуждение исходный текст
Ответ на Re: BUG #1158: tsearch2 trigger crashes machine  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1158: tsearch2 trigger crashes machine
Следующее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1159: server closed the connection unexpectedly