Bug #936: pq_flush: send() failed on big query

Jaroslaw Maruszewski (j.maruszewski@zkz.com.pl) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
pq_flush: send() failed on big query

Long Description
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.95.4

A stupid (accidentaly isuued) query with plan:

Nested Loop  (cost=0.00..44837482.16 rows=1162184800 width=238)
  ->  Nested Loop  (cost=0.00..10354.16 rows=207533 width=155)
        ->  Index Scan using dkj_probka_pk on dkj_probka  (cost=0.00..594.50 rows=5609 width=137)
        ->  Seq Scan on dkj_kopalnia  (cost=0.00..1.37 rows=37 width=18)
  ->  Seq Scan on dkj_dostawa  (cost=0.00..160.00 rows=5600 width=83)

log (with statement_timeout = 900000):

2003-04-07 12:33:41 [8924]   LOG:  connection received: host=[local]
2003-04-07 12:33:41 [8924]   LOG:  connection authorized: user=jm database=tst
2003-04-07 12:33:41 [8924]   LOG:  query: begin; select getdatabaseencoding(); commit
2003-04-07 12:33:41 [8924]   LOG:  duration: 0.021872 sec
2003-04-07 12:33:41 [8924]   LOG:  query: SELECT
2003-04-07 12:38:32 [8924]   LOG:  pq_flush: send() failed: connection reset by peer
2003-04-07 12:38:32 [8924]   LOG:  pq_flush: send() failed: broken pipe
2003-04-07 12:48:41 [8924]   ERROR:  Query was cancelled.
2003-04-07 12:48:41 [8924]   LOG:  pq_recvbuf: unexpected EOF on client connection

Whats, imho, wrong: Big query cause shortage of resources and
postmaster isue misleading error message. Also, postmaster task should
be killed immediatelly, not by timeout.
Regards


Sample Code
SELECT
    dkj_probka."nrproby", dkj_probka."wt", dkj_probka."ad", dkj_probka."vd", dkj_probka."vdaf",
    dkj_probka."std", dkj_probka."a", dkj_probka."b", dkj_probka."ri", dkj_probka."cl",
    dkj_probka."p", dkj_probka."alkalia",
    dkj_dostawa."nrlistuprzew", dkj_dostawa."datadostawy", dkj_dostawa."tonaz",
    dkj_dostawa."wt", dkj_dostawa."ad", dkj_dostawa."vdaf", dkj_dostawa."ri", dkj_dostawa."std",
    dkj_kopalnia."knazwa"
FROM
    "public"."dkj_probka" dkj_probka,
    "public"."dkj_dostawa" dkj_dostawa,
    "public"."dkj_kopalnia" dkj_kopalnia
ORDER BY
    dkj_probka."nrproby" ASC;



No file was uploaded with this report