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

Re: BUG #6407: Crash on queries to gin index with multiply values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: don(at)rosfirm(dot)ru
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6407: Crash on queries to gin index with multiply values
Date: 2012-01-23 06:39:26
Message-ID: 4354.1327300766@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
don(at)rosfirm(dot)ru writes:
> When making "in" query to fiels with gin index, server crashes. Below 
> create table tmp(id serial not null primary key, f1 integer, f2 text);
> insert into tmp (f1,f2) values (1,'a'),(2,'b'),(3,'c');
> create index tmp_f1_idx on tmp using gin (f1);
> create index tmp_f2_idx on tmp using gin (f2);

I assume you've got contrib/btree_gin installed?  Because in a bare
server those CREATE INDEX commands wouldn't work at all.

> set enable_seqscan to off;
> select * from tmp where f1 in (1, 2);
> After this query server chrashes:
> server process (PID ...) was terminated by signal 11: Segmentation fault
> The same after query on text field:
> select * from tmp where f2 in ('a', 'd');

FWIW, works for me.  Do you have any nonstandard settings that might
affect this?  Is it possible you've got a copy of btree_gin.so that
isn't compatible with your server?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Guillaume LelargeDate: 2012-01-23 09:54:10
Subject: Re: BUG #6406: Included pgAdmin does not have .sql file extension mapped
Previous:From: donDate: 2012-01-23 05:56:52
Subject: BUG #6407: Crash on queries to gin index with multiply values

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