From: Steve Frampton <frampton@codingstyle.com>
To: pgsql-admin@postgresql.org
Subject: ODBC queries die; "Unexpected protocol character from backend"
Date: Sun, 2 Dec 2001 21:03:36 -0800 (PST)
Message-ID: <Pine.LNX.4.33.0112021959160.25274-100000@vine.phpwebhosting.com> (raw)
In-Reply-To: <Pine.BSF.4.21.0110181221150.27862-100000@megazone23.bigpanda.com>
-----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 <frampton@codingstyle.com> 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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: frampton@codingstyle.com, pgsql-admin@postgresql.org
Subject: Re: ODBC queries die; "Unexpected protocol character from backend"
In-Reply-To: <Pine.LNX.4.33.0112021959160.25274-100000@vine.phpwebhosting.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox