Thread: my problem for i/o error when i use postgre

shiguoying wrote:
> Hello everybody work for postgre: I have a problem for i/o error when
> i using java programming.it happend when I disconnect database.but
> ,i'm not sure its database'bug or my programming'bug.I follow a text
> in attachment. I hope your help! thanks ! eagle shi from china

The error is:

description The server encountered an internal error () that prevented
it from fulfilling this request.

exception

javax.servlet.ServletException: Hibernate operation: could not execute
query; uncategorized SQLException for SQL [select tproductty0_.typeid as
typeid9_, tproductty0_.parentid as parentid9_, tproductty0_.isleaf as
isleaf9_, tproductty0_.typename as typename9_, tproductty0_.comments as
comments9_, tproductty0_.menuorder as menuorder9_ from
public.t_product_type tproductty0_ where tproductty0_.parentid=? order
by tproductty0_.menuorder desc]; SQL state [08006]; error code [0]; An
I/O error occured while sending to the backend.; nested exception is
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.

It looks like there was a crash on the backend. What do your PostgreSQL
server logs show?

--
   Richard Huxton
   Archonet Ltd

On Mon, 10 Mar 2008, shiguoying wrote:

> I have a problem for i/o error when i using java programming.it happend
> when I disconnect database.but ,i'm not sure its database'bug or my
> programming'bug.I follow a text in attachment.

Well, if you disconnected the database, there's no bug there; these all
look like the regular exceptions that Hibernate/Spring throw when the
database disappears.  If you want to recover from them usefully you'll
have to update your application code to handle that.

If the database crashed without you touching anything that might be a
database bug, but in that case it would be the PostgreSQL logs that have
useful information rather than these.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD