Received: from vine.phpwebhosting.com ([216.218.184.244]) by postgresql.org (8.11.3/8.11.4) with SMTP id fB353cm57078 for ; Mon, 3 Dec 2001 00:03:38 -0500 (EST) (envelope-from frampton@codingstyle.com) Received: (qmail 3187 invoked by uid 569); 3 Dec 2001 05:03:39 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 3 Dec 2001 05:03:39 -0000 Date: Sun, 2 Dec 2001 21:03:36 -0800 (PST) From: Steve Frampton X-X-Sender: To: Subject: ODBC queries die; "Unexpected protocol character from backend" In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/43 X-Sequence-Number: 2767 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello: I have a PostgreSQL 7.1.3 system which is accessed from an Apache CGI handler via ODBC (driven by libiodbc-3.0.5). It has worked very well, but on two occasions queries just stop working. The Apache error log shows: Unknown error; Unexpected protocol character from backend (send_query), SQLSTATE=S1000 Unexpected protocol character from backend (send_query), SQLSTATE=S1000 and not much else. If I stop and restart the Apache handler, the problem is resolved -- until the next time. I see nothing in the PostgreSQL logs on the database server which would describe a possible cause. I'm not sure if it is related (it probably is), but the PostgreSQL logs contain many lines of the form: pq_flush: send() failed: Broken pipe Prior to these lines were occasional lines: pq_recvbuf: unexpected EOF on client connection but I would assume the user just hit stop on their client browser rather than waiting for the query to finish. Any advice would be appreciated. - -----------------< codingstyle.com: What's your style? >---------------- Steve Frampton http://www.codingstyle.com GNU Privacy Guard ID: 99F18E3A (see http://www.gnupg.org/ for details) GNU-PG Fingerprint: 244D FA2F 5EAB 6F52 41B4 8FB4 D4F4 0738 99F1 8E3A -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8Cwer1PQHOJnxjjoRAq/hAJ0XmYVk9GgYuAlNJimRMEDmlFi3SgCfSLhq SESw7ymO6zoY/muv70buu/A= =KGtZ -----END PGP SIGNATURE-----