From: | maxim(dot)boguk(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7579: repeatable Segmentation fault on some query (even in Explain) |
Date: | 2012-10-03 10:14:36 |
Message-ID: | E1TJLyO-0001h7-B7@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7579
Logged by: Maxim Boguk
Email address: maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 9.2.1
Operating system: Linux
Description:
Hi,
After testing migration to 9.2.1, Segmentation fault query were found.
It produce error:
2012-10-02 23:05:05 MSK LOG: server process (PID 28234) was terminated by
signal 11: Segmentation fault
It crash even with explain of the query.
I can not create self-contained test case yet... but I working on it...
Query:
select
OIR.OrderItemReserveID
from OrderItemReserves as OIR
inner join OrderItems as OI on (OI.OrderItemID = OIR.OrderItemID)
left outer join (
select
distinct CSI.SaleArticleID
from CatalogueSectionItems as CSI
inner join CatalogueSections as CS on (CS.CatalogueSectionID =
CSI.CatalogueSectionID)
where
CS.CatalogueID = 20083
) as CSI on (CSI.SaleArticleID = OI.SaleArticleID)
where
OIR.ObjectStatusID = 1
and OIR.Amount >0
and (
OIR.StoreGroupID = 5
or (OIR.StoreGroupID = 6 and CSI.SaleArticleID is not null)
)
Without distinct on left join subquery - no problem.
Without 'CSI.SaleArticleID is not null' part no problem too.
From | Date | Subject | |
---|---|---|---|
Next Message | maxim.boguk | 2012-10-03 10:32:19 | BUG #7580: repeatable test case for the BUG #7579 |
Previous Message | l1t | 2012-10-03 01:34:49 | RE:Re: BUG #7556 addition info |