Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5B987476E2E for ; Thu, 26 Sep 2002 14:07:54 -0400 (EDT) Received: from yridian.wellsfargo.com (yridian.wellsfargo.com [159.37.7.66]) by postgresql.org (Postfix) with ESMTP id D72E2476D8F for ; Thu, 26 Sep 2002 14:07:53 -0400 (EDT) Received: from unixm4.wellsfargo.com (unixm4.wellsfargo.com [10.30.2.214]) by yridian.wellsfargo.com (Postfix) with ESMTP id DC2871FA9 for ; Thu, 26 Sep 2002 11:07:42 -0700 (MST) Received: from xcgi-calax-02.wellsfargo.com (localhost [127.0.0.1]) by unixm4.wellsfargo.com (8.9.3/8.9.3) with ESMTP id NAA14802 for ; Thu, 26 Sep 2002 13:07:44 -0500 (CDT) From: jonesbl@WellsFargo.COM Received: by xcgi-calax-02.wellsfargo.com with Internet Mail Service (5.5.2653.19) id ; Thu, 26 Sep 2002 11:07:04 -0700 Message-ID: <5BA4EAE4ACF6D211BC540001FA7EB1960AE53AF3@xcem-casfo-11.wellsfargo.com> To: pgsql-sql@postgresql.org Subject: query problem "server sent binary data ... without prior row desc ription ..." Date: Thu, 26 Sep 2002 11:07:02 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/371 X-Sequence-Number: 9648 I'm having a problem with postgres on HPUX. My version is: VERSION = 'PostgreSQL 7.2.2 on hppa2.0w-hp-hpux11.11, compiled by aCC -Ae' I'm trying to do a query and it consistently gives the following errors: wily=# \a Output format is unaligned. wily=# \f ';' Field separator is ';'. wily=# \t Showing only tuples. wily=# select * from wt_metric_backup where intended_end_ts < '2002-08-16 00:00:00.000-7'; the query runs for 10 minutes or so, then outputs: server sent binary data ("B" message) without prior row description ("T" message) server sent binary data ("B" message) without prior row description ("T" message) server sent binary data ("B" message) without prior row description ("T" message) unexpected character n following empty query response ("I" message) server sent data ("D" message) without prior row description ("T" message) server sent data ("D" message) without prior row description ("T" message) server sent binary data ("B" message) without prior row description ("T" message) then it prompts me for some input: Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> \. server sent binary data ("B" message) without prior row description ("T" message) unexpected response from server; first received character was "0" lost synchronization with server, resetting connection Asynchronous NOTIFY 'ntsTask|perform:Response Time (mccoust r@ ' from backend with pid 1667460981 received. I've tried this several times. After I got the error the first time I ran a vacuum analysis on the table and added an index on the query field (wt_metric_backup.intended_end_ts) but I get the same results. The error log doesn't show anything unusual until after I kill the query. Looks like it's losing packets/messages (server sent binary data ("B" message) without prior row description ("T" message)), but the errors are consistent between attempts - I would expect packet loss to be random. Simpler queries such as: select min(intended_end_ts) from wt_metric_backup; work okay. Any ideas? Thanks, Bill Jones Systems Architect Middleware Services Wells Fargo Services Company Office --415.222.5226 PCS -- 415.254.3831 (4152543831@mobile.att.net) Views expressed are mine. Only in unusual circumstances are they shared by my employer.