From: | "Dmitri Fuerle" <dmitri(dot)fuerle(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2027: Select on view hangs. |
Date: | 2005-11-07 17:53:08 |
Message-ID: | 20051107175308.93D7DF0F20@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2027
Logged by: Dmitri Fuerle
Email address: dmitri(dot)fuerle(at)gmail(dot)com
PostgreSQL version: 8.1
Operating system: Mac OS X
Description: Select on view hangs.
Details:
A select on the following view hangs the database
and produces the lock table at the bottom of the message
CREATE OR REPLACE VIEW "public"."report_dci_efficiency" (
invoice_id,
bill_to_name,
ship_to_name,
po_num,
ordered_date,
promised_date,
ship_date,
number_days,
late_report_note,
ignore_late)
AS
SELECT i.invoice_id, billa.comp_name AS bill_to_name, shipa.comp_name AS
ship_to_name, i.po_num, i.accepted AS ordered_date, holi.due_date AS
promised_date, (i.invoiced_date)::date AS ship_date,
((i.invoiced_date)::date - holi.due_date) AS number_days,
i.late_report_note, i.ignore_late
FROM (((invoice i JOIN history_order_line_item holi ON ((i.order_id =
holi.order_id))) JOIN address billa ON ((i.bill_to_address_id =
billa.address_id))) JOIN address shipa ON ((i.ship_to_address_id =
shipa.address_id)))
WHERE ((holi.history_order_line_item_id = (
SELECT max(tmpholi.history_order_line_item_id) AS max
FROM history_order_line_item tmpholi
WHERE (tmpholi.order_id = i.order_id)
)) AND (i.bill_to_address_id <> 12373))
ORDER BY i.invoiced_date DESC;
locktype | database | relation | page | tuple | transactionid |
classid | objid | objsubid | transaction | pid | mode | granted
---------------+----------+----------+------+-------+---------------+-------
--+-------+----------+-------------+------+-----------------+---------
relation | 7140087 | 10342 | | | |
| | | 54154 | 8978 | AccessShareLock | t
relation | 7140087 | 7582825 | | | |
| | | 54152 | 8972 | AccessShareLock | t
transactionid | | | | | 54136 |
| | | 54136 | 8967 | ExclusiveLock | t
transactionid | | | | | 54154 |
| | | 54154 | 8978 | ExclusiveLock | t
relation | 7140087 | 7140308 | | | |
| | | 54152 | 8972 | AccessShareLock | t
relation | 7140087 | 7582785 | | | |
| | | 54152 | 8972 | AccessShareLock | t
relation | 7140087 | 7140407 | | | |
| | | 54152 | 8972 | AccessShareLock | t
relation | 7140087 | 7140528 | | | |
| | | 54152 | 8972 | AccessShareLock | t
relation | 7140087 | 7140393 | | | |
| | | 54152 | 8972 | AccessShareLock | t
transactionid | | | | | 54152 |
| | | 54152 | 8972 | ExclusiveLock | t
(10 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Lori Pate | 2005-11-07 20:45:01 | FW: [pgadmin-support] Column name validation in embedded query. |
Previous Message | Nikolaos Papageorgiou | 2005-11-07 17:11:29 | BUG #2026: Greek Locale Error |