IO error - please help
От | Yuva Chandolu |
---|---|
Тема | IO error - please help |
Дата | |
Msg-id | A0F24737FCB34F489EC955D143BDD8510173E0FE@exchange-sf1.corp.ebates.com обсуждение исходный текст |
Список | pgsql-hackers |
Hi, We had seen the following exception when we tried for a heavy query(around 10000 to 20000 in result is possible) An I/O error occured while reading from backend - Exception: java.net.SocketException: socket closed: Bad file number Stack Trace: java.net.SocketException: socket closed: Bad file number at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:90) at java.io.BufferedInputStream.fill(BufferedInputStream.java:186) at java.io.BufferedInputStream.read(BufferedInputStream.java:204) at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:141) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:68) 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) at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement .java:99) at com.ebates.payments.PaymentsDatabaseHandler.getPendingUserRebates(Pay mentsDatabaseHandler.java:751) Any idea what level it is happenning? database? or the jdbc driver? We do NOT have this problem when we were on Oracle. Thanks Yuva
В списке pgsql-hackers по дате отправления: