From: | Louis-David Mitterrand <cunctator(at)apartia(dot)ch> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | PG crashes on query |
Date: | 2000-09-20 13:59:51 |
Message-ID: | 20000920155951.A4137@styx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This (invalid) query crashes the 7.0.2 backend:
auction=# SELECT (select max(b.lot)) as last_lot,auction_status(a.id) > 0 AS current, a.lot, a.person_id, next_price(a.id), seller.mail AS seller_mail, buyer.mail AS buyer_mail, seller.locale AS seller_locale, buyer.login AS buyer_login, num_bid(a.id), seller.login AS seller_login, t.name AS auction_type FROM auction* a, person seller, person buyer, auction_type t,bid b WHERE a.id = 84 AND seller.id = a.person_id AND COALESCE(a.type,1) = t.id AND buyer.id = 2 AND b.person_id = buyer.id ;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Let me know if you need the DB schema for debugging.
--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.org
Lord, protect me from your followers.
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2000-09-20 14:01:42 | Re: 7.0.2 crash, backtrace with debug available |
Previous Message | Alfred Perlstein | 2000-09-20 13:18:08 | 7.0.2 crash, backtrace with debug available |