Skip site navigation (1) Skip section navigation (2)

BUG #1158: tsearch2 trigger crashes machine

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1158: tsearch2 trigger crashes machine
Date: 2004-05-30 21:23:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1158
Logged by:          Werner Bohl

Email address:      wbohl(at)deepdata(dot)com

PostgreSQL version: 7.4

Operating system:   RH Linux 9, kernel 2.4.20-31

Description:        tsearch2 trigger crashes machine


Using tsearch2's trigger to index a fairly short (varchar(200)) field with 
names of business crashes Linux. 

Table used has 39 fields, one of which is the business name. Bulk-inserting 
thousands of records (>50,000) crashes Linux. Error appeared consistently  
on 4 import trials, first time @ 130,000 records, second @ 160,000 records, 
third @ 64,000 records. 

Table has a pkey and also is indexed 'using gist(FIELD_NAME)' where 
FIELD_NAME is the tsvector field. 

Table resides alone in his own db & schema (public).

Linux is severly affected and the machine needs a RESET to be able to boot. 
(shutdown nor init 6 work!!) 


pgsql-bugs by date

Next:From: Tom LaneDate: 2004-05-31 04:45:12
Subject: Re: BUG #1158: tsearch2 trigger crashes machine
Previous:From: Mr sangameswar mDate: 2004-05-27 13:56:09
Subject: Re: BUG #1156: Database is not initializing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group