From: | "Geoffrey Ritchey" <ritcheyg(at)mail(dot)wbu(dot)edu> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Unknown Response Type [some random character] |
Date: | 2002-04-16 22:47:37 |
Message-ID: | NFBBJNOLPACPPLLMBDPKAEMAEMAB.ritcheyg@mail.wbu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Your name :Kexin Wang
Your email address :wangkx(at)wbu(dot)edu
Your name :Geoffrey Ritchey
Your email address :ritcheyg(at)wbu(dot)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:
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-16 23:19:30 | Re: [HACKERS] Foreign Key woes -- 7.2 and ~7.3 |
Previous Message | Bruce Momjian | 2002-04-16 19:27:08 | Re: Case sensitivity in psql/pg_dump |