ODBC queries die; "Unexpected protocol character from backend"

Поиск
Список
Период
Сортировка
От Steve Frampton
Тема ODBC queries die; "Unexpected protocol character from backend"
Дата
Msg-id Pine.LNX.4.33.0112021959160.25274-100000@vine.phpwebhosting.com
обсуждение исходный текст
Список pgsql-admin
-----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-----


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Yanek Korff"
Дата:
Сообщение: duplicate templates, wrong users
Следующее
От: Morten Sickel
Дата:
Сообщение: Time zone setting