From: | "H(dot)J(dot) Sanders" <hjs(at)rmax(dot)nl> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | error 57014 |
Date: | 2006-06-09 02:08:23 |
Message-ID: | GMEAJIDMNDKCIHMMHDFLIEPLDNAA.hjs@rmax.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello.
The next query runs into error 57014 in about 50 % of the cases. We
certainly have not aborted the request. In the other 50 % it runs OK. The
statement is executed
in pgsql 7.4.8
Statement:
------------
SELECT pst.typ_stay, SUM(pst.nr_rooms), SUM(pst.nr_trans), SUM(pst.pst_amnt)
from pst where pst.companyc = 'H' AND pst.pst_date >= (date '2006-01-01')
AND pst.pst_date <= (date '2006-06-08') AND pst.pst_type IN (1,7) AND
pst.typ_stay IS NOT NULL AND pst.dpt_code = 'FO' GROUP BY pst.typ_stay ;
Extract logfile
----------------
2006-06-09 03:55:06 LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:2946
2006-06-09 03:55:37 ERROR: 57014: canceling query due to user request
LOCATION: ProcessInterrupts, postgres.c:1964
STATEMENT: SELECT pst.typ_stay, SUM(pst.nr_rooms), SUM(pst.nr_trans),
SUM(pst.pst_amnt) from pst where pst.companyc = 'H' AND pst.pst_date >=
(date '2006-01-01') AND pst.pst_date <= (date '2006-06-08') AND pst.pst_type
IN (1,7) AND pst.typ_stay IS NOT NULL AND pst.dpt_code = 'FO' GROUP BY
pst.typ_stay ;
2006-06-09 03:56:07 LOG: 08P01: unexpected EOF on client connection
Anyone any idea?
Many thanks
Henk Sanders
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2006-06-09 02:10:06 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model |
Previous Message | David Fetter | 2006-06-09 01:32:17 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model |