Unknown Response Type [some random character]

Поиск
Список
Период
Сортировка
От Geoffrey Ritchey
Тема Unknown Response Type [some random character]
Дата
Msg-id NFBBJNOLPACPPLLMBDPKAEMAEMAB.ritcheyg@mail.wbu.edu
обсуждение исходный текст
Список pgsql-bugs
Your name               :Kexin Wang
Your email address      :wangkx@wbu.edu

Your name               :Geoffrey Ritchey
Your email address      :ritcheyg@wbu.edu

System Configuration
---------------------
  Architecture (example: Intel Pentium)         :Intel Pentium
  Operating System (example: Linux 2.0.26 ELF)  :Linux Mandrake 8.0
  PostgreSQL version (example: PostgreSQL-7.1.3):PostgreSQL-7.1.3
  Compiler used (example:  gcc 2.95.2)          :gcc 2.96


Please enter a FULL description of your problem:
------------------------------------------------

When running the following query I get the following stack trace.  The
problem seems to only happen after running for hours and sometimes a couple
days.  The query is usually executed every 2 minutes or so.  The actual
value of the 'response type' seems to be relatively random.

It is running from a tomcat jsp/servlet using the jdbc driver.


Execute: select id, reverse_name, ssn, address1, address2, address3,
street1, street2, city, state
, zip1, zip2, phone, work_phone, fax, email from nap where id = -1;
Unknown Response Type ^H
Unknown Response Type ^H
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:117)
        at org.postgresql.Connection.ExecSQL(Connection.java:398)
        at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
        at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
The problem seems to happen randomly.  We can't reproduce it at will.  We
are using connection pooling.  Perhaps a problem with more than one thread
using the same connection???




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Case sensitivity in psql/pg_dump
Следующее
От: Matt Olson
Дата:
Сообщение: FATAL 2: XLogWrite: write request 3/39000000 is past end of log 3/38FC2000 (fwd)