Postgres dies when using an intarray operator

From: jeroen van iddekinge <iddekingej(at)lycos(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres dies when using an intarray operator
Date: 2006-04-01 13:40:19
Message-ID: 1143898819.8952.19.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

When using intarray operator in a query, postgres dies and restart
itself when executing the following query:

select r1.bet_sentence & r2.bet_sentence
from related r1,related r2
where r1.bet_sentence && r2.bet_sentence

the log file contains the following:

LOG: server process (PID 14283) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2006-04-01 15:07:04 CEST
LOG: checkpoint record is at 1/E9178B1C
This is the only information I can find

'related' has the following definition:

Column | Type | Modifiers
--------------+------------------------+-----------
id | integer | not null
id_line | integer |
id_linegroup | integer |
id_word_1 | integer |
id_word_2 | integer |
rtype | character varying(100) |
bet_sentence | integer[] |
there are about 100 000 records in this table.

The crash only happends when I create the gist index on bet_sentence:

create index ind_related_7 on related using gist ( bet_sentence gist__int_ops);

Using unbuntu 5.1 ,postgres version 8.1.3,compiled from source and intarray installed

Can someone explain this crash?

Thanks

Jeroen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-04-01 14:58:51 Re: Suggestion: Which Binary?
Previous Message Andrew Dunstan 2006-04-01 13:24:44 Re: Remote PL/Java, Summary