Postgres dies when using an intarray operator
От | jeroen van iddekinge |
---|---|
Тема | Postgres dies when using an intarray operator |
Дата | |
Msg-id | 1143898819.8952.19.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Postgres dies when using an intarray operator
|
Список | 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 nullid_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
В списке pgsql-hackers по дате отправления: