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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
