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
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 |