Re: Please Help JDBC Error!! - Mailing list pgsql-general

Binoy,

What would be more informative is what error was reported on the
postgresql server (I am assuming you have logging for the server
enabled).  This JDBC client trace only indicates that the server dropped
the socket connection.  The real issue is why the server did that.

thanks,
--Barry

Binoy wrote:

> Hi
> I have been  using postgres database since last 7 months working on a
> involving JBoss server as an application server and postgres database at
> backend lately.. i noticed as the database started growing larger.. today
> encountered some error while firing this query
>
> select firstname , last name from mycustomers where firstname between 'A%'
> and 'Z%'
>
> the above query returns 6000 + records ;-)
>
> I am using PostgreSQL 7.1.2 and JBoss2.2.2 with jetty 3.1
>
> The error stack trace is :
> [Jetty] An I/O error occured while reading from backend - Exception:
> java.net.SocketException: Connection reset by peer: JVM_recv in socket input
> stream read
> Stack Trace:
>
> java.net.SocketException: Connection reset by peer: JVM_recv in socket input
> stream read
>  at java.net.SocketInputStream.socketRead(Native Method)
>  at java.net.SocketInputStream.read(Unknown Source)
>  at java.io.BufferedInputStream.fill(Unknown Source)
>  at java.io.BufferedInputStream.read(Unknown Source)
>  at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
>  at org.postgresql.Connection.ExecSQL(Connection.java:473)
>  at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
>  at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
>  at
> org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1
> 08)
>  at
> org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
> ementInPool.java:71)
>  at
> org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab
> aseServerLoginModule.java:94)
>  at
> org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo
> rdLoginModule.java:82)
>  at java.lang.reflect.Method.invoke(Native Method)
>  at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595)
>  at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125)
>  at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at
> javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528)
>  at javax.security.auth.login.LoginContext.login(LoginContext.java:449)
>  at
> org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana
> ger.java:333)
>  at
> org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana
> ger.java:301)
>  at
> org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j
> ava:193)
>  at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
>  at
> com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler.
> java:259)
>  at
> com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler
> .java:192)
>  at
> com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163)
>  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956)
>  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913)
>  at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703)
>  at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508)
>  at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347)
>  at
> com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107)
>  at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294)
>  at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613)
>  at java.lang.Thread.run(Unknown Source)
> End of Stack Trace
>
> [Jetty]  at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184)
> [Jetty]  at org.postgresql.Connection.ExecSQL(Connection.java:473)
> [Jetty]  at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
> [Jetty]  at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
> [Jetty]  at
> org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1
> 08)
> [Jetty]  at
> org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
> ementInPool.java:71)
> [Jetty]  at
> org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab
> aseServerLoginModule.java:94)
> [Jetty]  at
> org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo
> rdLoginModule.java:82)
> [Jetty]  at java.lang.reflect.Method.invoke(Native Method)
> [Jetty]  at
> javax.security.auth.login.LoginContext.invoke(LoginContext.java:595)
> [Jetty]  at
> javax.security.auth.login.LoginContext.access$000(LoginContext.java:125)
> [Jetty]  at
> javax.security.auth.login.LoginContext$3.run(LoginContext.java:531)
> [Jetty]  at java.security.AccessController.doPrivileged(Native Method)
> [Jetty]  at
> javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528)
> [Jetty]  at
> javax.security.auth.login.LoginContext.login(LoginContext.java:449)
> [Jetty]  at
> org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana
> ger.java:333)
> [Jetty]  at
> org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana
> ger.java:301)
> [Jetty]  at
> org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j
> ava:193)
> [Jetty]  at
> org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
> [Jetty]  at
> com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler.
> java:259)
> [Jetty]  at
> com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler
> .java:192)
> [Jetty]  at
> com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163)
> [Jetty]  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956)
> [Jetty]  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913)
> [Jetty]  at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703)
> [Jetty]  at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508)
> [Jetty]  at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347)
> [Jetty]  at
> com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107)
> [Jetty]  at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294)
> [Jetty]  at
> com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613)
> [Jetty]  at java.lang.Thread.run(Unknown Source)
>
> I guess this is a jdbc error and i am stuck without the problem solved.. is
> there any body who has faced this kind of problem yet.. and do you have a
> probable solution please let me know
>
> Cheers :-)
>
> Binoy
>
> Rishabh Software
> (India)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>