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

BUG #2106: EXPLAIN ANALYZE with SELECT query causes a single backend server process to segfault

From: "" <bugrep(at)oldanygroup(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2106: EXPLAIN ANALYZE with SELECT query causes a single backend server process to segfault
Date: 2005-12-09 19:03:48
Message-ID: 20051209190348.2139BF0B5B@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2106
Logged by:          
Email address:      bugrep(at)oldanygroup(dot)cz
PostgreSQL version: 8.1.0, 8.2devel
Operating system:   CentOS 4.2 with 2.6.13.4-SMP kernel
Description:        EXPLAIN ANALYZE with SELECT query causes a single
backend server process to segfault
Details: 

Hello,

while testing the 8.1.0 version of PostgreSQL (we've been using version
7.4.8 for a long time), the EXPLAIN ANALYZE causes a single backend server
process to segfault after issuing the following query:

SELECT obch_vyrobek.id_vyrobku AS id_vyrobku,
      obch_vyrobek.id_vyrobce AS id_vyrobce,
      obch_vyrobce.nazev AS nazev_vyrobce,
      CASE obch_vyrobek.nazev ILIKE '%aloe%' WHEN true THEN 1 ELSE 0 END AS
match_nazev_vyrobku
FROM obch_vyrobek LEFT JOIN obch_vyrobce USING (id_vyrobce)
WHERE (obch_vyrobek.aktivni AND ((obch_vyrobek.sukl IS NULL AND
obch_vyrobek.v_katalogu) OR (obch_vyrobek.sukl IS NOT NULL) OR
(obch_vyrobek.odhadovana_dostupnost IS NOT NULL))) AND (obch_vyrobek.nazev
ILIKE
'%aloe%' OR obch_vyrobek.popis ILIKE '%aloe%' OR
coalesce(obch_vyrobek.popis_od_vyrobce,obch_vyrobek.popis) ILIKE '%aloe%'
OR
obch_vyrobce.nazev ILIKE '%aloe%')
ORDER BY otc DESC, typ DESC, odhadovana_dostupnost DESC, obr_m DESC,
match_nazev_vyrobku DESC, obch_vyrobek.nazev;

The same happens with version 8.2devel. There are no segfaults with such
EXPLAIN ANALYZE followed by abovementioned query when using version 7.4.8,
even 8.0.4 is ok.

Responses

pgsql-bugs by date

Next:From: Reuben PasquiniDate: 2005-12-09 19:16:06
Subject: Re: BUG #2104: pg_xlog/ trace files not reclaimed by server
Previous:From: alejandro ramirezDate: 2005-12-09 18:09:52
Subject: BUG #2105: ERROR: relation "comoma" does not exist

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